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.PO_GEN_DIFF_PKG dependencies on FND_LOG

Line 137: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

133:
134: BEGIN
135:
136: l_progress := '0010';
137: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
138: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_differences');
139: END IF;
140:
141: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 138: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_differences');

134: BEGIN
135:
136: l_progress := '0010';
137: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
138: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_differences');
139: END IF;
140:
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:

Line 156: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

152: mod_pk4 := mod_pk4_value;
153: mod_pk5 := mod_pk5_value;
154:
155: l_progress := '0020';
156: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
157: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' pk_values assigned');
158: END IF;
159:
160:

Line 157: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' pk_values assigned');

153: mod_pk5 := mod_pk5_value;
154:
155: l_progress := '0020';
156: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
157: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' pk_values assigned');
158: END IF;
159:
160:
161: -- forming where condition for base document

Line 237: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

233: l_mod_pk5 := 1 ;
234: END IF;
235:
236: l_progress := '0030';
237: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
238: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' comparision where clause formed');
239: END IF;
240:
241:

Line 238: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' comparision where clause formed');

234: END IF;
235:
236: l_progress := '0030';
237: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
238: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' comparision where clause formed');
239: END IF;
240:
241:
242:

Line 250: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

246: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| base_doc_source;
247: execute immediate l_temp;
248:
249: l_progress := '0040';
250: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
251: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' base records inserted into gt');
252: END IF;
253:
254:

Line 251: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' base records inserted into gt');

247: execute immediate l_temp;
248:
249: l_progress := '0040';
250: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
251: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' base records inserted into gt');
252: END IF;
253:
254:
255:

Line 262: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

258: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE, COL_NAME, COL_VALUE, COL_DESC from '|| mod_doc_source;
259: execute immediate l_temp;
260:
261: l_progress := '0050';
262: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
263: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' mod records inserted into gt');
264: END IF;
265:
266:

Line 263: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' mod records inserted into gt');

259: execute immediate l_temp;
260:
261: l_progress := '0050';
262: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
263: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' mod records inserted into gt');
264: END IF;
265:
266:
267:

Line 338: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

334: END IF;
335: END LOOP;
336:
337: l_progress := '0060';
338: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
339: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' differences inserted into '||dest_table_name);
340: END IF;
341:
342:

Line 339: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' differences inserted into '||dest_table_name);

335: END LOOP;
336:
337: l_progress := '0060';
338: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
339: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' differences inserted into '||dest_table_name);
340: END IF;
341:
342:
343: --deleting mod and base records from gt

Line 347: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

343: --deleting mod and base records from gt
344: delete from PO_ENTITY_GT;
345:
346: l_progress := '0070';
347: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
348: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted records from gt');
349: END IF;
350:
351:

Line 348: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted records from gt');

344: delete from PO_ENTITY_GT;
345:
346: l_progress := '0070';
347: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
348: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted records from gt');
349: END IF;
350:
351:
352: l_progress := '0080';

Line 353: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

349: END IF;
350:
351:
352: l_progress := '0080';
353: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
354: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc:generate_differences');
355: END IF;
356:
357: EXCEPTION

Line 354: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc:generate_differences');

350:
351:
352: l_progress := '0080';
353: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
354: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc:generate_differences');
355: END IF;
356:
357: EXCEPTION
358: WHEN OTHERS THEN

Line 363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_errormsg := 'Unexpectional error occured';
361:
362: l_progress := '0090';
363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
364: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
365: END IF;
366: END;
367:

Line 364: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

360: x_errormsg := 'Unexpectional error occured';
361:
362: l_progress := '0090';
363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
364: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
365: END IF;
366: END;
367:
368:

Line 406: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

402:
403: BEGIN
404:
405: l_progress := '0010';
406: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
407: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: find_differences');
408: END IF;
409:
410: IF p_entity_name = 'ALL' THEN

Line 407: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: find_differences');

