DBA Data[Home] [Help]

APPS.ENG_LAUNCH_ECO_OI_PK dependencies on ENG_GLOBALS

Line 2997: ENG_GLOBALS.Init_Who_Rec(p_org_id => p_org_id,

2993: g_org_id := p_org_id;
2994:
2995: --dbms_output.put_line('Who record initiation');
2996: stmt_num := 2;
2997: ENG_GLOBALS.Init_Who_Rec(p_org_id => p_org_id,
2998: p_user_id => l_user_id,
2999: p_login_id => l_login_id,
3000: p_prog_appid => l_prog_appid,
3001: p_prog_id => l_prog_id,

Line 3004: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 1;

3000: p_prog_appid => l_prog_appid,
3001: p_prog_id => l_prog_id,
3002: p_req_id => l_request_id);
3003: --Bug 2818039
3004: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 1;
3005:
3006: Clear_Global_Data_Structures;
3007:
3008: -- SET ORG IDS

Line 3395: Eng_Globals.Clear_Request_Table;

3391: );
3392:
3393: stmt_num := 14;
3394:
3395: Eng_Globals.Clear_Request_Table;
3396:
3397: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3398: stmt_num := 15;
3399: COMMIT;

Line 3523: Eng_Globals.Clear_Request_Table;

3519: p_output_dir => '/sqlcom/log/plm115d'
3520: );
3521:
3522: stmt_num := 36;
3523: Eng_Globals.Clear_Request_Table;
3524: stmt_num := 37;
3525:
3526: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3527: stmt_num := 38;

Line 3687: Eng_Globals.Clear_Request_Table;

3683: ,p_output_dir => '/sqlcom/log/plm115d'
3684: );
3685:
3686: stmt_num := 78;
3687: Eng_Globals.Clear_Request_Table;
3688: stmt_num := 79;
3689:
3690: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3691: stmt_num := 80;

Line 3826: Eng_Globals.Clear_Request_Table;

3822: --x_err_tbl => l_error_tbl
3823: );
3824:
3825: stmt_num := 116;
3826: Eng_Globals.Clear_Request_Table;
3827: stmt_num := 117;
3828:
3829: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3830: stmt_num := 118;

Line 3960: Eng_Globals.Clear_Request_Table;

3956: --x_err_tbl => l_error_tbl
3957: );
3958:
3959: stmt_num := 152;
3960: Eng_Globals.Clear_Request_Table;
3961: stmt_num := 153;
3962:
3963: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3964: stmt_num := 154;

Line 4081: Eng_Globals.Clear_Request_Table;

4077: --x_err_tbl => l_error_tbl
4078: );
4079:
4080: stmt_num := 182;
4081: Eng_Globals.Clear_Request_Table;
4082: stmt_num := 183;
4083:
4084: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4085: stmt_num := 184;

Line 4198: Eng_Globals.Clear_Request_Table;

4194: --x_err_tbl => l_error_tbl
4195: );
4196:
4197: stmt_num := 208;
4198: Eng_Globals.Clear_Request_Table;
4199: stmt_num := 209;
4200:
4201: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4202: stmt_num := 210;

Line 4315: Eng_Globals.Clear_Request_Table;

4311: p_output_dir => '/sqlcom/log/plm115rw'
4312: );
4313:
4314: stmt_num := 182;
4315: Eng_Globals.Clear_Request_Table;
4316: stmt_num := 183;
4317:
4318: stmt_num := 184;
4319: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4431: Eng_Globals.Clear_Request_Table;

4427: p_output_dir => '/sqlcom/log/plm115rw'
4428: );
4429:
4430: stmt_num := 182;
4431: Eng_Globals.Clear_Request_Table;
4432: stmt_num := 183;
4433:
4434: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4435: stmt_num := 185;

Line 4548: Eng_Globals.Clear_Request_Table;

4544: p_output_dir => '/sqlcom/log/plm115rw'
4545: );
4546:
4547: stmt_num := 182;
4548: Eng_Globals.Clear_Request_Table;
4549:
4550: stmt_num := 184;
4551: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4552: stmt_num := 185;

Line 4654: Eng_Globals.Clear_Request_Table;

4650: --x_err_text => l_err_text--,
4651: --x_err_tbl => l_error_tbl
4652: );
4653:
4654: Eng_Globals.Clear_Request_Table;
4655:
4656: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4657: stmt_num := 230;
4658: COMMIT;

Line 4813: Eng_Globals.Clear_Request_Table;

4809: --x_err_tbl => l_error_tbl
4810: );
4811:
4812: stmt_num := 245;
4813: Eng_Globals.Clear_Request_Table;
4814: stmt_num := 246;
4815:
4816: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4817: stmt_num := 250;

Line 4914: Eng_Globals.Clear_Request_Table;

4910: --x_err_tbl => l_error_tbl
4911: );
4912:
4913: stmt_num := 268;
4914: Eng_Globals.Clear_Request_Table;
4915: stmt_num := 269;
4916:
4917: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4918: stmt_num := 270;

Line 5062: Eng_Globals.Clear_Request_Table;

5058: --x_err_tbl => l_error_tbl
5059: );
5060:
5061: stmt_num := 305;
5062: Eng_Globals.Clear_Request_Table;
5063: stmt_num := 306;
5064:
5065: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5066: stmt_num := 310;

