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.

[Home] [Help]

APPS.EAM_AUTOMATICEST dependencies on FND_API

Line 26: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

22: l_job_status NUMBER := 0;
23: l_msg_count NUMBER := 0;
24: l_validate NUMBER := 0;
25: l_stmt_num NUMBER := 0;
26: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
27: l_msg_data VARCHAR2(8000) := '';
28:
29: BEGIN
30:

Line 58: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

54: x_msg_data := l_msg_data;
55:
56: l_stmt_num := 30;
57:
58: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
59:
60: l_stmt_num := 40;
61:
62: -- Work order qualifies for reestimation

Line 92: x_return_status := fnd_api.g_ret_sts_error;

88:
89: EXCEPTION
90:
91: WHEN NO_DATA_FOUND THEN
92: x_return_status := fnd_api.g_ret_sts_error;
93: x_msg_data := ' Call_Validate_for_Reestimation : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ;
94:
95: END Call_Validate_for_Reestimation;
96:

Line 115: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

111: ) IS
112:
113: l_wip_entity_tbl wip_entity_tbl_type;
114: l_stmt_num NUMBER := 0;
115: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
116: l_msg_data VARCHAR2(8000) := '';
117:
118: BEGIN
119:

Line 159: x_return_status := fnd_api.g_ret_sts_unexp_error;

155:
156: EXCEPTION
157:
158: WHEN OTHERS THEN
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: x_msg_data := ' CST_Item_Cost_Change : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ||l_msg_data ;
161:
162: END CST_Item_Cost_Change;
163:

Line 182: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

178: ) IS
179:
180: l_wip_entity_tbl wip_entity_tbl_type;
181: l_stmt_num NUMBER := 0;
182: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
183: l_msg_data VARCHAR2(8000) := '';
184:
185: BEGIN
186:

Line 227: x_return_status := fnd_api.g_ret_sts_error;

223:
224: EXCEPTION
225:
226: WHEN OTHERS THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228: x_msg_data := ' CST_Usage_Rate_Change : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ||l_msg_data ;
229:
230: END CST_Usage_Rate_Change;
231:

Line 268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

264: l_osp VARCHAR2(1) := 'N';
265: l_cancel_flag VARCHAR2(1) := 'N';
266: l_auth_status VARCHAR2(25) := '';
267: l_dest_type VARCHAR2(25) := '';
268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
269: l_msg_data VARCHAR2(8000) := '';
270:
271: BEGIN
272:

Line 383: x_return_status := fnd_api.g_ret_sts_error;

379: EXCEPTION
380:
381: WHEN NO_DATA_FOUND THEN
382:
383: x_return_status := fnd_api.g_ret_sts_error;
384: x_msg_data := ' PO_Req_Logic : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ;
385:
386:
387: END PO_Req_Logic;

Line 429: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

425: l_osp VARCHAR2(1) := 'N';
426: l_cancel_flag VARCHAR2(1) := 'N';
427: l_auth_status VARCHAR2(25) := '';
428: l_dest_type VARCHAR2(25) := '';
429: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
430: l_msg_data VARCHAR2(8000) := '';
431:
432:
433: BEGIN

Line 601: x_return_status := fnd_api.g_ret_sts_unexp_error;

597: EXCEPTION
598:
599: WHEN NO_DATA_FOUND THEN
600:
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: x_msg_data := ' PO_Po_Logic : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ;
603:
604: END PO_Po_Logic;
605:

Line 623: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

619: ) IS
620:
621: l_po_dist_tbl po_dist_tbl_type;
622: l_stmt_num NUMBER := 0;
623: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
624: l_msg_data VARCHAR2(8000) := '';
625:
626: BEGIN
627:

Line 668: x_return_status := fnd_api.g_ret_sts_error;

664: EXCEPTION
665:
666: WHEN OTHERS THEN
667:
668: x_return_status := fnd_api.g_ret_sts_error;
669: x_msg_data := ' PO_Line_Logic : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ||l_msg_data ;
670:
671: END PO_Line_Logic;
672:

Line 701: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

697: l_api_version CONSTANT NUMBER := 1.0;
698: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Reest_of_Cost';
699: l_stmt_num NUMBER := 0;
700: l_msg_data VARCHAR2(8000) := '';
701: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
702:
703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT Auto_Reest_of_Cost_PUB;

Line 837: x_return_status := fnd_api.g_ret_sts_unexp_error ;

833: EXCEPTION
834:
835: WHEN OTHERS THEN
836: ROLLBACK TO Auto_Reest_of_Cost_PUB;
837: x_return_status := fnd_api.g_ret_sts_unexp_error ;
838: x_msg_data := ' Auto_Reest_of_Cost : Statement - '||l_stmt_num||' Error Message - '||SQLERRM ||l_msg_data ;
839:
840: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
841: THEN