403: BEGIN
404:
405: l_progress := '0010';
406: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
407: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: find_differences');
408: END IF;
409:
410: IF p_entity_name = 'ALL' THEN
411: FOR REC IN c_entities LOOP

Line 481: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

477: END LOOP;
478: END IF;
479:
480: l_progress := '0020';
481: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
482: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' return_status:' ||l_return_status);
483: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' error_msg:' ||l_error_msg);
484: END IF;
485:

Line 482: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' return_status:' ||l_return_status);

478: END IF;
479:
480: l_progress := '0020';
481: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
482: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' return_status:' ||l_return_status);
483: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' error_msg:' ||l_error_msg);
484: END IF;
485:
486: l_progress := '0030';

Line 483: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' error_msg:' ||l_error_msg);

479:
480: l_progress := '0020';
481: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
482: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' return_status:' ||l_return_status);
483: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' error_msg:' ||l_error_msg);
484: END IF;
485:
486: l_progress := '0030';
487: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 487: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

483: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' error_msg:' ||l_error_msg);
484: END IF;
485:
486: l_progress := '0030';
487: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
488: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: find_differences');
489: END IF;
490:
491: END;

Line 488: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: find_differences');

484: END IF;
485:
486: l_progress := '0030';
487: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
488: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: find_differences');
489: END IF;
490:
491: END;
492:

Line 516: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

512:
513: BEGIN
514:
515: l_progress := '0010';
516: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
517: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: delete_differences');
518: END IF;
519:
520:

Line 517: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: delete_differences');

513: BEGIN
514:
515: l_progress := '0010';
516: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
517: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: delete_differences');
518: END IF;
519:
520:
521: --forming base document where clause

Line 617: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

613: l_sql_stmt := 'DELETE FROM ' || dest_table_name || ' ' || l_where_stmt;
614: execute immediate l_sql_stmt;
615:
616: l_progress := '0020';
617: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
618: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted differences from '||dest_table_name);
619: END IF;
620:
621:

Line 618: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted differences from '||dest_table_name);

614: execute immediate l_sql_stmt;
615:
616: l_progress := '0020';
617: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
618: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' deleted differences from '||dest_table_name);
619: END IF;
620:
621:
622: l_progress := '0030';

Line 623: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

619: END IF;
620:
621:
622: l_progress := '0030';
623: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
624: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: delete_differences');
625: END IF;
626:
627:

Line 624: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: delete_differences');

620:
621:
622: l_progress := '0030';
623: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
624: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' End proc: delete_differences');
625: END IF;
626:
627:
628:

Line 632: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: l_progress := '0040';
632: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
633: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
634: END IF;
635: END;
636:

Line 633: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');

629: EXCEPTION
630: WHEN OTHERS THEN
631: l_progress := '0040';
632: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
633: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured');
634: END IF;
635: END;
636:
637:

Line 682: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

678:
679: BEGIN
680: l_progress := '0010';
681:
682: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_par_differences');
684: END IF;
685:
686: base_pk1 := base_pk1_value;

Line 683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_par_differences');

679: BEGIN
680: l_progress := '0010';
681:
682: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
683: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: generate_par_differences');
684: END IF;
685:
686: base_pk1 := base_pk1_value;
687: base_pk2 := base_pk2_value;

Line 830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

826: delete from PO_ENTITY_GT;
827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||'0080'||' Unexpected error occured ' || SQLERRM );
832: END IF;
833: delete from PO_ENTITY_GT;
834: END generate_par_differences;

Line 831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||'0080'||' Unexpected error occured ' || SQLERRM );

827:
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
831: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||'0080'||' Unexpected error occured ' || SQLERRM );
832: END IF;
833: delete from PO_ENTITY_GT;
834: END generate_par_differences;
835:

Line 853: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

849: BEGIN
850:
851: l_progress := '0010';
852:
853: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
854: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_header');
855: END IF;
856:
857: --Insert archive data for a given revision

Line 854: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_header');

850:
851: l_progress := '0010';
852:
853: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
854: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_header');
855: END IF;
856:
857: --Insert archive data for a given revision
858: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 884: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

880: AND phdv.revision_num = phd.revision_num;
881:
882:
883: l_progress := '0020';
884: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
885: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
886: END IF;
887:
888: l_progress := '0025';

Line 885: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

881:
882:
883: l_progress := '0020';
884: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
885: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
886: END IF;
887:
888: l_progress := '0025';
889: --Insert uda archive data for a given revision

Line 916: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

912: AND phdv.revision_num = phd.revision_num;
913:
914:
915: l_progress := '0027';
916: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
917: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
918: END IF;
919:
920: --Insert addresses uda archive data for a given revision

Line 917: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

913:
914:
915: l_progress := '0027';
916: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
917: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
918: END IF;
919:
920: --Insert addresses uda archive data for a given revision
921: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 947: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

943: AND phdv.revision_num = phd.revision_num;
944:
945:
946: l_progress := '0029';
947: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
948: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from addresses uda archive : ' || SQL%ROWCOUNT);
949: END IF;
950:
951: --Insert current PAR data i.e. draft data

Line 948: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from addresses uda archive : ' || SQL%ROWCOUNT);

944:
945:
946: l_progress := '0029';
947: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
948: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from addresses uda archive : ' || SQL%ROWCOUNT);
949: END IF;
950:
951: --Insert current PAR data i.e. draft data
952: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

970: WHERE phdv.pk1_value = mod_pk1
971: AND phdv.pk2_value = mod_pk2;
972:
973: l_progress := '0030';
974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
976: END IF;
977:
978: --Insert current PAR uda data i.e. ext data

Line 975: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

971: AND phdv.pk2_value = mod_pk2;
972:
973: l_progress := '0030';
974: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
976: END IF;
977:
978: --Insert current PAR uda data i.e. ext data
979: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1001: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

997: WHERE phdv.pk1_value = mod_pk1
998: AND phdv.pk2_value = mod_pk2;
999:
1000: l_progress := '0040';
1001: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1002: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1003: END IF;
1004:
1005: --Insert current PAR uda addresses data i.e. ext data

Line 1002: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

998: AND phdv.pk2_value = mod_pk2;
999:
1000: l_progress := '0040';
1001: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1002: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1003: END IF;
1004:
1005: --Insert current PAR uda addresses data i.e. ext data
1006: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1028: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1024: WHERE phdv.pk1_value = mod_pk1
1025: AND phdv.pk2_value = mod_pk2;
1026:
1027: l_progress := '0050';
1028: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1029: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1030: END IF;
1031:
1032: EXCEPTION

Line 1029: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1025: AND phdv.pk2_value = mod_pk2;
1026:
1027: l_progress := '0050';
1028: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1029: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN

Line 1035: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: l_progress := '0060';
1035: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1036: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1037: END IF;
1038:
1039: DELETE FROM PO_ENTITY_GT;

Line 1036: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);

1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: l_progress := '0060';
1035: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1036: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1037: END IF;
1038:
1039: DELETE FROM PO_ENTITY_GT;
1040: RAISE;

Line 1059: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1055: BEGIN
1056:
1057: l_progress := '0010';
1058:
1059: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1060: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_lines');
1061: END IF;
1062:
1063: --Insert archive data for a given revision

Line 1060: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_lines');

1056:
1057: l_progress := '0010';
1058:
1059: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1060: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_lines');
1061: END IF;
1062:
1063: --Insert archive data for a given revision
1064: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1091: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1087: AND pldv.revision_num = pld.revision_num;
1088:
1089:
1090: l_progress := '0020';
1091: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1092: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1093: END IF;
1094:
1095: --Insert uda archive data for a given revision

Line 1092: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

1088:
1089:
1090: l_progress := '0020';
1091: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1092: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1093: END IF;
1094:
1095: --Insert uda archive data for a given revision
1096: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1123: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1119: AND pldv.revision_num = pld.revision_num;
1120:
1121:
1122: l_progress := '0025';
1123: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1125: END IF;
1126:
1127: --Insert current PAR data i.e. draft data

