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.IEU_WR_PUB dependencies on FND_FILE

Line 2281: fnd_file.new_line(FND_FILE.LOG, 1);

2277: then
2278: l_success_cnt := 0;
2279: if l_tasks_rules_func is not null
2280: then
2281: fnd_file.new_line(FND_FILE.LOG, 1);
2282: fnd_file.put_line(FND_FILE.LOG, 'SYNC_WS_DETAILS API');
2283:
2284: open c_task(l_parent_obj_code);
2285: loop

Line 2282: fnd_file.put_line(FND_FILE.LOG, 'SYNC_WS_DETAILS API');

2278: l_success_cnt := 0;
2279: if l_tasks_rules_func is not null
2280: then
2281: fnd_file.new_line(FND_FILE.LOG, 1);
2282: fnd_file.put_line(FND_FILE.LOG, 'SYNC_WS_DETAILS API');
2283:
2284: open c_task(l_parent_obj_code);
2285: loop
2286:

Line 2401: fnd_file.new_line(FND_FILE.LOG, 1);

2397:
2398: if (l_failure_cnt < 20)
2399: then
2400:
2401: fnd_file.new_line(FND_FILE.LOG, 1);
2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);

Line 2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);

2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;
2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2408:
2409: end if;
2410:
2411: end if;

Line 2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);

2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;
2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2443:
2444: --dbms_output.put_line('msg: '||l_final_msg);
2445:
2446: close c_task;

Line 2534: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

2530:
2531: l_done := c_task_status%NOTFOUND;
2532:
2533: BEGIN
2534: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
2535: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
2536: update IEU_UWQM_ITEMS
2537: set status_id = l_task_status_rec.l_status_id_list(i),
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2550: fnd_file.new_line(FND_FILE.LOG, 1);

2546: WHEN dml_errors THEN
2547: errors := SQL%BULK_EXCEPTIONS.COUNT;
2548: FOR i IN 1..errors LOOP
2549:
2550: fnd_file.new_line(FND_FILE.LOG, 1);
2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
2553: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2554:

Line 2555: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
2553: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2554:
2555: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
2557: fnd_msg_pub.ADD;
2558: fnd_msg_pub.Count_and_Get
2559: (

Line 2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
2553: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2554:
2555: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
2557: fnd_msg_pub.ADD;
2558: fnd_msg_pub.Count_and_Get
2559: (
2560: p_count => x_msg_count,

Line 7539: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

7535:
7536: l_done := c_task_status%NOTFOUND;
7537:
7538: BEGIN
7539: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
7540: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
7541: update IEU_UWQM_ITEMS
7542: set status_id = l_task_status_rec.l_status_id_list(i),
7543: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 7555: fnd_file.new_line(FND_FILE.LOG, 1);

7551: WHEN dml_errors THEN
7552: errors := SQL%BULK_EXCEPTIONS.COUNT;
7553: FOR i IN 1..errors LOOP
7554:
7555: fnd_file.new_line(FND_FILE.LOG, 1);
7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
7558: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7559:

Line 7560: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
7558: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7559:
7560: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
7562: fnd_msg_pub.ADD;
7563: fnd_msg_pub.Count_and_Get
7564: (

Line 7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
7558: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7559:
7560: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
7562: fnd_msg_pub.ADD;
7563: fnd_msg_pub.Count_and_Get
7564: (
7565: p_count => x_msg_count,

Line 9592: fnd_file.put_line(FND_FILE.LOG, 'Deleting rows from table IEU_UWQM_ITEMS');

9588: END IF;
9589:
9590: END IF;
9591:
9592: fnd_file.put_line(FND_FILE.LOG, 'Deleting rows from table IEU_UWQM_ITEMS');
9593: -- This statement deletes the records from the UWQ work repository table
9594: -- that are linked to an SR that is available in the global temp table
9595: -- with purge status NULL.
9596:

Line 9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');

9606: AND nvl(t.purge_status,'S') <> 'E'
9607: );
9608:
9609: l_row_count := SQL%ROWCOUNT;
9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');
9611:
9612: x_return_status := fnd_api.g_ret_sts_success;
9613:
9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);

Line 9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);

9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');
9611:
9612: x_return_status := fnd_api.g_ret_sts_success;
9613:
9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);
9615: fnd_file.put_line(FND_FILE.LOG, '--------------------------------------------------------------------------------');
9616:
9617: IF (x_return_status <> fnd_api.g_ret_sts_success)
9618: THEN

