DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on FND_API

Line 982: , p_init_msg_list => FND_API.G_FALSE

978: THEN
979: -- In case of error, autonomousCommit = TRUE
980: QA_EDR_STANDARD.SEND_ACKN
981: ( p_api_version => 1.0
982: , p_init_msg_list => FND_API.G_FALSE
983: , x_return_status => l_return_status
984: , x_msg_count => l_msg_count
985: , x_msg_data => l_msg_data
986: , p_event_name => my_events.event_name

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

988: , p_erecord_id => my_events.erecord_id
989: , p_trans_status => l_trans_status
990: , p_ackn_by => l_ackn_by
991: , p_ackn_note => my_events.event_name||', '||my_events.event_key
992: , p_autonomous_commit => FND_API.G_TRUE);
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
995: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
996: AND (l_msg_count > 0)

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

991: , p_ackn_note => my_events.event_name||', '||my_events.event_key
992: , p_autonomous_commit => FND_API.G_TRUE);
993:
994: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||l_msg_count);
995: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
996: AND (l_msg_count > 0)
997: THEN
998: RAISE SEND_ACKN_ERROR;
999: END IF;

Line 1016: p_encoded => FND_API.G_FALSE,

1012: WHEN SEND_ACKN_ERROR THEN
1013: FND_MSG_PUB.Get(
1014: p_msg_index => 1,
1015: p_data => l_msg_data,
1016: p_encoded => FND_API.G_FALSE,
1017: p_msg_index_out => l_dummy_cnt);
1018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACKN Error: '||l_msg_data);
1019:
1020: WHEN OTHERS THEN

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

1028: /***********************************************************************************
1029:
1030: procedure CHECK_ONHAND
1031: This procedure checks if there is any onhand qty available
1032: If onhand qty is found it returns FND_API.G_TRUE
1033:
1034: arguments
1035: p_inventory_item_id :config item id
1036: p_org_id : given org id

Line 1037: x_return_status : FND_API.G_TRUE

1033:
1034: arguments
1035: p_inventory_item_id :config item id
1036: p_org_id : given org id
1037: x_return_status : FND_API.G_TRUE
1038:
1039: **********************************************************************************/
1040: PROCEDURE CHECK_ONHAND(
1041: p_inventory_item_id IN NUMBER,

Line 1048: x_return_status := FND_API.G_FALSE;

1044: )
1045: IS
1046: xdummy number;
1047: BEGIN
1048: x_return_status := FND_API.G_FALSE;
1049:
1050: select transaction_quantity into xdummy
1051: from mtl_onhand_quantities
1052: where inventory_item_id = p_inventory_item_id

Line 1063: x_return_status := FND_API.G_TRUE;

1059: when no_data_found then
1060: null; -- no onhand. ok to proceed.
1061:
1062: when too_many_rows then
1063: x_return_status := FND_API.G_TRUE;
1064:
1065: when others then
1066: x_return_status := FND_API.G_TRUE;
1067:

Line 1066: x_return_status := FND_API.G_TRUE;

1062: when too_many_rows then
1063: x_return_status := FND_API.G_TRUE;
1064:
1065: when others then
1066: x_return_status := FND_API.G_TRUE;
1067:
1068:
1069: END;
1070:

Line 1086: if (l_return_status = FND_API.G_TRUE )

1082: CHECK_ONHAND(p_inventory_item_id =>p_item_id,
1083: p_org_id =>p_org_id,
1084: x_return_status =>l_return_status);
1085:
1086: if (l_return_status = FND_API.G_TRUE )
1087: then
1088: return 1;
1089: else
1090: return 0;

Line 1282: x_return_status := FND_API.G_RET_STS_SUCCESS;

1278: BEGIN
1279: --
1280: -- Initialize
1281: --
1282: x_return_status := FND_API.G_RET_STS_SUCCESS;
1283: IF p_eco_for_production = 2
1284: -- Do not reset the value of old component sequence_id when only
1285: -- WIPs have to be updated and the BOM changes are to be reversed.
1286: -- This is actually done for normal bills post implemntation