Line 1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

1120:
1121:
1122: l_progress := '0025';
1123: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1124: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1125: END IF;
1126:
1127: --Insert current PAR data i.e. draft data
1128: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1150: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1146: WHERE pldv.pk1_value = mod_pk1
1147: AND pldv.pk2_value = mod_pk2;
1148:
1149: l_progress := '0030';
1150: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1151: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1152: END IF;
1153:
1154: --Insert current PAR uda data i.e. ext data

Line 1151: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1147: AND pldv.pk2_value = mod_pk2;
1148:
1149: l_progress := '0030';
1150: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1151: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1152: END IF;
1153:
1154: --Insert current PAR uda data i.e. ext data
1155: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1177: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1173: WHERE pldv.pk1_value = mod_pk1
1174: AND pldv.pk2_value = mod_pk2;
1175:
1176: l_progress := '0040';
1177: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1178: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1179: END IF;
1180:
1181: EXCEPTION

Line 1178: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1174: AND pldv.pk2_value = mod_pk2;
1175:
1176: l_progress := '0040';
1177: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1178: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1179: END IF;
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN

Line 1184: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: l_progress := '0050';
1184: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1185: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1186: END IF;
1187:
1188: DELETE FROM PO_ENTITY_GT;

Line 1185: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);

1181: EXCEPTION
1182: WHEN OTHERS THEN
1183: l_progress := '0050';
1184: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1185: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1186: END IF;
1187:
1188: DELETE FROM PO_ENTITY_GT;
1189: RAISE;

Line 1208: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1204: BEGIN
1205:
1206: l_progress := '0010';
1207:
1208: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1209: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_line_locs');
1210: END IF;
1211:
1212: --Insert archive data for a given revision

Line 1209: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_line_locs');

1205:
1206: l_progress := '0010';
1207:
1208: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1209: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_line_locs');
1210: END IF;
1211:
1212: --Insert archive data for a given revision
1213: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1240: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1236: AND pldv.revision_num = pld.revision_num;
1237:
1238:
1239: l_progress := '0020';
1240: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1241: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1242: END IF;
1243:
1244: --Insert archive uda data for a given revision

Line 1241: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

1237:
1238:
1239: l_progress := '0020';
1240: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1241: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1242: END IF;
1243:
1244: --Insert archive uda data for a given revision
1245: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1272: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1268: AND pldv.revision_num = pld.revision_num;
1269:
1270:
1271: l_progress := '0025';
1272: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1273: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1274: END IF;
1275:
1276: --Insert current PAR data i.e. draft data

Line 1273: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);

1269:
1270:
1271: l_progress := '0025';
1272: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1273: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda archive : ' || SQL%ROWCOUNT);
1274: END IF;
1275:
1276: --Insert current PAR data i.e. draft data
1277: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1299: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1295: WHERE pldv.pk1_value = mod_pk1
1296: AND pldv.pk2_value = mod_pk2;
1297:
1298: l_progress := '0030';
1299: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1300: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1301: END IF;
1302:
1303: --Insert current PAR uda data i.e. ext data

Line 1300: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1296: AND pldv.pk2_value = mod_pk2;
1297:
1298: l_progress := '0030';
1299: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1300: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1301: END IF;
1302:
1303: --Insert current PAR uda data i.e. ext data
1304: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1326: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1322: WHERE pldv.pk1_value = mod_pk1
1323: AND pldv.pk2_value = mod_pk2;
1324:
1325: l_progress := '0040';
1326: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1327: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda : ' || SQL%ROWCOUNT);
1328: END IF;
1329:
1330:

Line 1327: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda : ' || SQL%ROWCOUNT);

1323: AND pldv.pk2_value = mod_pk2;
1324:
1325: l_progress := '0040';
1326: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1327: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from uda : ' || SQL%ROWCOUNT);
1328: END IF;
1329:
1330:
1331: EXCEPTION