Line 5185: Eng_Globals.Clear_Request_Table;

5181: --x_err_tbl => l_error_tbl
5182: );
5183:
5184: stmt_num := 335;
5185: Eng_Globals.Clear_Request_Table;
5186: stmt_num := 336;
5187:
5188: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5189: stmt_num := 340;

Line 5303: Eng_Globals.Clear_Request_Table;

5299: --x_err_tbl => l_error_tbl
5300: );
5301:
5302: stmt_num := 361;
5303: Eng_Globals.Clear_Request_Table;
5304: stmt_num := 362;
5305:
5306: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5307: stmt_num := 370;

Line 5477: Eng_Globals.Clear_Request_Table;

5473: --x_err_tbl => l_error_tbl
5474: );
5475:
5476: stmt_num := 383;
5477: Eng_Globals.Clear_Request_Table;
5478: stmt_num := 384;
5479:
5480: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5481: stmt_num := 390;

Line 5564: Eng_Globals.Clear_Request_Table;

5560: --x_err_tbl => l_error_tbl
5561: );
5562:
5563: stmt_num := 403;
5564: Eng_Globals.Clear_Request_Table;
5565: stmt_num := 404;
5566:
5567: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5568: stmt_num := 410;

Line 5710: Eng_Globals.Clear_Request_Table;

5706: --x_err_tbl => l_error_tbl
5707: );
5708:
5709: stmt_num := 435;
5710: Eng_Globals.Clear_Request_Table;
5711: stmt_num := 436;
5712:
5713: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5714: stmt_num := 440;

Line 5823: Eng_Globals.Clear_Request_Table;

5819: --x_err_tbl => l_error_tbl
5820: );
5821:
5822: stmt_num := 460;
5823: Eng_Globals.Clear_Request_Table;
5824: stmt_num := 461;
5825:
5826: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5827: stmt_num := 470;

Line 5944: Eng_Globals.Clear_Request_Table;

5940: --x_err_tbl => l_error_tbl
5941: );
5942:
5943: stmt_num := 479;
5944: Eng_Globals.Clear_Request_Table;
5945: stmt_num := 480;
5946:
5947: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5948: stmt_num := 480;

Line 6073: Eng_Globals.Clear_Request_Table;

6069: --x_err_tbl => l_error_tbl
6070: );
6071:
6072: stmt_num := 498;
6073: Eng_Globals.Clear_Request_Table;
6074: stmt_num := 499;
6075:
6076: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6077: stmt_num := 500;

Line 6222: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;

6218:
6219: ERRBUF := FND_MESSAGE.Get_String('ENG', 'ENG_ECOOI_SUCCEEDED');
6220: RETCODE := G_SUCCESS;
6221: --Bug 2818039
6222: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;
6223: EXCEPTION
6224: WHEN import_error THEN
6225: --Bug No: 3737881
6226: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;

Line 6226: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;

6222: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;
6223: EXCEPTION
6224: WHEN import_error THEN
6225: --Bug No: 3737881
6226: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;
6227: --dbms_output.put_line('Import_Error exception handler');
6228: RETCODE := G_ERROR;
6229: ERRBUF := FND_MESSAGE.Get_String('ENG', 'ENG_ECOOI_FAILED');
6230:

Line 6237: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;

6233: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
6234: MRP_UTIL.MRP_LOG(l_unexp_error);
6235: WHEN others THEN
6236: --Bug No: 3737881
6237: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;
6238: --dbms_output.put_line('Others exception handler - stmt num : ' || to_char(stmt_num));
6239: --dbms_output.put_line('SQL error is '||SQLERRM);
6240: RETCODE := G_ERROR;
6241: ERRBUF := FND_MESSAGE.Get_String('ENG', 'ENG_ECOOI_FAILED');

Line 6372: ENG_GLOBALS.Init_Who_Rec(p_org_id => p_org_id,

6368: g_org_id := p_org_id;
6369:
6370: --dbms_output.put_line('Who record initiation');
6371: stmt_num := 2;
6372: ENG_GLOBALS.Init_Who_Rec(p_org_id => p_org_id,
6373: p_user_id => l_user_id,
6374: p_login_id => l_login_id,
6375: p_prog_appid => l_prog_appid,
6376: p_prog_id => l_prog_id,

Line 6379: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 1;

6375: p_prog_appid => l_prog_appid,
6376: p_prog_id => l_prog_id,
6377: p_req_id => l_request_id);
6378:
6379: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 1;
6380:
6381: stmt_num := 240;
6382: l_return_status := null;
6383: l_msg_count := null;

Line 6506: Eng_Globals.Clear_Request_Table;

6502: --x_err_tbl => l_error_tbl
6503: );
6504:
6505: stmt_num := 245;
6506: Eng_Globals.Clear_Request_Table;
6507: stmt_num := 246;
6508:
6509: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6510: stmt_num := 250;

Line 6573: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;

6569:
6570: ERRBUF := FND_MESSAGE.Get_String('ENG', 'ENG_ECOOI_SUCCEEDED');
6571: RETCODE := G_SUCCESS;
6572:
6573: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 0;
6574: EXCEPTION
6575: WHEN import_error THEN
6576: --dbms_output.put_line('Import_Error exception handler');
6577: RETCODE := G_ERROR;