Line 1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1352: END LOOP;
1353: END IF;
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: END Move_Pending_Dest_Components;
1358:
1359: PROCEDURE Reset_Common_Comp_Details (
1360: x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1368: x_return_status := FND_API.G_RET_STS_SUCCESS;

1364: BEGIN
1365: --
1366: -- Initialize
1367: --
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: -- For each component thats been
1370: FOR i IN 1..g_common_rev_comps_cnt
1371: LOOP
1372: UPDATE bom_components_b bcb

Line 1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1395: , x_Return_Status => x_return_status);
1396: END LOOP;
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400:
1401: END Reset_Common_Comp_Details;
1402:
1403:

Line 3296: , p_init_msg_list => FND_API.G_TRUE

3292: IF ( NVL( l_eres_enabled, 'N') = 'Y')
3293: THEN
3294: QA_EDR_STANDARD.GET_ERECORD_ID
3295: ( p_api_version => 1.0
3296: , p_init_msg_list => FND_API.G_TRUE
3297: , x_return_status => l_return_status
3298: , x_msg_count => l_msg_count
3299: , x_msg_data => l_msg_data
3300: , p_event_name => 'oracle.apps.eng.ecoImplement'

Line 3312: , p_init_msg_list => FND_API.G_TRUE

3308: IF (l_parent_record_id IS NULL)
3309: THEN
3310: QA_EDR_STANDARD.GET_ERECORD_ID
3311: ( p_api_version => 1.0
3312: , p_init_msg_list => FND_API.G_TRUE
3313: , x_return_status => l_return_status
3314: , x_msg_count => l_msg_count
3315: , x_msg_data => l_msg_data
3316: , p_event_name => 'oracle.apps.eng.ecoCreate'

Line 3519: , p_init_msg_list => FND_API.G_FALSE

3515: , item.created_by);
3516:
3517: QA_EDR_STANDARD.RAISE_ERES_EVENT
3518: ( p_api_version => 1.0
3519: , p_init_msg_list => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3523: , x_msg_data => l_msg_data

Line 3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

3516:
3517: QA_EDR_STANDARD.RAISE_ERES_EVENT
3518: ( p_api_version => 1.0
3519: , p_init_msg_list => FND_API.G_FALSE
3520: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3521: , x_return_status => l_return_status
3522: , x_msg_count => l_msg_count
3523: , x_msg_data => l_msg_data
3524: , p_child_erecords => l_child_record

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

3523: , x_msg_data => l_msg_data
3524: , p_child_erecords => l_child_record
3525: , x_event => l_event);
3526:
3527: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
3528: AND (l_msg_count > 0)
3529: THEN
3530: RAISE ERES_EVENT_ERROR;
3531: END IF;

Line 4173: l_return_status := FND_API.G_RET_STS_SUCCESS;

4169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Implement Item Pending Changes ');
4170: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes ');
4172:
4173: l_return_status := FND_API.G_RET_STS_SUCCESS;
4174: plsql_block := 'BEGIN
4175: FND_MSG_PUB.initialize ;
4176: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes
4177: ( p_api_version => 1.0

Line 4194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4190: OUT l_msg_data; -- x_msg_data
4191:
4192: FND_FILE.PUT_LINE(FND_FILE.LOG,'After: ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes: Return Status=' || l_return_status);
4193:
4194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4195: THEN
4196: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4197: FND_MESSAGE.Set_Token('OBJECT_NAME'
4198: ,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes') ;

Line 4201: RAISE FND_API.G_EXC_ERROR;

4197: FND_MESSAGE.Set_Token('OBJECT_NAME'
4198: ,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes') ;
4199: FND_MSG_PUB.Add;
4200:
4201: RAISE FND_API.G_EXC_ERROR;
4202: END IF;
4203:
4204: FND_FILE.PUT_LINE(FND_FILE.LOG,'==================================================');
4205:

Line 4210: WHEN FND_API.G_EXC_ERROR THEN

4206: EXCEPTION
4207: WHEN PLSQL_COMPILE_ERROR THEN
4208: null;
4209:
4210: WHEN FND_API.G_EXC_ERROR THEN
4211:
4212: FND_FILE.PUT_LINE(FND_FILE.LOG,'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes failed ');
4213: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------------');
4214: -- ROLLBACK TO SAVEPOINT ITEM_CHG ;

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

6782: FND_MESSAGE.Set_Name('ENG','ENG_SUB_COMP_ALREADY_EXISTS');
6783: FND_MESSAGE.Set_Token('SUBSTITUTE_ITEM_NAME',sub_component.item_number) ;
6784: FND_MESSAGE.Set_Token('REVISED_COMPONENT_NAME',component.item_number) ;
6785: FND_MSG_PUB.Add;
6786: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE, p_count => l_error_msg_count , p_data => l_message);
6787: FND_FILE.put_line(FND_FILE.LOG, l_message);
6788: If trial_mode = no then
6789: Close check_existing_substitutes;
6790: Raise abort_implementation;

Line 7428: , p_init_msg_list => FND_API.G_FALSE

7424: l_event.event_status := l_event_status;
7425:
7426: QA_EDR_STANDARD.RAISE_ERES_EVENT
7427: ( p_api_version => 1.0
7428: , p_init_msg_list => FND_API.G_FALSE
7429: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7430: , x_return_status => l_return_status
7431: , x_msg_count => l_msg_count
7432: , x_msg_data => l_msg_data

Line 7429: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7425:
7426: QA_EDR_STANDARD.RAISE_ERES_EVENT
7427: ( p_api_version => 1.0
7428: , p_init_msg_list => FND_API.G_FALSE
7429: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7430: , x_return_status => l_return_status
7431: , x_msg_count => l_msg_count
7432: , x_msg_data => l_msg_data
7433: , p_child_erecords => l_child_record

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

7432: , x_msg_data => l_msg_data
7433: , p_child_erecords => l_child_record
7434: , x_event => l_event);
7435:
7436: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
7437: AND (l_msg_count > 0)
7438: THEN
7439: RAISE ERES_EVENT_ERROR;
7440: END IF;

Line 7563: , p_init_msg_list => FND_API.G_FALSE

7559: l_event.event_status := l_event_status;
7560:
7561: QA_EDR_STANDARD.RAISE_ERES_EVENT
7562: ( p_api_version => 1.0
7563: , p_init_msg_list => FND_API.G_FALSE
7564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7565: , x_return_status => l_return_status
7566: , x_msg_count => l_msg_count
7567: , x_msg_data => l_msg_data

Line 7564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7560:
7561: QA_EDR_STANDARD.RAISE_ERES_EVENT
7562: ( p_api_version => 1.0
7563: , p_init_msg_list => FND_API.G_FALSE
7564: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7565: , x_return_status => l_return_status
7566: , x_msg_count => l_msg_count
7567: , x_msg_data => l_msg_data
7568: , p_child_erecords => l_child_record

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

7567: , x_msg_data => l_msg_data
7568: , p_child_erecords => l_child_record
7569: , x_event => l_event);
7570:
7571: IF (NVL(l_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
7572: AND (l_msg_count > 0)
7573: THEN
7574: RAISE ERES_EVENT_ERROR;
7575: END IF;

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

7813: || ',p_user_id => -10000 '
7814: || ',p_api_caller => ''WF'' '
7815: || ',x_change_action_id => :6 '
7816: /*
7817: || ',p_init_msg_list => FND_API.G_TRUE '
7818: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7819: || ',p_debug => FND_API.G_TRUE '
7820: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7821: || ',p_debug_filename => ''engact.createAct4Imp.log'' '

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

7814: || ',p_api_caller => ''WF'' '
7815: || ',x_change_action_id => :6 '
7816: /*
7817: || ',p_init_msg_list => FND_API.G_TRUE '
7818: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7819: || ',p_debug => FND_API.G_TRUE '
7820: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7821: || ',p_debug_filename => ''engact.createAct4Imp.log'' '
7822: */

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

7815: || ',x_change_action_id => :6 '
7816: /*
7817: || ',p_init_msg_list => FND_API.G_TRUE '
7818: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7819: || ',p_debug => FND_API.G_TRUE '
7820: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7821: || ',p_debug_filename => ''engact.createAct4Imp.log'' '
7822: */
7823: || '); END;';

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

7848: || ',p_action_id => :6 '
7849: || ',p_wf_user_id => -10000 '
7850: || ',p_route_id => 0 '
7851: /*
7852: || ',p_init_msg_list => FND_API.G_TRUE '
7853: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7854: || ',p_debug => FND_API.G_TRUE '
7855: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7856: || ',p_debug_filename => ''engact.startWF4Imp.log'' '

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

7849: || ',p_wf_user_id => -10000 '
7850: || ',p_route_id => 0 '
7851: /*
7852: || ',p_init_msg_list => FND_API.G_TRUE '
7853: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7854: || ',p_debug => FND_API.G_TRUE '
7855: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7856: || ',p_debug_filename => ''engact.startWF4Imp.log'' '
7857: */

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

7850: || ',p_route_id => 0 '
7851: /*
7852: || ',p_init_msg_list => FND_API.G_TRUE '
7853: || ',p_validation_level => FND_API.G_VALID_LEVEL_FULL '
7854: || ',p_debug => FND_API.G_TRUE '
7855: || ',p_output_dir => ''/appslog/bis_top/utl/plm115dt/log'' '
7856: || ',p_debug_filename => ''engact.startWF4Imp.log'' '
7857: */
7858: || '); END;';

Line 8521: p_encoded => FND_API.G_FALSE,

8517:
8518: FND_MSG_PUB.Get(
8519: p_msg_index => 1,
8520: p_data => l_message,
8521: p_encoded => FND_API.G_FALSE,
8522: p_msg_index_out => l_dummy_cnt);
8523:
8524: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error while creating event='||l_child_event_name||', key='||l_event.event_key);
8525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERES_EVENT_ERROR: '||l_message);

Line 8943: l_return_status := FND_API.G_RET_STS_SUCCESS;

8939:
8940: -- First trying to implement the revised item attachment changes
8941: -- Changes For bug 3402607
8942: BEGIN
8943: l_return_status := FND_API.G_RET_STS_SUCCESS;
8944: /*ENG_ATTACHMENT_IMPLEMENTATION.Implement_Attachment_Change(
8945: p_api_version => 1.0
8946: ,p_change_id => l_change_id
8947: ,p_rev_item_seq_id =>revised_item

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

8977:
8978: -- Also implement item related document here. Both attachment changes and item related document
8979: -- changes do not have any date effectivity, that is why it is added here..only when attachment impl is successfull
8980: BEGIN
8981: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) = FND_API.G_RET_STS_SUCCESS)
8982: THEN
8983: l_return_status := FND_API.G_RET_STS_SUCCESS;
8984:
8985: l_plsql_block := 'begin ENG_RELATED_ENTITY_PKG.Implement_Relationship_Changes('

Line 8983: l_return_status := FND_API.G_RET_STS_SUCCESS;

8979: -- changes do not have any date effectivity, that is why it is added here..only when attachment impl is successfull
8980: BEGIN
8981: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) = FND_API.G_RET_STS_SUCCESS)
8982: THEN
8983: l_return_status := FND_API.G_RET_STS_SUCCESS;
8984:
8985: l_plsql_block := 'begin ENG_RELATED_ENTITY_PKG.Implement_Relationship_Changes('
8986: || ' p_api_version => 1.0 '
8987: || ' , p_change_id => :1 '

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

9014: << error_block >>
9015: null;
9016:
9017: BEGIN
9018: IF (NVL(l_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS)
9019: THEN
9020: msg_qty := msg_qty + 1;
9021: token1(msg_qty) := null;
9022: value1(msg_qty) := null;