Line 9615: fnd_file.put_line(FND_FILE.LOG, '--------------------------------------------------------------------------------');

9611:
9612: x_return_status := fnd_api.g_ret_sts_success;
9613:
9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);
9615: fnd_file.put_line(FND_FILE.LOG, '--------------------------------------------------------------------------------');
9616:
9617: IF (x_return_status <> fnd_api.g_ret_sts_success)
9618: THEN
9619:

Line 9647: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');

9643:
9644: WHEN fnd_api.g_exc_error THEN
9645:
9646: x_return_status := fnd_api.g_ret_sts_error;
9647: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');
9648:
9649: fnd_msg_pub.Count_and_Get
9650: (
9651: p_count => x_msg_count,

Line 9658: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');

9654:
9655: WHEN fnd_api.g_exc_unexpected_error THEN
9656:
9657: x_return_status := fnd_api.g_ret_sts_unexp_error;
9658: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');
9659:
9660: fnd_msg_pub.Count_and_Get
9661: (
9662: p_count => x_msg_count,

Line 9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');

9667:
9668: x_return_status := fnd_api.g_ret_sts_unexp_error;
9669: l_sqlerrm := SQLERRM;
9670:
9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');
9672: fnd_file.put_line(FND_FILE.LOG, l_sqlerrm);
9673:
9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN

Line 9672: fnd_file.put_line(FND_FILE.LOG, l_sqlerrm);

9668: x_return_status := fnd_api.g_ret_sts_unexp_error;
9669: l_sqlerrm := SQLERRM;
9670:
9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');
9672: fnd_file.put_line(FND_FILE.LOG, l_sqlerrm);
9673:
9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676:

Line 10585: fnd_file.new_line(FND_FILE.LOG, 1);

10581:
10582: If (l_miss_param_flag = 1)
10583: THEN
10584:
10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
10587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10588: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
10587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10588: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10590:
10591: fnd_msg_pub.ADD;
10592: fnd_msg_pub.Count_and_Get
10593: (

Line 10634: fnd_file.new_line(FND_FILE.LOG, 1);

10630: LOOP
10631: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10632: END LOOP;
10633:
10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
10636: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10637: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
10636: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10637: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10639:
10640: fnd_msg_pub.ADD;
10641: fnd_msg_pub.Count_and_Get
10642: (

Line 10689: fnd_file.new_line(FND_FILE.LOG, 1);

10685: LOOP
10686: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10687: END LOOP;
10688:
10689: fnd_file.new_line(FND_FILE.LOG, 1);
10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10692: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','WORKITEM_OBJ_CODE');
10693: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

Line 10694: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10692: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','WORKITEM_OBJ_CODE');
10693: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10694: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10695:
10696: fnd_msg_pub.ADD;
10697: fnd_msg_pub.Count_and_Get
10698: (

Line 10744: fnd_file.new_line(FND_FILE.LOG, 1);

10740: LOOP
10741: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10742: END LOOP;
10743:
10744: fnd_file.new_line(FND_FILE.LOG, 1);
10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10747: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PRIORITY_CODE');
10748: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

Line 10749: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10747: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PRIORITY_CODE');
10748: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10749: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10750:
10751: fnd_msg_pub.ADD;
10752: fnd_msg_pub.Count_and_Get
10753: (

Line 10808: fnd_file.new_line(FND_FILE.LOG, 1);

10804: END LOOP;
10805:
10806: -- Work Source does not exist for this Object Code
10807:
10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
10810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10811: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
10810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10811: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10813:
10814: fnd_msg_pub.ADD;
10815: fnd_msg_pub.Count_and_Get
10816: (

Line 10886: fnd_file.new_line(FND_FILE.LOG, 1);

10882:
10883: -- Work Source Details does not exist for this Object Code
10884: l_token_str := '(IEU_UWQ_SYNC_WR_WS_DTLS_NULL) '||sqlcode||' '||sqlerrm;
10885:
10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
10888: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10889: FND_MESSAGE.SET_TOKEN('DETAILS',l_token_str);
10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
10888: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10889: FND_MESSAGE.SET_TOKEN('DETAILS',l_token_str);
10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10891:
10892: fnd_msg_pub.ADD;
10893: fnd_msg_pub.Count_and_Get
10894: (

Line 11132: fnd_file.new_line(FND_FILE.LOG, 1);

11128:
11129: IF SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 then
11130: err_flag := 'Y';
11131:
11132: fnd_file.new_line(FND_FILE.LOG, 1);
11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11135: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

Line 11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

11132: fnd_file.new_line(FND_FILE.LOG, 1);
11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11135: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11138:
11139: fnd_msg_pub.ADD;
11140: fnd_msg_pub.Count_and_Get

Line 11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11135: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11138:
11139: fnd_msg_pub.ADD;
11140: fnd_msg_pub.Count_and_Get
11141: (

Line 11193: fnd_file.new_line(FND_FILE.LOG, 1);

11189: WHEN dml_errors THEN
11190: errors := SQL%BULK_EXCEPTIONS.COUNT;
11191:
11192: FOR i IN 1..errors LOOP
11193: fnd_file.new_line(FND_FILE.LOG, 1);
11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11197:

Line 11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11197:
11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11200:
11201: fnd_msg_pub.ADD;
11202: fnd_msg_pub.Count_and_Get

Line 11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11197:
11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11200:
11201: fnd_msg_pub.ADD;
11202: fnd_msg_pub.Count_and_Get
11203: (

Line 11272: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);

11268:
11269: ROLLBACK TO sync_wr_items_sp;
11270: x_return_status := fnd_api.g_ret_sts_unexp_error;
11271:
11272: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
11273: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11274: THEN
11275:
11276: fnd_msg_pub.Count_and_Get

Line 11461: fnd_file.new_line(FND_FILE.LOG, 1);

11457:
11458: -- Work Source does not exist for this Object Code
11459: l_token_str := 'WS_CODE: '||p_ws_code;
11460:
11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11466:
11467: fnd_msg_pub.ADD;
11468: fnd_msg_pub.Count_and_Get
11469: (

Line 11485: fnd_file.new_line(FND_FILE.LOG, 1);

11481: -- If a primary Work Source is passed then it will throw an exception and exit
11482: -- Work Source does not exist for this Object Code
11483: l_token_str := 'WORK_SOURCE:' ||p_ws_code;
11484:
11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
11487: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11488: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
11487: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11488: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11490:
11491: fnd_msg_pub.ADD;
11492: fnd_msg_pub.Count_and_Get
11493: (

Line 11516: fnd_file.new_line(FND_FILE.LOG, 1);

11512:
11513: -- Work Source does not exist for this Object Code
11514: l_token_str := 'WS_CODE: '||p_ws_code;
11515:
11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11518: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11519: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11518: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11519: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11521:
11522: fnd_msg_pub.ADD;
11523: fnd_msg_pub.Count_and_Get
11524: (

Line 11552: fnd_file.new_line(FND_FILE.LOG, 1);

11548: EXCEPTION
11549: WHEN NO_DATA_FOUND THEN
11550: l_token_str := 'WS_CODE: '||p_ws_code;
11551:
11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11554: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11555: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11554: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11555: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11557:
11558: fnd_msg_pub.ADD;
11559: fnd_msg_pub.Count_and_Get
11560: (

Line 11578: fnd_file.new_line(FND_FILE.LOG, 1);

11574: EXCEPTION
11575: WHEN NO_DATA_FOUND THEN
11576: l_token_str := 'WS_CODE: '||p_ws_code;
11577:
11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11580: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11581: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11580: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11581: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11583:
11584: fnd_msg_pub.ADD;
11585: fnd_msg_pub.Count_and_Get
11586: (

Line 11598: fnd_file.new_line(FND_FILE.LOG, 1);

11594:
11595: -- The Sync script works only if Parent Work Source is ACTIVE
11596: -- Else it will throw an exception and exit
11597:
11598: fnd_file.new_line(FND_FILE.LOG, 1);
11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11601: FND_MESSAGE.SET_TOKEN('WS_NAME', l_ws_name);
11602: FND_MESSAGE.SET_TOKEN('PRIMARY_WS_NAME', l_parent_ws_name);

Line 11603: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11601: FND_MESSAGE.SET_TOKEN('WS_NAME', l_ws_name);
11602: FND_MESSAGE.SET_TOKEN('PRIMARY_WS_NAME', l_parent_ws_name);
11603: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11604:
11605: fnd_msg_pub.ADD;
11606: fnd_msg_pub.Count_and_Get
11607: (

Line 11621: fnd_file.new_line(FND_FILE.LOG, 1);

11617:
11618: -- Work Source does not exist for this Object Code
11619: l_token_str := 'WS_CODE: '||p_ws_code;
11620:
11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11623: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11624: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11623: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11624: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11626:
11627: fnd_msg_pub.ADD;
11628: fnd_msg_pub.Count_and_Get
11629: (

Line 11652: fnd_file.new_line(FND_FILE.LOG, 1);

11648:
11649: -- Work Source does not exist for this Object Code
11650: l_token_str := 'WS_CODE: '||p_ws_code;
11651:
11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11654: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11655: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
11654: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11655: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11657:
11658: fnd_msg_pub.ADD;
11659: fnd_msg_pub.Count_and_Get
11660: (

Line 11809: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11805: IF l_error_count > 1000 THEN
11806: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
11807: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11808: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11809: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11810: fnd_msg_pub.ADD;
11811: fnd_msg_pub.Count_and_Get
11812: (
11813: p_count => x_msg_count,

Line 11819: fnd_file.new_line(FND_FILE.LOG, 1);

11815: );
11816:
11817: RAISE fnd_api.g_exc_error;
11818: END IF;
11819: fnd_file.new_line(FND_FILE.LOG, 1);
11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11823:

Line 11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11823:
11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11826:
11827: fnd_msg_pub.ADD;
11828: fnd_msg_pub.Count_and_Get

Line 11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11823:
11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11826:
11827: fnd_msg_pub.ADD;
11828: fnd_msg_pub.Count_and_Get
11829: (

Line 11851: fnd_file.new_line(FND_FILE.LOG, 1);

11847: where asg.task_id = gtt.workitem_pk_id
11848: and asg.assignee_role= 'OWNER');
11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: fnd_file.new_line(FND_FILE.LOG, 1);
11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:

Line 11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);

11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11858:
11859: fnd_msg_pub.ADD;
11860: fnd_msg_pub.Count_and_Get

Line 11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11858:
11859: fnd_msg_pub.ADD;
11860: fnd_msg_pub.Count_and_Get
11861: (

Line 11905: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');

11901:
11902: l_done := c_task_status%NOTFOUND;
11903:
11904: BEGIN
11905: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
11906: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
11907: update IEU_UWQM_ITEMS
11908: set status_id = l_task_status_rec.l_status_id_list(i),
11909: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 11928: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11924: IF l_error_count > 1000 THEN
11925: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
11926: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11927: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11928: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11929: fnd_msg_pub.ADD;
11930: fnd_msg_pub.Count_and_Get
11931: (
11932: p_count => x_msg_count,

Line 11939: fnd_file.new_line(FND_FILE.LOG, 1);

11935:
11936: RAISE fnd_api.g_exc_error;
11937: END IF;
11938:
11939: fnd_file.new_line(FND_FILE.LOG, 1);
11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11942: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11943:

Line 11944: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11942: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11943:
11944: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11946: fnd_msg_pub.ADD;
11947: fnd_msg_pub.Count_and_Get
11948: (

Line 11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11942: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11943:
11944: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11946: fnd_msg_pub.ADD;
11947: fnd_msg_pub.Count_and_Get
11948: (
11949: p_count => x_msg_count,

Line 12008: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);

12004:
12005: ROLLBACK TO sync_assct_task_wr_items_sp;
12006: x_return_status := fnd_api.g_ret_sts_unexp_error;
12007:
12008: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12009: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12010: THEN
12011:
12012: fnd_msg_pub.Count_and_Get

Line 12103: fnd_file.new_line(FND_FILE.LOG, 1);

12099: WHEN dml_errors THEN
12100: errors := SQL%BULK_EXCEPTIONS.COUNT;
12101: FOR i IN 1..errors
12102: LOOP
12103: fnd_file.new_line(FND_FILE.LOG, 1);
12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
12106: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12107:

Line 12108: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
12106: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12107:
12108: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12110: fnd_msg_pub.ADD;
12111: fnd_msg_pub.Count_and_Get
12112: (

Line 12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
12106: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12107:
12108: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12110: fnd_msg_pub.ADD;
12111: fnd_msg_pub.Count_and_Get
12112: (
12113: p_count => x_msg_count,

Line 12409: fnd_file.new_line(FND_FILE.LOG, 1);

12405: (p_processing_set_id is null))
12406: THEN
12407: l_token_str := l_token_str || ' PROCESSING_SET_ID ';
12408:
12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
12411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12412: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
12411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12412: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12414:
12415: fnd_msg_pub.ADD;
12416: fnd_msg_pub.Count_and_Get
12417: (

Line 12442: fnd_file.new_line(FND_FILE.LOG, 1);

12438:
12439: -- Work Source does not exist for this Object Code
12440: l_token_str := 'WS_CODE: '||p_ws_code;
12441:
12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12444: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12445: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12444: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12445: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12447:
12448: fnd_msg_pub.ADD;
12449: fnd_msg_pub.Count_and_Get
12450: (

Line 12496: fnd_file.new_line(FND_FILE.LOG, 1);

12492: END LOOP;
12493:
12494: -- Work Source does not exist for this Object Code
12495:
12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
12498: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12499: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
12498: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12499: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12501:
12502: fnd_msg_pub.ADD;
12503: fnd_msg_pub.Count_and_Get
12504: (

Line 12527: fnd_file.new_line(FND_FILE.LOG, 1);

12523: WHEN NO_DATA_FOUND THEN
12524:
12525: -- Work Source does not exist for this Object Code
12526: l_token_str := 'WS_CODE: '||p_ws_code;
12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12530: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12530: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12532:
12533: fnd_msg_pub.ADD;
12534: fnd_msg_pub.Count_and_Get
12535: (

Line 12557: fnd_file.new_line(FND_FILE.LOG, 1);

12553: WHEN NO_DATA_FOUND THEN
12554:
12555: -- Work Source does not exist for this Object Code
12556: l_token_str := 'WS_CODE: '||p_ws_code;
12557: fnd_file.new_line(FND_FILE.LOG, 1);
12558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12557: fnd_file.new_line(FND_FILE.LOG, 1);
12558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12562: fnd_msg_pub.ADD;
12563: fnd_msg_pub.Count_and_Get
12564: (
12565: p_count => x_msg_count,

Line 12586: fnd_file.new_line(FND_FILE.LOG, 1);

12582: WHEN NO_DATA_FOUND THEN
12583:
12584: -- Work Source does not exist for this Object Code
12585: l_token_str := 'WS_CODE: '||p_ws_code;
12586: fnd_file.new_line(FND_FILE.LOG, 1);
12587: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12589: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12586: fnd_file.new_line(FND_FILE.LOG, 1);
12587: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12589: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12591: fnd_msg_pub.ADD;
12592: fnd_msg_pub.Count_and_Get
12593: (
12594: p_count => x_msg_count,

Line 12636: fnd_file.new_line(FND_FILE.LOG, 1);

12632: END LOOP;
12633:
12634: -- Work Source does not exist for this Object Code
12635:
12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
12638: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12639: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
12638: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12639: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12641:
12642: fnd_msg_pub.ADD;
12643: fnd_msg_pub.Count_and_Get
12644: (

Line 12686: fnd_file.new_line(FND_FILE.LOG, 1);

12682: LOOP
12683: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
12684: END LOOP;
12685:
12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
12688: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12689: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
12688: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12689: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12691:
12692: fnd_msg_pub.ADD;
12693: fnd_msg_pub.Count_and_Get
12694: (

Line 12737: fnd_file.new_line(FND_FILE.LOG, 1);

12733: WHEN dml_errors THEN
12734: errors := SQL%BULK_EXCEPTIONS.COUNT;
12735:
12736: FOR i IN 1..errors LOOP
12737: fnd_file.new_line(FND_FILE.LOG, 1);
12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12740: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_item_status_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12741:

Line 12742: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12740: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_item_status_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12741:
12742: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12744: fnd_msg_pub.ADD;
12745: fnd_msg_pub.Count_and_Get
12746: (

Line 12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12740: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_item_status_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12741:
12742: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12744: fnd_msg_pub.ADD;
12745: fnd_msg_pub.Count_and_Get
12746: (
12747: p_count => x_msg_count,

Line 12794: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);

12790:
12791: ROLLBACK TO SYNC_WR_ITEM_STATUS_SP;
12792: x_return_status := fnd_api.g_ret_sts_unexp_error;
12793:
12794: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12795: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12796: THEN
12797:
12798: fnd_msg_pub.Count_and_Get

Line 12895: fnd_file.new_line(FND_FILE.LOG, 1);

12891:
12892: -- Work Source does not exist for this Object Code
12893: l_token_str := 'WS_CODE: '||p_ws_code;
12894:
12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12898: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12898: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12900:
12901: fnd_msg_pub.ADD;
12902: fnd_msg_pub.Count_and_Get
12903: (

Line 12924: -- fnd_file.put_line(FND_FILE.LOG,'due date task id cnt: '||l_task_duedate_rec.l_task_id_list.COUNT);

12920: BULK COLLECT INTO
12921: l_wr_item_status_rec.WORK_ITEM_ID_LIST
12922: LIMIT l_array_size;
12923:
12924: -- fnd_file.put_line(FND_FILE.LOG,'due date task id cnt: '||l_task_duedate_rec.l_task_id_list.COUNT);
12925: l_done := c_status%NOTFOUND;
12926:
12927: BEGIN
12928: FORALL i in 1..l_wr_item_status_rec.WORK_ITEM_ID_LIST.COUNT SAVE EXCEPTIONS

Line 12942: fnd_file.new_line(FND_FILE.LOG, 1);

12938: WHEN dml_errors THEN
12939: errors := SQL%BULK_EXCEPTIONS.COUNT;
12940: FOR i IN 1..errors LOOP
12941:
12942: fnd_file.new_line(FND_FILE.LOG, 1);
12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12945: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORK_ITEM_ID:'||l_wr_item_status_rec.WORK_ITEM_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12946:

Line 12947: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12945: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORK_ITEM_ID:'||l_wr_item_status_rec.WORK_ITEM_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12946:
12947: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12949: fnd_msg_pub.ADD;
12950: fnd_msg_pub.Count_and_Get
12951: (

Line 12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12945: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORK_ITEM_ID:'||l_wr_item_status_rec.WORK_ITEM_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12946:
12947: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12949: fnd_msg_pub.ADD;
12950: fnd_msg_pub.Count_and_Get
12951: (
12952: p_count => x_msg_count,

Line 13002: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);

12998:
12999: ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;
13000: x_return_status := fnd_api.g_ret_sts_unexp_error;
13001:
13002: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
13003: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13004: THEN
13005:
13006: fnd_msg_pub.Count_and_Get