eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_API_WRP dependencies on FND_API

Line 104: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

100: /******************
101: * Local variables *
102: ******************/
103: l_status VARCHAR2(11);
104: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
105: l_count NUMBER(10) ;
106: l_record_count NUMBER(10) :=0;
107: l_loop_cnt NUMBER(10) :=0;
108: l_dummy_cnt NUMBER(10) :=0;

Line 324: p_init_msg_list => FND_API.G_TRUE,

320: IF l_skip_details = 'N' THEN
321: GMF_ItemCost_PUB.Create_Item_Cost
322: (
323: p_api_version => 3.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_TRUE,
326: x_return_status => l_status,
327: x_msg_count => l_count,
328: x_msg_data => l_data,

Line 325: p_commit => FND_API.G_TRUE,

321: GMF_ItemCost_PUB.Create_Item_Cost
322: (
323: p_api_version => 3.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_TRUE,
326: x_return_status => l_status,
327: x_msg_count => l_count,
328: x_msg_data => l_data,
329: p_header_rec => l_header_rec,

Line 346: p_init_msg_list => FND_API.G_TRUE,

342: -- DBMS_OUTPUT.PUT_LINE('Calling Create_Item_Cost API...');
343: GMF_ItemCost_PUB.Create_Item_Cost
344: (
345: p_api_version => 3.0,
346: p_init_msg_list => FND_API.G_TRUE,
347: p_commit => FND_API.G_TRUE,
348: x_return_status => l_status,
349: x_msg_count => l_count,
350: x_msg_data => l_data,

Line 347: p_commit => FND_API.G_TRUE,

343: GMF_ItemCost_PUB.Create_Item_Cost
344: (
345: p_api_version => 3.0,
346: p_init_msg_list => FND_API.G_TRUE,
347: p_commit => FND_API.G_TRUE,
348: x_return_status => l_status,
349: x_msg_count => l_count,
350: x_msg_data => l_data,
351: p_header_rec => l_header_rec,

Line 373: p_encoded => FND_API.G_FALSE,

369: FND_MSG_PUB.Get
370: (
371: p_msg_index => l_loop_cnt,
372: p_data => l_data,
373: p_encoded => FND_API.G_FALSE,
374: p_msg_index_out => l_dummy_cnt
375: );
376:
377: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 553: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

549: /******************
550: * Local variables *
551: ******************/
552: l_status VARCHAR2(100);
553: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
554: l_count NUMBER(10) ;
555: l_record_count NUMBER(10) :=0;
556: l_loop_cnt NUMBER(10) :=0;
557: l_dummy_cnt NUMBER(10) :=0;

Line 789: p_init_msg_list => FND_API.G_TRUE,

785: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Update_Item_Cost API...');
786: GMF_ItemCost_PUB.Update_Item_Cost
787: (
788: p_api_version => 3.0,
789: p_init_msg_list => FND_API.G_TRUE,
790: p_commit => FND_API.G_TRUE,
791: x_return_status => l_status,
792: x_msg_count => l_count,
793: x_msg_data => l_data,

Line 790: p_commit => FND_API.G_TRUE,

786: GMF_ItemCost_PUB.Update_Item_Cost
787: (
788: p_api_version => 3.0,
789: p_init_msg_list => FND_API.G_TRUE,
790: p_commit => FND_API.G_TRUE,
791: x_return_status => l_status,
792: x_msg_count => l_count,
793: x_msg_data => l_data,
794: p_header_rec => l_header_rec,

Line 809: p_init_msg_list => FND_API.G_TRUE,

805: -- DBMS_OUTPUT.PUT_LINE('Calling Update_Item_Cost API...');
806: GMF_ItemCost_PUB.Update_Item_Cost
807: (
808: p_api_version => 3.0,
809: p_init_msg_list => FND_API.G_TRUE,
810: p_commit => FND_API.G_TRUE,
811: x_return_status => l_status,
812: x_msg_count => l_count,
813: x_msg_data => l_data,

Line 810: p_commit => FND_API.G_TRUE,

806: GMF_ItemCost_PUB.Update_Item_Cost
807: (
808: p_api_version => 3.0,
809: p_init_msg_list => FND_API.G_TRUE,
810: p_commit => FND_API.G_TRUE,
811: x_return_status => l_status,
812: x_msg_count => l_count,
813: x_msg_data => l_data,
814: p_header_rec => l_header_rec,

Line 833: p_encoded => FND_API.G_FALSE,

829: FND_MSG_PUB.Get
830: (
831: p_msg_index => l_loop_cnt,
832: p_data => l_data,
833: p_encoded => FND_API.G_FALSE,
834: p_msg_index_out => l_dummy_cnt
835: );
836: -- DBMS_OUTPUT.PUT_LINE(l_data );
837: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );

Line 1000: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

996: /******************
997: * Local variables *
998: ******************/
999: l_status VARCHAR2(100);
1000: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
1001: l_count NUMBER(10) ;
1002: l_record_count NUMBER(10) :=0;
1003: l_loop_cnt NUMBER(10) :=0;
1004: l_dummy_cnt NUMBER(10) :=0;

Line 1229: p_init_msg_list => FND_API.G_TRUE,

1225: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Delete_Item_Cost API...');
1226: GMF_ItemCost_PUB.Delete_Item_Cost
1227: (
1228: p_api_version => 3.0,
1229: p_init_msg_list => FND_API.G_TRUE,
1230: p_commit => FND_API.G_TRUE,
1231: x_return_status => l_status,
1232: x_msg_count => l_count,
1233: x_msg_data => l_data,

Line 1230: p_commit => FND_API.G_TRUE,

1226: GMF_ItemCost_PUB.Delete_Item_Cost
1227: (
1228: p_api_version => 3.0,
1229: p_init_msg_list => FND_API.G_TRUE,
1230: p_commit => FND_API.G_TRUE,
1231: x_return_status => l_status,
1232: x_msg_count => l_count,
1233: x_msg_data => l_data,
1234: p_header_rec => l_header_rec,

Line 1249: p_init_msg_list => FND_API.G_TRUE,

1245: -- DBMS_OUTPUT.PUT_LINE('Calling Delete_Item_Cost API...');
1246: GMF_ItemCost_PUB.Delete_Item_Cost
1247: (
1248: p_api_version => 3.0,
1249: p_init_msg_list => FND_API.G_TRUE,
1250: p_commit => FND_API.G_TRUE,
1251: x_return_status => l_status,
1252: x_msg_count => l_count,
1253: x_msg_data => l_data,

Line 1250: p_commit => FND_API.G_TRUE,

1246: GMF_ItemCost_PUB.Delete_Item_Cost
1247: (
1248: p_api_version => 3.0,
1249: p_init_msg_list => FND_API.G_TRUE,
1250: p_commit => FND_API.G_TRUE,
1251: x_return_status => l_status,
1252: x_msg_count => l_count,
1253: x_msg_data => l_data,
1254: p_header_rec => l_header_rec,

Line 1273: p_encoded => FND_API.G_FALSE,

1269: FND_MSG_PUB.Get
1270: (
1271: p_msg_index => l_loop_cnt,
1272: p_data => l_data,
1273: p_encoded => FND_API.G_FALSE,
1274: p_msg_index_out => l_dummy_cnt
1275: );
1276: -- DBMS_OUTPUT.PUT_LINE(l_data );
1277: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );

Line 1443: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

1439: /******************
1440: * Local variables *
1441: ******************/
1442: l_status VARCHAR2(11);
1443: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
1444: l_count NUMBER(10) ;
1445: l_record_count NUMBER(10) :=0;
1446: l_loop_cnt NUMBER(10) :=0;
1447: l_dummy_cnt NUMBER(10) :=0;

Line 1549: p_init_msg_list => FND_API.G_TRUE,

1545: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');
1546: GMF_ItemCost_PUB.Get_Item_Cost
1547: (
1548: p_api_version => 3.0,
1549: p_init_msg_list => FND_API.G_TRUE,
1550: x_return_status => l_status,
1551: x_msg_count => l_count,
1552: x_msg_data => l_data,
1553: p_header_rec => l_header_rec,

Line 1565: p_encoded => FND_API.G_FALSE,

1561: FND_MSG_PUB.Get
1562: (
1563: p_msg_index => l_loop_cnt,
1564: p_data => l_data,
1565: p_encoded => FND_API.G_FALSE,
1566: p_msg_index_out => l_dummy_cnt
1567: );
1568: -- DBMS_OUTPUT.PUT_LINE(l_data );
1569: --UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );

Line 1758: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

1754: /******************
1755: * Local variables *
1756: ******************/
1757: l_status VARCHAR2(11);
1758: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
1759: l_count NUMBER(10) ;
1760: l_record_count NUMBER(10) :=0;
1761: l_loop_cnt NUMBER(10) :=0;
1762: l_dummy_cnt NUMBER(10) :=0;

Line 1923: p_encoded => FND_API.G_FALSE,

1919: FND_MSG_PUB.Get
1920: (
1921: p_msg_index => l_loop_cnt,
1922: p_data => l_data,
1923: p_encoded => FND_API.G_FALSE,
1924: p_msg_index_out => l_dummy_cnt
1925: );
1926: UTL_FILE.PUT_LINE(l_log_handle, l_data);
1927:

Line 2033: p_init_msg_list => FND_API.G_TRUE,

2029: IF p_operation = 'INSERT' THEN
2030: GMF_ACTUAL_COST_ADJUSTMENT_PUB.CREATE_ACTUAL_COST_ADJUSTMENT
2031: (
2032: p_api_version => 1.0,
2033: p_init_msg_list => FND_API.G_TRUE,
2034: p_commit => FND_API.G_TRUE,
2035: x_return_status => x_status,
2036: x_msg_count => x_count,
2037: x_msg_data => x_data,

Line 2034: p_commit => FND_API.G_TRUE,

2030: GMF_ACTUAL_COST_ADJUSTMENT_PUB.CREATE_ACTUAL_COST_ADJUSTMENT
2031: (
2032: p_api_version => 1.0,
2033: p_init_msg_list => FND_API.G_TRUE,
2034: p_commit => FND_API.G_TRUE,
2035: x_return_status => x_status,
2036: x_msg_count => x_count,
2037: x_msg_data => x_data,
2038: p_adjustment_rec => p_adjustment_rec

Line 2044: p_init_msg_list => FND_API.G_TRUE,

2040: ELSIF p_operation = 'UPDATE' THEN
2041: GMF_ACTUAL_COST_ADJUSTMENT_PUB.UPDATE_ACTUAL_COST_ADJUSTMENT
2042: (
2043: p_api_version => 1.0,
2044: p_init_msg_list => FND_API.G_TRUE,
2045: p_commit => FND_API.G_TRUE,
2046: x_return_status => x_status,
2047: x_msg_count => x_count,
2048: x_msg_data => x_data,

Line 2045: p_commit => FND_API.G_TRUE,

2041: GMF_ACTUAL_COST_ADJUSTMENT_PUB.UPDATE_ACTUAL_COST_ADJUSTMENT
2042: (
2043: p_api_version => 1.0,
2044: p_init_msg_list => FND_API.G_TRUE,
2045: p_commit => FND_API.G_TRUE,
2046: x_return_status => x_status,
2047: x_msg_count => x_count,
2048: x_msg_data => x_data,
2049: p_adjustment_rec => p_adjustment_rec

Line 2055: p_init_msg_list => FND_API.G_TRUE,

2051: ELSIF p_operation = 'DELETE' THEN
2052: GMF_ACTUAL_COST_ADJUSTMENT_PUB.DELETE_ACTUAL_COST_ADJUSTMENT
2053: (
2054: p_api_version => 1.0,
2055: p_init_msg_list => FND_API.G_TRUE,
2056: p_commit => FND_API.G_TRUE,
2057: x_return_status => x_status,
2058: x_msg_count => x_count,
2059: x_msg_data => x_data,

Line 2056: p_commit => FND_API.G_TRUE,

2052: GMF_ACTUAL_COST_ADJUSTMENT_PUB.DELETE_ACTUAL_COST_ADJUSTMENT
2053: (
2054: p_api_version => 1.0,
2055: p_init_msg_list => FND_API.G_TRUE,
2056: p_commit => FND_API.G_TRUE,
2057: x_return_status => x_status,
2058: x_msg_count => x_count,
2059: x_msg_data => x_data,
2060: p_adjustment_rec => p_adjustment_rec

Line 2114: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

2110: /******************
2111: * Local variables *
2112: ******************/
2113: l_status VARCHAR2(11);
2114: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
2115: l_count NUMBER(10) ;
2116: l_record_count NUMBER(10) :=0;
2117: l_loop_cnt NUMBER(10) :=0;
2118: l_dummy_cnt NUMBER(10) :=0;

Line 2241: p_init_msg_list => FND_API.G_TRUE,

2237:
2238: GMF_ACTUAL_COST_ADJUSTMENT_PUB.GET_ACTUAL_COST_ADJUSTMENT
2239: (
2240: p_api_version => 1.0,
2241: p_init_msg_list => FND_API.G_TRUE,
2242: x_return_status => l_status,
2243: x_msg_count => l_count,
2244: x_msg_data => l_data,
2245: p_adjustment_rec => l_adjustment_rec

Line 2267: p_encoded => FND_API.G_FALSE,

2263: FND_MSG_PUB.Get
2264: (
2265: p_msg_index => l_loop_cnt,
2266: p_data => l_data,
2267: p_encoded => FND_API.G_FALSE,
2268: p_msg_index_out => l_dummy_cnt
2269: );
2270: UTL_FILE.PUT_LINE(l_log_handle, l_data);
2271:

Line 2440: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

2436:
2437: /* Local variables */
2438:
2439: l_status VARCHAR2(11);
2440: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
2441: l_count NUMBER(10) ;
2442: l_record_count NUMBER(10) :=0;
2443: l_loop_cnt NUMBER(10) :=0;
2444: l_dummy_cnt NUMBER(10) :=0;

Line 2564: , p_init_msg_list => FND_API.G_TRUE

2560: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || alloc_rec.user_name) ;
2561: */
2562: GMF_ALLOCATIONDEFINITION_PUB.Create_Allocation_Definition
2563: ( p_api_version => 3.0
2564: , p_init_msg_list => FND_API.G_TRUE
2565: , p_commit => FND_API.G_TRUE
2566:
2567: , x_return_status =>l_status
2568: , x_msg_count =>l_count

Line 2565: , p_commit => FND_API.G_TRUE

2561: */
2562: GMF_ALLOCATIONDEFINITION_PUB.Create_Allocation_Definition
2563: ( p_api_version => 3.0
2564: , p_init_msg_list => FND_API.G_TRUE
2565: , p_commit => FND_API.G_TRUE
2566:
2567: , x_return_status =>l_status
2568: , x_msg_count =>l_count
2569: , x_msg_data =>l_data

Line 2583: p_encoded => FND_API.G_FALSE,

2579:
2580: FND_MSG_PUB.Get(
2581: p_msg_index => l_loop_cnt,
2582: p_data => l_data,
2583: p_encoded => FND_API.G_FALSE,
2584: p_msg_index_out => l_dummy_cnt);
2585:
2586:
2587: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 2790: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

2786:
2787: /* Local variables */
2788:
2789: l_status VARCHAR2(100);
2790: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
2791: l_count NUMBER(10) ;
2792: l_record_count NUMBER(10) :=0;
2793: l_loop_cnt NUMBER(10) :=0;
2794: l_dummy_cnt NUMBER(10) :=0;

Line 2917: , p_init_msg_list => FND_API.G_TRUE

2913:
2914: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
2915: GMF_ALLOCATIONDEFINITION_PUB.Update_Allocation_Definition
2916: ( p_api_version => 3.0
2917: , p_init_msg_list => FND_API.G_TRUE
2918: , p_commit => FND_API.G_TRUE
2919:
2920: , x_return_status =>l_status
2921: , x_msg_count =>l_count

Line 2918: , p_commit => FND_API.G_TRUE

2914: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
2915: GMF_ALLOCATIONDEFINITION_PUB.Update_Allocation_Definition
2916: ( p_api_version => 3.0
2917: , p_init_msg_list => FND_API.G_TRUE
2918: , p_commit => FND_API.G_TRUE
2919:
2920: , x_return_status =>l_status
2921: , x_msg_count =>l_count
2922: , x_msg_data =>l_data

Line 2936: p_encoded => FND_API.G_FALSE,

2932:
2933: FND_MSG_PUB.Get(
2934: p_msg_index => l_loop_cnt,
2935: p_data => l_data,
2936: p_encoded => FND_API.G_FALSE,
2937: p_msg_index_out => l_dummy_cnt);
2938:
2939:
2940: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 3143: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

3139:
3140: /* Local variables */
3141:
3142: l_status VARCHAR2(100);
3143: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
3144: l_count NUMBER(10) ;
3145: l_record_count NUMBER(10) :=0;
3146: l_loop_cnt NUMBER(10) :=0;
3147: l_dummy_cnt NUMBER(10) :=0;

Line 3270: , p_init_msg_list => FND_API.G_TRUE

3266:
3267: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
3268: GMF_ALLOCATIONDEFINITION_PUB.Delete_Allocation_Definition
3269: ( p_api_version => 3.0
3270: , p_init_msg_list => FND_API.G_TRUE
3271: , p_commit => FND_API.G_TRUE
3272:
3273: , x_return_status =>l_status
3274: , x_msg_count =>l_count

Line 3271: , p_commit => FND_API.G_TRUE

3267: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
3268: GMF_ALLOCATIONDEFINITION_PUB.Delete_Allocation_Definition
3269: ( p_api_version => 3.0
3270: , p_init_msg_list => FND_API.G_TRUE
3271: , p_commit => FND_API.G_TRUE
3272:
3273: , x_return_status =>l_status
3274: , x_msg_count =>l_count
3275: , x_msg_data =>l_data

Line 3289: p_encoded => FND_API.G_FALSE,

3285:
3286: FND_MSG_PUB.Get(
3287: p_msg_index => l_loop_cnt,
3288: p_data => l_data,
3289: p_encoded => FND_API.G_FALSE,
3290: p_msg_index_out => l_dummy_cnt);
3291:
3292:
3293: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 3494: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

3490: /* Local variables */
3491:
3492:
3493: l_status VARCHAR2(11);
3494: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
3495: l_count NUMBER(10) ;
3496: l_record_count NUMBER(10) :=0;
3497: l_loop_cnt NUMBER(10) :=0;
3498: l_dummy_cnt NUMBER(10) :=0;

Line 3766: p_encoded => FND_API.G_FALSE,

3762: LOOP
3763: FND_MSG_PUB.Get(
3764: p_msg_index => l_loop_cnt,
3765: p_data => l_data,
3766: p_encoded => FND_API.G_FALSE,
3767: p_msg_index_out => l_dummy_cnt);
3768:
3769: UTL_FILE.PUT_LINE(l_log_handle, l_data);
3770:

Line 3894: , p_init_msg_list => FND_API.G_TRUE

3890:
3891: IF p_operation = 'INSERT' THEN
3892: GMF_LotCostAdjustment_PUB.Create_LotCost_Adjustment
3893: ( p_api_version => 2.0
3894: , p_init_msg_list => FND_API.G_TRUE
3895: , p_commit => FND_API.G_TRUE
3896: , x_return_status => x_status
3897: , x_msg_count => x_count
3898: , x_msg_data => x_data

Line 3895: , p_commit => FND_API.G_TRUE

3891: IF p_operation = 'INSERT' THEN
3892: GMF_LotCostAdjustment_PUB.Create_LotCost_Adjustment
3893: ( p_api_version => 2.0
3894: , p_init_msg_list => FND_API.G_TRUE
3895: , p_commit => FND_API.G_TRUE
3896: , x_return_status => x_status
3897: , x_msg_count => x_count
3898: , x_msg_data => x_data
3899: , p_header_rec => p_header_rec

Line 3905: , p_init_msg_list => FND_API.G_TRUE

3901: );
3902: ELSIF p_operation = 'UPDATE' THEN
3903: GMF_LotCostAdjustment_PUB.Update_LotCost_Adjustment
3904: ( p_api_version => 2.0
3905: , p_init_msg_list => FND_API.G_TRUE
3906: , p_commit => FND_API.G_TRUE
3907: , x_return_status => x_status
3908: , x_msg_count => x_count
3909: , x_msg_data => x_data

Line 3906: , p_commit => FND_API.G_TRUE

3902: ELSIF p_operation = 'UPDATE' THEN
3903: GMF_LotCostAdjustment_PUB.Update_LotCost_Adjustment
3904: ( p_api_version => 2.0
3905: , p_init_msg_list => FND_API.G_TRUE
3906: , p_commit => FND_API.G_TRUE
3907: , x_return_status => x_status
3908: , x_msg_count => x_count
3909: , x_msg_data => x_data
3910: , p_header_rec => p_header_rec

Line 3916: , p_init_msg_list => FND_API.G_TRUE

3912: );
3913: ELSIF p_operation = 'DELETE' THEN
3914: GMF_LotCostAdjustment_PUB.Delete_LotCost_Adjustment
3915: ( p_api_version => 2.0
3916: , p_init_msg_list => FND_API.G_TRUE
3917: , p_commit => FND_API.G_TRUE
3918: , x_return_status => x_status
3919: , x_msg_count => x_count
3920: , x_msg_data => x_data

Line 3917: , p_commit => FND_API.G_TRUE

3913: ELSIF p_operation = 'DELETE' THEN
3914: GMF_LotCostAdjustment_PUB.Delete_LotCost_Adjustment
3915: ( p_api_version => 2.0
3916: , p_init_msg_list => FND_API.G_TRUE
3917: , p_commit => FND_API.G_TRUE
3918: , x_return_status => x_status
3919: , x_msg_count => x_count
3920: , x_msg_data => x_data
3921: , p_header_rec => p_header_rec

Line 3975: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

3971:
3972: /* Local variables */
3973:
3974: l_status VARCHAR2(11);
3975: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
3976: l_count NUMBER(10) ;
3977: l_record_count NUMBER(10) :=0;
3978: l_loop_cnt NUMBER(10) :=0;
3979: l_dummy_cnt NUMBER(10) :=0;

Line 4135: , p_init_msg_list => FND_API.G_TRUE

4131:
4132: GMF_LotCostAdjustment_PUB.Get_LotCost_Adjustment
4133: (
4134: p_api_version => 2.0
4135: , p_init_msg_list => FND_API.G_TRUE
4136:
4137: , x_return_status => l_status
4138: , x_msg_count => l_count
4139: , x_msg_data => l_data

Line 4159: p_encoded => FND_API.G_FALSE,

4155: LOOP
4156: FND_MSG_PUB.Get(
4157: p_msg_index => l_loop_cnt,
4158: p_data => l_data,
4159: p_encoded => FND_API.G_FALSE,
4160: p_msg_index_out => l_dummy_cnt);
4161:
4162: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4163: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 4334: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

4330:
4331: /* Local variables */
4332:
4333: l_status VARCHAR2(11);
4334: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
4335: l_count NUMBER(10) ;
4336: l_record_count NUMBER(10) :=0;
4337: l_loop_cnt NUMBER(10) :=0;
4338: l_dummy_cnt NUMBER(10) :=0;

Line 4567: p_encoded => FND_API.G_FALSE,

4563: LOOP
4564: FND_MSG_PUB.Get(
4565: p_msg_index => l_loop_cnt,
4566: p_data => l_data,
4567: p_encoded => FND_API.G_FALSE,
4568: p_msg_index_out => l_dummy_cnt);
4569:
4570: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4571: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 4767: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

4763:
4764: /* Local variables */
4765:
4766: l_status VARCHAR2(11);
4767: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
4768: l_count NUMBER(10) ;
4769: l_record_count NUMBER(10) :=0;
4770: l_loop_cnt NUMBER(10) :=0;
4771: l_dummy_cnt NUMBER(10) :=0;

Line 4879: , p_init_msg_list => FND_API.G_TRUE

4875: -- Invoke public get burden details
4876: GMF_BurdenDetails_PUB.Get_Burden_Details
4877: (
4878: p_api_version => 2.0
4879: , p_init_msg_list => FND_API.G_TRUE
4880:
4881: , x_return_status => l_status
4882: , x_msg_count => l_count
4883: , x_msg_data => l_data

Line 4902: p_encoded => FND_API.G_FALSE,

4898: LOOP
4899: FND_MSG_PUB.Get(
4900: p_msg_index => l_loop_cnt,
4901: p_data => l_data,
4902: p_encoded => FND_API.G_FALSE,
4903: p_msg_index_out => l_dummy_cnt);
4904:
4905: ---- DBMS_OUTPUT.PUT_LINE(l_data );
4906: UTL_FILE.PUT_LINE(l_log_handle, l_data);

Line 5063: , p_init_msg_list => FND_API.G_TRUE

5059: IF p_operation = 'INSERT' THEN
5060: GMF_BurdenDetails_PUB.Create_Burden_Details
5061: (
5062: p_api_version => 2.0
5063: , p_init_msg_list => FND_API.G_TRUE
5064: , p_commit => FND_API.G_TRUE
5065:
5066: , x_return_status => x_status
5067: , x_msg_count => x_count

Line 5064: , p_commit => FND_API.G_TRUE

5060: GMF_BurdenDetails_PUB.Create_Burden_Details
5061: (
5062: p_api_version => 2.0
5063: , p_init_msg_list => FND_API.G_TRUE
5064: , p_commit => FND_API.G_TRUE
5065:
5066: , x_return_status => x_status
5067: , x_msg_count => x_count
5068: , x_msg_data => x_data

Line 5079: , p_init_msg_list => FND_API.G_TRUE

5075: ELSIF p_operation = 'UPDATE' THEN
5076: GMF_BurdenDetails_PUB.Update_Burden_Details
5077: (
5078: p_api_version => 2.0
5079: , p_init_msg_list => FND_API.G_TRUE
5080: , p_commit => FND_API.G_TRUE
5081:
5082: , x_return_status => x_status
5083: , x_msg_count => x_count

Line 5080: , p_commit => FND_API.G_TRUE

5076: GMF_BurdenDetails_PUB.Update_Burden_Details
5077: (
5078: p_api_version => 2.0
5079: , p_init_msg_list => FND_API.G_TRUE
5080: , p_commit => FND_API.G_TRUE
5081:
5082: , x_return_status => x_status
5083: , x_msg_count => x_count
5084: , x_msg_data => x_data

Line 5093: , p_init_msg_list => FND_API.G_TRUE

5089: ELSIF p_operation = 'DELETE' THEN
5090: GMF_BurdenDetails_PUB.Delete_Burden_Details
5091: (
5092: p_api_version => 2.0
5093: , p_init_msg_list => FND_API.G_TRUE
5094: , p_commit => FND_API.G_TRUE
5095:
5096: , x_return_status => x_status
5097: , x_msg_count => x_count

Line 5094: , p_commit => FND_API.G_TRUE

5090: GMF_BurdenDetails_PUB.Delete_Burden_Details
5091: (
5092: p_api_version => 2.0
5093: , p_init_msg_list => FND_API.G_TRUE
5094: , p_commit => FND_API.G_TRUE
5095:
5096: , x_return_status => x_status
5097: , x_msg_count => x_count
5098: , x_msg_data => x_data

Line 5212: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

5208:
5209: /* Local variables */
5210:
5211: l_status VARCHAR2(11);
5212: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
5213: l_count NUMBER(10) ;
5214: l_record_count NUMBER(10) :=0;
5215: l_loop_cnt NUMBER(10) :=0;
5216: l_dummy_cnt NUMBER(10) :=0;

Line 5320: , p_init_msg_list => FND_API.G_TRUE

5316: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
5317:
5318: GMF_ResourceCost_PUB.Create_Resource_Cost
5319: ( p_api_version => 2.0
5320: , p_init_msg_list => FND_API.G_TRUE
5321: , p_commit => FND_API.G_TRUE
5322:
5323: , x_return_status =>l_status
5324: , x_msg_count =>l_count

Line 5321: , p_commit => FND_API.G_TRUE

5317:
5318: GMF_ResourceCost_PUB.Create_Resource_Cost
5319: ( p_api_version => 2.0
5320: , p_init_msg_list => FND_API.G_TRUE
5321: , p_commit => FND_API.G_TRUE
5322:
5323: , x_return_status =>l_status
5324: , x_msg_count =>l_count
5325: , x_msg_data =>l_data

Line 5339: p_encoded => FND_API.G_FALSE,

5335:
5336: FND_MSG_PUB.Get(
5337: p_msg_index => l_loop_cnt,
5338: p_data => l_data,
5339: p_encoded => FND_API.G_FALSE,
5340: p_msg_index_out => l_dummy_cnt);
5341:
5342:
5343: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 5549: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

5545:
5546: /* Local variables */
5547:
5548: l_status VARCHAR2(100);
5549: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
5550: l_count NUMBER(10) ;
5551: l_record_count NUMBER(10) :=0;
5552: l_loop_cnt NUMBER(10) :=0;
5553: l_dummy_cnt NUMBER(10) :=0;

Line 5662: , p_init_msg_list => FND_API.G_TRUE

5658:
5659: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
5660: GMF_ResourceCost_PUB.Update_Resource_Cost
5661: ( p_api_version => 2.0
5662: , p_init_msg_list => FND_API.G_TRUE
5663: , p_commit => FND_API.G_TRUE
5664:
5665: , x_return_status =>l_status
5666: , x_msg_count =>l_count

Line 5663: , p_commit => FND_API.G_TRUE

5659: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
5660: GMF_ResourceCost_PUB.Update_Resource_Cost
5661: ( p_api_version => 2.0
5662: , p_init_msg_list => FND_API.G_TRUE
5663: , p_commit => FND_API.G_TRUE
5664:
5665: , x_return_status =>l_status
5666: , x_msg_count =>l_count
5667: , x_msg_data =>l_data

Line 5681: p_encoded => FND_API.G_FALSE,

5677:
5678: FND_MSG_PUB.Get(
5679: p_msg_index => l_loop_cnt,
5680: p_data => l_data,
5681: p_encoded => FND_API.G_FALSE,
5682: p_msg_index_out => l_dummy_cnt);
5683:
5684:
5685: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 5892: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

5888:
5889: /* Local variables */
5890:
5891: l_status VARCHAR2(100);
5892: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
5893: l_count NUMBER(10) ;
5894: l_record_count NUMBER(10) :=0;
5895: l_loop_cnt NUMBER(10) :=0;
5896: l_dummy_cnt NUMBER(10) :=0;

Line 6006: , p_init_msg_list => FND_API.G_TRUE

6002:
6003: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
6004: GMF_ResourceCost_PUB.Delete_Resource_Cost
6005: ( p_api_version => 2.0
6006: , p_init_msg_list => FND_API.G_TRUE
6007: , p_commit => FND_API.G_TRUE
6008:
6009: , x_return_status =>l_status
6010: , x_msg_count =>l_count

Line 6007: , p_commit => FND_API.G_TRUE

6003: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
6004: GMF_ResourceCost_PUB.Delete_Resource_Cost
6005: ( p_api_version => 2.0
6006: , p_init_msg_list => FND_API.G_TRUE
6007: , p_commit => FND_API.G_TRUE
6008:
6009: , x_return_status =>l_status
6010: , x_msg_count =>l_count
6011: , x_msg_data =>l_data

Line 6025: p_encoded => FND_API.G_FALSE,

6021:
6022: FND_MSG_PUB.Get(
6023: p_msg_index => l_loop_cnt,
6024: p_data => l_data,
6025: p_encoded => FND_API.G_FALSE,
6026: p_msg_index_out => l_dummy_cnt);
6027:
6028:
6029: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 6225: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;

6221:
6222: /* Local variables */
6223:
6224: l_status VARCHAR2(100);
6225: l_return_status VARCHAR2(11) :=FND_API.G_RET_STS_SUCCESS;
6226: l_count NUMBER(10) ;
6227: l_record_count NUMBER(10) :=0;
6228: l_loop_cnt NUMBER(10) :=0;
6229: l_dummy_cnt NUMBER(10) :=0;

Line 6340: , p_init_msg_list => FND_API.G_TRUE

6336:
6337: -- DBMS_OUTPUT.PUT_LINE('before calling Get Resource Cost Public API...');
6338: GMF_ResourceCost_PUB.Get_Resource_Cost
6339: ( p_api_version => 2.0
6340: , p_init_msg_list => FND_API.G_TRUE
6341:
6342: , x_return_status =>l_status
6343: , x_msg_count =>l_count
6344: , x_msg_data =>l_data

Line 6359: p_encoded => FND_API.G_FALSE,

6355:
6356: FND_MSG_PUB.Get(
6357: p_msg_index => l_loop_cnt,
6358: p_data => l_data,
6359: p_encoded => FND_API.G_FALSE,
6360: p_msg_index_out => l_dummy_cnt);
6361:
6362:
6363: -- DBMS_OUTPUT.PUT_LINE(l_data );

Line 6390: IF (x_rsrc_rec.usage_uom <> FND_API.G_MISS_CHAR) OR

6386:
6387: END LOOP;
6388: END IF; -- message count
6389:
6390: IF (x_rsrc_rec.usage_uom <> FND_API.G_MISS_CHAR) OR
6391: (x_rsrc_rec.nominal_cost <> FND_API.G_MISS_NUM) THEN
6392:
6393: UTL_FILE.PUT_LINE( l_log_handle,
6394: 'Usage_uom : ' || x_rsrc_rec.usage_uom ||

Line 6391: (x_rsrc_rec.nominal_cost <> FND_API.G_MISS_NUM) THEN

6387: END LOOP;
6388: END IF; -- message count
6389:
6390: IF (x_rsrc_rec.usage_uom <> FND_API.G_MISS_CHAR) OR
6391: (x_rsrc_rec.nominal_cost <> FND_API.G_MISS_NUM) THEN
6392:
6393: UTL_FILE.PUT_LINE( l_log_handle,
6394: 'Usage_uom : ' || x_rsrc_rec.usage_uom ||
6395: ' Nominal Cost : ' || x_rsrc_rec.nominal_cost ||

Line 6539: RETURN FND_API.G_MISS_CHAR;

6535:
6536: IF l_string IS NULL THEN
6537: RETURN NULL;
6538: ELSIF l_string = 'G_MISS_CHAR' THEN
6539: RETURN FND_API.G_MISS_CHAR;
6540: ELSIF l_string = 'G_MISS_NUM' THEN
6541: RETURN FND_API.G_MISS_NUM;
6542: ELSIF l_string = 'G_MISS_DATE' THEN
6543: RETURN FND_API.G_MISS_DATE;

Line 6541: RETURN FND_API.G_MISS_NUM;

6537: RETURN NULL;
6538: ELSIF l_string = 'G_MISS_CHAR' THEN
6539: RETURN FND_API.G_MISS_CHAR;
6540: ELSIF l_string = 'G_MISS_NUM' THEN
6541: RETURN FND_API.G_MISS_NUM;
6542: ELSIF l_string = 'G_MISS_DATE' THEN
6543: RETURN FND_API.G_MISS_DATE;
6544: ELSE
6545: RETURN l_string;

Line 6543: RETURN FND_API.G_MISS_DATE;

6539: RETURN FND_API.G_MISS_CHAR;
6540: ELSIF l_string = 'G_MISS_NUM' THEN
6541: RETURN FND_API.G_MISS_NUM;
6542: ELSIF l_string = 'G_MISS_DATE' THEN
6543: RETURN FND_API.G_MISS_DATE;
6544: ELSE
6545: RETURN l_string;
6546: END IF;
6547: