DBA Data[Home] [Help]

APPS.POR_UDA_PKG dependencies on FND_API

Line 145: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

141: FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;
142:
143: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('PREPARER_ID', l_preparer_id || '', l_external_attr_value_pairs);
144: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ORG_ID', l_org_id || '', l_external_attr_value_pairs);
145: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
146: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
147: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
148: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
149:

Line 152: l_final_return_status := FND_API.G_RET_STS_SUCCESS;

148: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
149:
150: -- To initialize the messages list.
151: fnd_msg_pub.Initialize();
152: l_final_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: POR_UDA_PKG.UDA_SUBMISSION_CHECK
155: (
156: p_pk1_value => p_req_header_id

Line 167: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

163: ,uda_return_status => l_uda_return_status
164: ,uda_msg_data => l_uda_msg_data
165: );
166:
167: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
168: l_final_return_status := l_uda_return_status; -- FND_API.G_RET_STS_ERROR;
169: --l_final_msg_data := l_final_msg_data || l_uda_msg_data ;
170: END IF;
171:

Line 168: l_final_return_status := l_uda_return_status; -- FND_API.G_RET_STS_ERROR;

164: ,uda_msg_data => l_uda_msg_data
165: );
166:
167: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
168: l_final_return_status := l_uda_return_status; -- FND_API.G_RET_STS_ERROR;
169: --l_final_msg_data := l_final_msg_data || l_uda_msg_data ;
170: END IF;
171:
172: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 172: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

168: l_final_return_status := l_uda_return_status; -- FND_API.G_RET_STS_ERROR;
169: --l_final_msg_data := l_final_msg_data || l_uda_msg_data ;
170: END IF;
171:
172: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
173:
174: --Loop through all the lines for this PR to default UDA's
175: FOR c_get_lines_rec IN c_get_lines(p_req_header_id) LOOP
176:

Line 200: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

196: ,uda_return_status => l_uda_return_status
197: ,uda_msg_data => l_uda_msg_data
198: );
199:
200: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
201: l_final_return_status := l_uda_return_status; --FND_API.G_RET_STS_ERROR;
202: -- l_final_msg_data := l_final_msg_data || l_uda_msg_data ;
203: END IF;
204:

Line 201: l_final_return_status := l_uda_return_status; --FND_API.G_RET_STS_ERROR;

197: ,uda_msg_data => l_uda_msg_data
198: );
199:
200: IF(l_uda_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
201: l_final_return_status := l_uda_return_status; --FND_API.G_RET_STS_ERROR;
202: -- l_final_msg_data := l_final_msg_data || l_uda_msg_data ;
203: END IF;
204:
205:

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: BEGIN
312:
313: d_progress := 10;
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
317: l_attr_group_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();
318:
319: d_progress := 20;

Line 501: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

497: );
498:
499: d_progress := 110;
500:
501: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
502:
503: ego_user_attrs_data_pub.Get_User_Attrs_Data
504: (
505: p_api_version => 1.0

Line 521: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

517: END IF;
518:
519: d_progress := 120;
520:
521: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
522:
523: d_progress := 130;
524:
525: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

Line 714: ,p_commit => FND_API.G_FALSE

710: ,from_pk_col_value_pairs => l_from_pk_col_value_pairs
711: ,to_pk_col_value_pairs => l_to_pk_col_value_pairs
712: ,copy_attribute_groups => 'EXCLUSIVE' -- SPECIFIC / EXCLUSIVE
713: ,attribute_group_table => l_attribute_group_table
714: ,p_commit => FND_API.G_FALSE
715: ,x_return_status => l_return_status
716: ,x_msg_count => l_msg_count
717: ,x_msg_data => l_msg_data
718: );

Line 813: ,p_commit => FND_API.G_FALSE

809: ,to_template_id => l_template_id
810: ,from_pk_col_value_pairs => l_from_pk_col_value_pairs
811: ,to_pk_col_value_pairs => l_to_pk_col_value_pairs
812: ,copy_attribute_groups => 'ALL' -- SPECIFIC / EXCLUSIVE
813: ,p_commit => FND_API.G_FALSE
814: ,x_return_status => l_return_status
815: ,x_msg_count => l_msg_count
816: ,x_msg_data => l_msg_data
817: );

Line 884: ,x_commit => FND_API.G_FALSE

880: x_template_id => l_template_id
881: ,x_from_pk_col_value_pairs => l_from_pk_col_value_pairs
882: ,x_to_pk_col_value_pairs => l_to_pk_col_value_pairs
883: ,x_copy_attribute_groups => 'ALL' -- SPECIFIC / EXCLUSIVE
884: ,x_commit => FND_API.G_FALSE
885: ,x_return_status => l_return_status
886: ,x_msg_count => l_msg_count
887: ,x_msg_data => l_msg_data
888: );

Line 971: ,x_commit => FND_API.G_FALSE

967: x_template_id => l_template_id
968: ,x_from_pk_col_value_pairs => l_from_pk_col_value_pairs
969: ,x_to_pk_col_value_pairs => l_to_pk_col_value_pairs
970: ,x_copy_attribute_groups => 'ALL' -- SPECIFIC / EXCLUSIVE
971: ,x_commit => FND_API.G_FALSE
972: ,x_return_status => l_return_status
973: ,x_msg_count => l_msg_count
974: ,x_msg_data => l_msg_data
975: );

Line 1093: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1089: ,x_msg_count => l_msg_count
1090: ,x_msg_data => l_msg_data
1091: );
1092:
1093: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1094:
1095: --Loop through all the lines for this PR to default UDA's
1096: FOR c_get_lines_rec IN c_get_lines(p_req_header_id) LOOP
1097:

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1545:
1546: from PO_req_HEADERS_EXT_TL where extension_id = l_old_hdr_ext_id;
1547:
1548:
1549: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1550:
1551:
1552: EXCEPTION
1553: WHEN others THEN