DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on FND_API

Line 1054: , p_init_msg_list => FND_API.G_FALSE

1050: THEN
1051: -- In case of error, autonomousCommit = TRUE
1052: QA_EDR_STANDARD.SEND_ACKN
1053: ( p_api_version => 1.0
1054: , p_init_msg_list => FND_API.G_FALSE
1055: , x_return_status => l_return_status
1056: , x_msg_count => l_msg_count
1057: , x_msg_data => l_msg_data
1058: , p_event_name => my_events.event_name

Line 1064: , p_autonomous_commit => FND_API.G_TRUE);

1060: , p_erecord_id => my_events.erecord_id
1061: , p_trans_status => l_trans_status
1062: , p_ackn_by => l_ackn_by
1063: , p_ackn_note => my_events.event_name||', '||my_events.event_key
1064: , p_autonomous_commit => FND_API.G_TRUE);
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
1067: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
1068: AND (l_msg_count > 0)

Line 1067: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

1063: , p_ackn_note => my_events.event_name||', '||my_events.event_key
1064: , p_autonomous_commit => FND_API.G_TRUE);
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
1067: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
1068: AND (l_msg_count > 0)
1069: THEN
1070: RAISE SEND_ACKN_ERROR;
1071: END IF;

Line 1088: p_encoded => FND_API.G_FALSE,

1084: WHEN SEND_ACKN_ERROR THEN
1085: FND_MSG_PUB.Get(
1086: p_msg_index => 1,
1087: p_data => l_msg_data,
1088: p_encoded => FND_API.G_FALSE,
1089: p_msg_index_out => l_dummy_cnt);
1090: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1091:
1092: WHEN OTHERS THEN

Line 1104: If onhand qty is found it returns FND_API.G_TRUE

1100: /***********************************************************************************
1101:
1102: procedure CHECK_ONHAND
1103: This procedure checks if there is any onhand qty available
1104: If onhand qty is found it returns FND_API.G_TRUE
1105:
1106: arguments
1107: p_inventory_item_id :config item id
1108: p_org_id : given org id

Line 1109: x_return_status : FND_API.G_TRUE

1105:
1106: arguments
1107: p_inventory_item_id :config item id
1108: p_org_id : given org id
1109: x_return_status : FND_API.G_TRUE
1110:
1111: **********************************************************************************/
1112: PROCEDURE CHECK_ONHAND(
1113: p_inventory_item_id IN NUMBER,

Line 1120: x_return_status := FND_API.G_FALSE;

1116: )
1117: IS
1118: xdummy number;
1119: BEGIN
1120: x_return_status := FND_API.G_FALSE;
1121:
1122: select transaction_quantity into xdummy
1123: from mtl_onhand_quantities
1124: where inventory_item_id = p_inventory_item_id

Line 1135: x_return_status := FND_API.G_TRUE;

1131: when no_data_found then
1132: null; -- no onhand. ok to proceed.
1133:
1134: when too_many_rows then
1135: x_return_status := FND_API.G_TRUE;
1136:
1137: when others then
1138: x_return_status := FND_API.G_TRUE;
1139:

Line 1138: x_return_status := FND_API.G_TRUE;

1134: when too_many_rows then
1135: x_return_status := FND_API.G_TRUE;
1136:
1137: when others then
1138: x_return_status := FND_API.G_TRUE;
1139:
1140:
1141: END;
1142:

Line 1158: if (l_return_status = FND_API.G_TRUE )

1154: CHECK_ONHAND(p_inventory_item_id =>p_item_id,
1155: p_org_id =>p_org_id,
1156: x_return_status =>l_return_status);
1157:
1158: if (l_return_status = FND_API.G_TRUE )
1159: then
1160: return 1;
1161: else
1162: return 0;

Line 1354: x_return_status := FND_API.G_RET_STS_SUCCESS;