Line 1334: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: l_progress := '0050';
1334: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1335: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1336: END IF;
1337:
1338: DELETE FROM PO_ENTITY_GT;

Line 1335: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);

1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: l_progress := '0050';
1334: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1335: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1336: END IF;
1337:
1338: DELETE FROM PO_ENTITY_GT;
1339: RAISE;

Line 1358: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1354: BEGIN
1355:
1356: l_progress := '0010';
1357:
1358: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1359: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_distributions');
1360: END IF;
1361:
1362: --Insert archive data for a given revision

Line 1359: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_distributions');

1355:
1356: l_progress := '0010';
1357:
1358: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1359: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_distributions');
1360: END IF;
1361:
1362: --Insert archive data for a given revision
1363: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1390: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1386: AND pdv.revision_num = pd.revision_num;
1387:
1388:
1389: l_progress := '0020';
1390: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1391: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1392: END IF;
1393:
1394: --Insert current PAR data i.e. draft data

Line 1391: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

1387:
1388:
1389: l_progress := '0020';
1390: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1391: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1392: END IF;
1393:
1394: --Insert current PAR data i.e. draft data
1395: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1417: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1413: WHERE pdv.pk1_value = mod_pk1
1414: AND pdv.pk2_value = mod_pk2;
1415:
1416: l_progress := '0030';
1417: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1419: END IF;
1420:
1421: EXCEPTION

Line 1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1414: AND pdv.pk2_value = mod_pk2;
1415:
1416: l_progress := '0030';
1417: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1419: END IF;
1420:
1421: EXCEPTION
1422: WHEN OTHERS THEN

Line 1424: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1420:
1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: l_progress := '0040';
1424: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1425: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1426: END IF;
1427:
1428: DELETE FROM PO_ENTITY_GT;

Line 1425: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);

1421: EXCEPTION
1422: WHEN OTHERS THEN
1423: l_progress := '0040';
1424: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1425: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1426: END IF;
1427:
1428: DELETE FROM PO_ENTITY_GT;
1429: RAISE;

Line 1494: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1490: BEGIN
1491:
1492: l_progress := '0010';
1493:
1494: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1495: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_elins');
1496: END IF;
1497:
1498: --Insert archive data for a given revision

Line 1495: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_elins');

1491:
1492: l_progress := '0010';
1493:
1494: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1495: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Begin proc: populate_par_elins');
1496: END IF;
1497:
1498: --Insert archive data for a given revision
1499: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1526: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1522: AND pdv.revision_num = pd.revision_num;
1523:
1524:
1525: l_progress := '0020';
1526: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1527: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1528: END IF;
1529:
1530: --Insert current PAR data i.e. draft data

Line 1527: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);

1523:
1524:
1525: l_progress := '0020';
1526: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1527: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from archive : ' || SQL%ROWCOUNT);
1528: END IF;
1529:
1530: --Insert current PAR data i.e. draft data
1531: INSERT INTO PO_ENTITY_GT ( PK1_VALUE,

Line 1553: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1549: WHERE pdv.pk1_value = mod_pk1
1550: AND pdv.pk2_value = mod_pk2;
1551:
1552: l_progress := '0030';
1553: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1555: END IF;
1556:
1557: EXCEPTION

Line 1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);

1550: AND pdv.pk2_value = mod_pk2;
1551:
1552: l_progress := '0030';
1553: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1554: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Rows Inserted from draft : ' || SQL%ROWCOUNT);
1555: END IF;
1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN

Line 1560: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: l_progress := '0040';
1560: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1562: END IF;
1563:
1564: DELETE FROM PO_ENTITY_GT;

Line 1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);

1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: l_progress := '0040';
1560: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1561: FND_LOG.string(fnd_log.level_statement, g_log_module_name, 'progress:='||l_progress||' Unexpected error occured ' || SQLERRM);
1562: END IF;
1563:
1564: DELETE FROM PO_ENTITY_GT;
1565: RAISE;