1350: BEGIN
1351: --
1352: -- Initialize
1353: --
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355: IF p_eco_for_production = 2
1356: -- Do not reset the value of old component sequence_id when only
1357: -- WIPs have to be updated and the BOM changes are to be reversed.
1358: -- This is actually done for normal bills post implemntation

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: END LOOP;
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: END Move_Pending_Dest_Components;
1430:
1431: PROCEDURE Reset_Common_Comp_Details (
1432: x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

1436: BEGIN
1437: --
1438: -- Initialize
1439: --
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441: -- For each component thats been
1442: FOR i IN 1..g_common_rev_comps_cnt
1443: LOOP
1444: UPDATE bom_components_b bcb

Line 1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1467: , x_Return_Status => x_return_status);
1468: END LOOP;
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1472:
1473: END Reset_Common_Comp_Details;
1474:
1475: --Reverting the changes introduced in bug 5285282 as part of bug 14039105

Line 3540: , p_init_msg_list => FND_API.G_TRUE

3536: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3537: THEN
3538: QA_EDR_STANDARD.GET_ERECORD_ID
3539: ( p_api_version => 1.0
3540: , p_init_msg_list => FND_API.G_TRUE
3541: , x_return_status => l_return_status
3542: , x_msg_count => l_msg_count
3543: , x_msg_data => l_msg_data
3544: , p_event_name => 'oracle.apps.eng.ecoImplement'

Line 3556: , p_init_msg_list => FND_API.G_TRUE

3552: IF (l_parent_record_id IS NULL)
3553: THEN
3554: QA_EDR_STANDARD.GET_ERECORD_ID
3555: ( p_api_version => 1.0
3556: , p_init_msg_list => FND_API.G_TRUE
3557: , x_return_status => l_return_status
3558: , x_msg_count => l_msg_count
3559: , x_msg_data => l_msg_data
3560: , p_event_name => 'oracle.apps.eng.ecoCreate'

Line 3763: , p_init_msg_list => FND_API.G_FALSE

3759: , item.created_by);
3760:
3761: QA_EDR_STANDARD.RAISE_ERES_EVENT
3762: ( p_api_version => 1.0
3763: , p_init_msg_list => FND_API.G_FALSE
3764: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3765: , x_return_status => l_return_status
3766: , x_msg_count => l_msg_count
3767: , x_msg_data => l_msg_data

Line 3764: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3760:
3761: QA_EDR_STANDARD.RAISE_ERES_EVENT
3762: ( p_api_version => 1.0
3763: , p_init_msg_list => FND_API.G_FALSE
3764: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3765: , x_return_status => l_return_status
3766: , x_msg_count => l_msg_count
3767: , x_msg_data => l_msg_data
3768: , p_child_erecords => l_child_record

Line 3771: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

3767: , x_msg_data => l_msg_data
3768: , p_child_erecords => l_child_record
3769: , x_event => l_event);
3770:
3771: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
3772: AND (l_msg_count > 0)
3773: THEN
3774: RAISE ERES_EVENT_ERROR;
3775: END IF;

Line 4431: l_return_status := FND_API.G_RET_STS_SUCCESS;

4427: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4428: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4429: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4430:
4431: l_return_status := FND_API.G_RET_STS_SUCCESS;
4432: plsql_block := 'BEGIN
4433: FND_MSG_PUB.initialize ;
4434: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes
4435: ( p_api_version => 1.0

Line 4452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4448: OUT l_msg_data; -- x_msg_data
4449:
4450: FND_FILE.PUT_LINE(FND_FILE.LOG,'After: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes: Return Status=' || l_return_status);
4451:
4452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4453: THEN
4454: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4455: FND_MESSAGE.Set_Token('OBJECT_NAME'
4456: ,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes') ;

Line 4459: RAISE FND_API.G_EXC_ERROR;

4455: FND_MESSAGE.Set_Token('OBJECT_NAME'
4456: ,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes') ;
4457: FND_MSG_PUB.Add;
4458:
4459: RAISE FND_API.G_EXC_ERROR;
4460: END IF;
4461:
4462: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4463:

Line 4468: WHEN FND_API.G_EXC_ERROR THEN

4464: EXCEPTION
4465: WHEN PLSQL_COMPILE_ERROR THEN
4466: null;
4467:
4468: WHEN FND_API.G_EXC_ERROR THEN
4469:
4470: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4471: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4472: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;

Line 7104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => l_error_msg_count , p_data => l_message);

7100: FND_MESSAGE.Set_Name('ENG','ENG_SUB_COMP_ALREADY_EXISTS');
7101: FND_MESSAGE.Set_Token('SUBSTITUTE_ITEM_NAME',sub_component.item_number) ;
7102: FND_MESSAGE.Set_Token('REVISED_COMPONENT_NAME',component.item_number) ;
7103: FND_MSG_PUB.Add;
7104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => l_error_msg_count , p_data => l_message);
7105: FND_FILE.put_line(FND_FILE.LOG, l_message);
7106: If trial_mode = no then
7107: Close check_existing_substitutes;
7108: Raise abort_implementation;

Line 7751: , p_init_msg_list => FND_API.G_FALSE

7747: l_event.event_status := l_event_status;
7748:
7749: QA_EDR_STANDARD.RAISE_ERES_EVENT
7750: ( p_api_version => 1.0
7751: , p_init_msg_list => FND_API.G_FALSE
7752: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7753: , x_return_status => l_return_status
7754: , x_msg_count => l_msg_count
7755: , x_msg_data => l_msg_data

Line 7752: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7748:
7749: QA_EDR_STANDARD.RAISE_ERES_EVENT
7750: ( p_api_version => 1.0
7751: , p_init_msg_list => FND_API.G_FALSE
7752: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7753: , x_return_status => l_return_status
7754: , x_msg_count => l_msg_count
7755: , x_msg_data => l_msg_data
7756: , p_child_erecords => l_child_record

Line 7759: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

7755: , x_msg_data => l_msg_data
7756: , p_child_erecords => l_child_record
7757: , x_event => l_event);
7758:
7759: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
7760: AND (l_msg_count > 0)
7761: THEN
7762: RAISE ERES_EVENT_ERROR;
7763: END IF;

Line 7886: , p_init_msg_list => FND_API.G_FALSE

7882: l_event.event_status := l_event_status;
7883:
7884: QA_EDR_STANDARD.RAISE_ERES_EVENT
7885: ( p_api_version => 1.0
7886: , p_init_msg_list => FND_API.G_FALSE
7887: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7888: , x_return_status => l_return_status
7889: , x_msg_count => l_msg_count
7890: , x_msg_data => l_msg_data

Line 7887: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7883:
7884: QA_EDR_STANDARD.RAISE_ERES_EVENT
7885: ( p_api_version => 1.0
7886: , p_init_msg_list => FND_API.G_FALSE
7887: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7888: , x_return_status => l_return_status
7889: , x_msg_count => l_msg_count
7890: , x_msg_data => l_msg_data
7891: , p_child_erecords => l_child_record

Line 7894: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

7890: , x_msg_data => l_msg_data
7891: , p_child_erecords => l_child_record
7892: , x_event => l_event);
7893:
7894: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
7895: AND (l_msg_count > 0)
7896: THEN
7897: RAISE ERES_EVENT_ERROR;
7898: END IF;

Line 8140: || ',p_init_msg_list => FND_API.G_TRUE '

8136: || ',p_user_id => -10000 '
8137: || ',p_api_caller => ''WF'' '
8138: || ',x_change_action_id => :6 '
8139: /*
8140: || ',p_init_msg_list => FND_API.G_TRUE '
8141: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8142: || ',p_debug => FND_API.G_TRUE '
8143: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8144: || ',p_debug_filename => ''engact.createAct4Imp.log'' '

Line 8141: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '

8137: || ',p_api_caller => ''WF'' '
8138: || ',x_change_action_id => :6 '
8139: /*
8140: || ',p_init_msg_list => FND_API.G_TRUE '
8141: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8142: || ',p_debug => FND_API.G_TRUE '
8143: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8144: || ',p_debug_filename => ''engact.createAct4Imp.log'' '
8145: */

Line 8142: || ',p_debug => FND_API.G_TRUE '

8138: || ',x_change_action_id => :6 '
8139: /*
8140: || ',p_init_msg_list => FND_API.G_TRUE '
8141: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8142: || ',p_debug => FND_API.G_TRUE '
8143: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8144: || ',p_debug_filename => ''engact.createAct4Imp.log'' '
8145: */
8146: || '); END;';

Line 8193: || ',p_init_msg_list => FND_API.G_TRUE '

8189: || ',p_action_id => :6 '
8190: || ',p_wf_user_id => -10000 '
8191: || ',p_route_id => 0 '
8192: /*
8193: || ',p_init_msg_list => FND_API.G_TRUE '
8194: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8195: || ',p_debug => FND_API.G_TRUE '
8196: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8197: || ',p_debug_filename => ''engact.startWF4Imp.log'' '

Line 8194: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '

8190: || ',p_wf_user_id => -10000 '
8191: || ',p_route_id => 0 '
8192: /*
8193: || ',p_init_msg_list => FND_API.G_TRUE '
8194: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8195: || ',p_debug => FND_API.G_TRUE '
8196: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8197: || ',p_debug_filename => ''engact.startWF4Imp.log'' '
8198: */

Line 8195: || ',p_debug => FND_API.G_TRUE '

8191: || ',p_route_id => 0 '
8192: /*
8193: || ',p_init_msg_list => FND_API.G_TRUE '
8194: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
8195: || ',p_debug => FND_API.G_TRUE '
8196: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
8197: || ',p_debug_filename => ''engact.startWF4Imp.log'' '
8198: */
8199: || '); END;';

Line 8865: p_encoded => FND_API.G_FALSE,

8861:
8862: FND_MSG_PUB.Get(
8863: p_msg_index => 1,
8864: p_data => l_message,
8865: p_encoded => FND_API.G_FALSE,
8866: p_msg_index_out => l_dummy_cnt);
8867:
8868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);

Line 9288: l_return_status := FND_API.G_RET_STS_SUCCESS;

9284:
9285: -- First trying to implement the revised item attachment changes
9286: -- Changes For bug 3402607
9287: BEGIN
9288: l_return_status := FND_API.G_RET_STS_SUCCESS;
9289: /*ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change(
9290: p_api_version => 1.0
9291: ,p_change_id => l_change_id
9292: ,p_rev_item_seq_id =>revised_item

Line 9326: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) = FND_API.G_RET_STS_SUCCESS)

9322:
9323: -- Also implement item related document here. Both attachment changes and item related document
9324: -- changes do not have any date effectivity, that is why it is added here..only when attachment impl is successfull
9325: BEGIN
9326: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) = FND_API.G_RET_STS_SUCCESS)
9327: THEN
9328: l_return_status := FND_API.G_RET_STS_SUCCESS;
9329:
9330: l_plsql_block := 'begin ENG_RELATED_ENTITY_PKG.Implement_Relationship_Changes('

Line 9328: l_return_status := FND_API.G_RET_STS_SUCCESS;

9324: -- changes do not have any date effectivity, that is why it is added here..only when attachment impl is successfull
9325: BEGIN
9326: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) = FND_API.G_RET_STS_SUCCESS)
9327: THEN
9328: l_return_status := FND_API.G_RET_STS_SUCCESS;
9329:
9330: l_plsql_block := 'begin ENG_RELATED_ENTITY_PKG.Implement_Relationship_Changes('
9331: || ' p_api_version => 1.0 '
9332: || ' , p_change_id => :1 '

Line 9363: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS)

9359: << error_block >>
9360: null;
9361:
9362: BEGIN
9363: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS)
9364: THEN
9365: msg_qty := msg_qty + 1;
9366: token1(msg_qty) := null;
9367: value1(msg_qty) := null;

Line 9562: IF FND_API.To_Boolean(p_autonomous_commit) THEN

9558: common_bom_is_running EXCEPTION;
9559:
9560: BEGIN
9561: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure Start *********') ;
9562: IF FND_API.To_Boolean(p_autonomous_commit) THEN
9563: SELECT B.BILL_SEQUENCE_ID INTO l_bill_sequence_id
9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R
9565: WHERE R.REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id
9566: AND R.REVISED_ITEM_ID = B.ASSEMBLY_ITEM_ID