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_CATALOG_INDEX_PVT dependencies on PO_DEBUG

Line 8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_CATALOG_INDEX_PVT';
5: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: -- Read the profile option that enables/disables the debug log
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11: g_application_err_num CONSTANT NUMBER := -20000;
12:

Line 9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

5: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: -- Read the profile option that enables/disables the debug log
8: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
9: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
10:
11: g_application_err_num CONSTANT NUMBER := -20000;
12:
13: -- Forward function declarations: Start

Line 156: PO_DEBUG.debug_begin(l_log_head);

152: BEGIN
153:
154: -- Log the input parameters into debug logs
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_begin(l_log_head);
157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);
158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);
160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);

Line 157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);

153:
154: -- Log the input parameters into debug logs
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_begin(l_log_head);
157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);
158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);
160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);
161:

Line 158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);

154: -- Log the input parameters into debug logs
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_begin(l_log_head);
157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);
158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);
160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);
161:
162: IF ( (p_po_header_ids IS NOT NULL) AND

Line 159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);

155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_begin(l_log_head);
157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);
158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);
160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);
161:
162: IF ( (p_po_header_ids IS NOT NULL) AND
163: (p_po_header_ids.COUNT > 0) ) THEN

Line 160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);

156: PO_DEBUG.debug_begin(l_log_head);
157: PO_DEBUG.debug_var(l_log_head,l_progress,'p_type',p_type);
158: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
159: PO_DEBUG.debug_var(l_log_head,l_progress,'p_reqexpress_name',p_reqexpress_name);
160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);
161:
162: IF ( (p_po_header_ids IS NOT NULL) AND
163: (p_po_header_ids.COUNT > 0) ) THEN
164: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids.COUNT',p_po_header_ids.COUNT);

Line 164: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids.COUNT',p_po_header_ids.COUNT);

160: PO_DEBUG.debug_var(l_log_head,l_progress,'p_org_id',p_org_id);
161:
162: IF ( (p_po_header_ids IS NOT NULL) AND
163: (p_po_header_ids.COUNT > 0) ) THEN
164: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids.COUNT',p_po_header_ids.COUNT);
165: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids(1)',p_po_header_ids(1));
166: ELSE
167: PO_DEBUG.debug_stmt (l_log_head,l_progress,'p_po_header_ids LIST is NULL');
168: END IF;

Line 165: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids(1)',p_po_header_ids(1));

161:
162: IF ( (p_po_header_ids IS NOT NULL) AND
163: (p_po_header_ids.COUNT > 0) ) THEN
164: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids.COUNT',p_po_header_ids.COUNT);
165: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids(1)',p_po_header_ids(1));
166: ELSE
167: PO_DEBUG.debug_stmt (l_log_head,l_progress,'p_po_header_ids LIST is NULL');
168: END IF;
169: END IF;

Line 167: PO_DEBUG.debug_stmt (l_log_head,l_progress,'p_po_header_ids LIST is NULL');

163: (p_po_header_ids.COUNT > 0) ) THEN
164: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids.COUNT',p_po_header_ids.COUNT);
165: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_ids(1)',p_po_header_ids(1));
166: ELSE
167: PO_DEBUG.debug_stmt (l_log_head,l_progress,'p_po_header_ids LIST is NULL');
168: END IF;
169: END IF;
170:
171: l_progress := '010';

Line 243: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Invalid type:'||p_type); END IF;

239: populate_sessiongt_for_rt( p_reqexpress_name => p_reqexpress_name
240: , p_org_id => p_org_id);
241: ELSE
242: -- Invalid type
243: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Invalid type:'||p_type); END IF;
244: END IF;
245:
246: l_progress := '020';
247: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

Line 247: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

243: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Invalid type:'||p_type); END IF;
244: END IF;
245:
246: l_progress := '020';
247: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

Line 251: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

247: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
252: -- do not raise the exception as rebuild_index errors have to be ignored
253: -- by the calling program.
254: END rebuild_index;
255:

Line 308: PO_DEBUG.debug_begin(l_log_head);

304:
305: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
306: BEGIN
307: IF g_debug_stmt THEN
308: PO_DEBUG.debug_begin(l_log_head);
309: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
310: END IF;
311:
312: l_progress := '010';

Line 309: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);

305: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
306: BEGIN
307: IF g_debug_stmt THEN
308: PO_DEBUG.debug_begin(l_log_head);
309: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
310: END IF;
311:
312: l_progress := '010';
313: -- pick a new key for temp table

Line 337: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

333:
334: l_num_rows_is_gt := SQL%rowcount;
335:
336: l_progress := '030';
337: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
338:
339: IF (l_num_rows_is_gt > 0) THEN
340: IF g_debug_stmt THEN
341: PO_LOG.stmt_session_gt

Line 354: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);

350: INTO l_segment1
351: FROM PO_HEADERS_ALL
352: WHERE po_header_id = p_po_header_id;
353:
354: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
355: END IF;
356:
357: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() to rebuild index'); END IF;
358: -- Call iproc api for rebuild index for Quotations

Line 357: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() to rebuild index'); END IF;

353:
354: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
355: END IF;
356:
357: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() to rebuild index'); END IF;
358: -- Call iproc api for rebuild index for Quotations
359: -- Pass in the key for PO_SESSION_GT table
360: l_progress := '040';
361:

Line 377: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() returned error: '||l_return_status); END IF;

373: -- In case of error, just log in debug logs. There is no need to raise
374: -- it up, because rebuild_index errors have to be ignored by the calling
375: -- program.
376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() returned error: '||l_return_status); END IF;
378: END IF;
379: ELSE
380: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes()'); END IF;
381: END IF;

Line 380: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes()'); END IF;

376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes() returned error: '||l_return_status); END IF;
378: END IF;
379: ELSE
380: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes()'); END IF;
381: END IF;
382:
383: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
384: EXCEPTION

Line 383: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

379: ELSE
380: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_QUOTE_GRP.populateOnlineQuotes()'); END IF;
381: END IF;
382:
383: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
387: END populate_sessiongt_for_quote;

Line 386: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

382:
383: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
387: END populate_sessiongt_for_quote;
388:
389: --------------------------------------------------------------------------------
390: --Start of Comments

Line 435: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

431: l_key PO_SESSION_GT.key%TYPE;
432: l_return_status VARCHAR2(1);
433: l_num_rows_is_gt NUMBER := 0;
434: BEGIN
435: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
436:
437: l_progress := '010';
438: -- pick a new key for temp table
439: SELECT PO_SESSION_GT_S.nextval

Line 465: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

461:
462: l_num_rows_is_gt := SQL%rowcount;
463:
464: l_progress := '030';
465: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
466:
467: IF (l_num_rows_is_gt > 0) THEN
468: IF g_debug_stmt THEN
469: PO_LOG.stmt_session_gt

Line 478: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() to rebuild index'); END IF;

474: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
475: );
476: END IF;
477:
478: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() to rebuild index'); END IF;
479: -- Call iproc api for rebuild index for ReqTemplates
480: -- Pass in the key for PO_SESSION_GT table
481: l_progress := '040';
482:

Line 498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;

494: -- In case of error, just log in debug logs. There is no need to raise
495: -- it up, because rebuild_index errors have to be ignored by the calling
496: -- program.
497: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;
499: END IF;
500: ELSE
501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;
502: END IF;

Line 501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;

497: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates() returned error: '||l_return_status); END IF;
499: END IF;
500: ELSE
501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;
502: END IF;
503:
504: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
505: EXCEPTION

Line 504: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

500: ELSE
501: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_REQTMPL_GRP.populateOnlineReqTemplates()'); END IF;
502: END IF;
503:
504: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
508: END populate_sessiongt_for_rt;

Line 507: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

503:
504: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
508: END populate_sessiongt_for_rt;
509:
510: --------------------------------------------------------------------------------
511: --Start of Comments

Line 563: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

559: l_return_status VARCHAR2(1);
560: l_num_rows_is_gt NUMBER := 0;
561:
562: BEGIN
563: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
564:
565: l_progress := '010';
566: -- pick a new key for temp table, to store records to be passed to iProc
567: SELECT PO_SESSION_GT_S.nextval

Line 595: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs inserted into GT table='||SQL%rowcount); END IF;

591: , p_po_header_ids(i) -- List of Input PO_HEADER_ID's
592: , 'Remaining PO_HEADER_IDs' -- DATA INFO: Internal to PO
593: );
594:
595: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs inserted into GT table='||SQL%rowcount); END IF;
596:
597: -- Insert lines for headers that have been modified
598: -- The fields that need rebuild index are:
599: -- SUPPLIER, SUPPLIER_SITE

Line 673: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||l_num_rows_is_gt); END IF;

669: INTO l_num_rows_is_gt
670: FROM PO_SESSION_GT
671: WHERE key = l_key;
672:
673: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||l_num_rows_is_gt); END IF;
674:
675: IF (l_num_rows_is_gt > 0) THEN
676: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() to rebuild index'); END IF;
677: -- Call iproc api for rebuild index for ReqTemplates

Line 676: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() to rebuild index'); END IF;

672:
673: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||l_num_rows_is_gt); END IF;
674:
675: IF (l_num_rows_is_gt > 0) THEN
676: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() to rebuild index'); END IF;
677: -- Call iproc api for rebuild index for ReqTemplates
678: -- Pass in the key for PO_SESSION_GT table
679: l_progress := '040';
680:

Line 706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;

702: -- In case of error, just log in debug logs. There is no need to raise
703: -- it up, because rebuild_index errors have to be ignored by the calling
704: -- program.
705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;
707: END IF;
708: ELSE
709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;
710: END IF;

Line 709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;

705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
706: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets() returned error: '||l_return_status); END IF;
707: END IF;
708: ELSE
709: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineBlankets()'); END IF;
710: END IF;
711:
712: -- Finally, see if Org Assignments have changed, and call a separate
713: -- iProc API, to pass in Org Assignment information

Line 719: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

715: (
716: p_po_header_ids => p_po_header_ids
717: );
718:
719: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
720: EXCEPTION
721: WHEN OTHERS THEN
722: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
723: END populate_sessiongt_for_pa;

Line 722: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

718:
719: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
720: EXCEPTION
721: WHEN OTHERS THEN
722: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
723: END populate_sessiongt_for_pa;
724:
725: --------------------------------------------------------------------------------
726: --Start of Comments

Line 768: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

764: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
765: l_progress VARCHAR2(3) := '000';
766:
767: BEGIN
768: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
769:
770: l_progress := '010';
771:
772: -- Insert lines for headers that have been modified

Line 824: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

820: (POH.vendor_site_id IS NULL AND POHA.vendor_site_id IS NOT NULL) OR
821: (POH.vendor_site_id IS NOT NULL AND POHA.vendor_site_id IS NULL))));
822: */
823:
824: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
825:
826: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
827: EXCEPTION
828: WHEN OTHERS THEN

Line 826: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

822: */
823:
824: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
825:
826: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
827: EXCEPTION
828: WHEN OTHERS THEN
829: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
830: END insert_header_changes;

Line 829: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

825:
826: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
827: EXCEPTION
828: WHEN OTHERS THEN
829: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
830: END insert_header_changes;
831:
832: --------------------------------------------------------------------------------
833: --Start of Comments

Line 876: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

872: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
873: l_progress VARCHAR2(3) := '000';
874:
875: BEGIN
876: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
877:
878: l_progress := '010';
879: -- Now we have only those documents that did not have header changes
880: -- For these documents check if there were any line changes

Line 948: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

944: (POL.vendor_product_num IS NULL AND POLA.vendor_product_num IS NOT NULL) OR
945: (POL.vendor_product_num IS NOT NULL AND POLA.vendor_product_num IS NULL))));
946: */
947:
948: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
949:
950: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
951: EXCEPTION
952: WHEN OTHERS THEN

Line 950: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

946: */
947:
948: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
949:
950: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
954: END insert_line_changes;

Line 953: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

949:
950: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
954: END insert_line_changes;
955:
956: --------------------------------------------------------------------------------
957: --Start of Comments

Line 996: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

992: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
993: l_progress VARCHAR2(3) := '000';
994:
995: BEGIN
996: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
997:
998: l_progress := '010';
999: -- Now we have the documents for which there were no Header or Line
1000: -- changes, but there could potentialy be some Attribute changes

Line 1033: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

1029: AND POL.po_header_id = POH.po_header_id
1030: AND POATR.po_line_id = POL.po_line_id
1031: AND POATR.rebuild_search_index_flag = 'Y';
1032:
1033: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
1034:
1035: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1035: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1031: AND POATR.rebuild_search_index_flag = 'Y';
1032:
1033: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
1034:
1035: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1039: END insert_attr_changes;

Line 1038: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1034:
1035: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1039: END insert_attr_changes;
1040:
1041: --------------------------------------------------------------------------------
1042: --Start of Comments

Line 1081: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

1077: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1078: l_progress VARCHAR2(3) := '000';
1079:
1080: BEGIN
1081: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1082:
1083: l_progress := '010';
1084: -- Now we have the documents for which there were no Header/Line/Attr
1085: -- changes, but there could potentialy be some TLP changes

Line 1118: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;

1114: AND POL.po_header_id = POH.po_header_id
1115: AND POTLP.po_line_id = POL.po_line_id
1116: AND POTLP.rebuild_search_index_flag = 'Y';
1117:
1118: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
1119:
1120: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1121: EXCEPTION
1122: WHEN OTHERS THEN

Line 1120: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1116: AND POTLP.rebuild_search_index_flag = 'Y';
1117:
1118: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or recs inserted into GT table='||SQL%rowcount); END IF;
1119:
1120: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1124: END insert_tlp_changes;

Line 1123: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1119:
1120: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1124: END insert_tlp_changes;
1125:
1126: --------------------------------------------------------------------------------
1127: --Start of Comments

Line 1166: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

1162: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1163: l_progress VARCHAR2(3) := '000';
1164:
1165: BEGIN
1166: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1167:
1168: l_progress := '010';
1169: -- From the input list, delete those that were already marked as having
1170: -- header level changes. The PO_HEADER_ID in the to-be-processed queue

Line 1180: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs deleted='||SQL%rowcount); END IF;

1176: FROM PO_SESSION_GT GT1
1177: WHERE GT1.key = p_key
1178: AND GT1.index_num2 = GT_REMAINING_HDRS.index_num1);
1179:
1180: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs deleted='||SQL%rowcount); END IF;
1181:
1182: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN

Line 1182: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1178: AND GT1.index_num2 = GT_REMAINING_HDRS.index_num1);
1179:
1180: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs deleted='||SQL%rowcount); END IF;
1181:
1182: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1186: END delete_processed_headers;

Line 1185: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1181:
1182: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1186: END delete_processed_headers;
1187:
1188: --------------------------------------------------------------------------------
1189: --Start of Comments

Line 1236: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

1232: l_key_org_assignments PO_SESSION_GT.key%TYPE;
1233: l_return_status VARCHAR2(1);
1234: l_num_rows_is_gt NUMBER := 0;
1235: BEGIN
1236: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1237:
1238: l_progress := '010';
1239: -- Pick a key for temp table, used for org_assignemnts
1240: SELECT PO_SESSION_GT_S.nextval

Line 1264: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or input PO_HEADER_IDs inserted into GT table='||SQL%rowcount); END IF;

1260: , p_po_header_ids(i) -- PO_HEADER_IDs to be processed
1261: , 'ORG_ASSIGNMENT:Input PO_HEADER_IDs' -- DATA INFO: Internal to PO
1262: );
1263:
1264: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or input PO_HEADER_IDs inserted into GT table='||SQL%rowcount); END IF;
1265:
1266: -- Attribute changes that need rebuild index
1267: -- enabled_flag, purchasing org, purchasing site
1268: INSERT INTO PO_SESSION_GT

Line 1367: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of recs inserted into GT table='||l_num_rows_is_gt); END IF;

1363: AND ARCH.enabled_flag <> POGA.enabled_flag);
1364:
1365: l_num_rows_is_gt := SQL%rowcount;
1366:
1367: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of recs inserted into GT table='||l_num_rows_is_gt); END IF;
1368:
1369: IF (l_num_rows_is_gt > 0) THEN
1370: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() to rebuild index'); END IF;
1371: -- Call iproc api for rebuild index for ReqTemplates

Line 1370: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() to rebuild index'); END IF;

1366:
1367: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number of recs inserted into GT table='||l_num_rows_is_gt); END IF;
1368:
1369: IF (l_num_rows_is_gt > 0) THEN
1370: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() to rebuild index'); END IF;
1371: -- Call iproc api for rebuild index for ReqTemplates
1372: -- Pass in the key for PO_SESSION_GT table
1373: l_progress := '040';
1374:

Line 1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;

1396: -- In case of error, just log in debug logs. There is no need to raise
1397: -- it up, because rebuild_index errors have to be ignored by the calling
1398: -- program.
1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;
1401: END IF;
1402: ELSE
1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;
1404: END IF;

Line 1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;

1399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1400: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts() returned error: '||l_return_status); END IF;
1401: END IF;
1402: ELSE
1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;
1404: END IF;
1405:
1406: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1407: EXCEPTION

Line 1406: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1402: ELSE
1403: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Skipped: iProc API ICX_CAT_POPULATE_BPA_GRP.populateOnlineOrgAssgnmnts()'); END IF;
1404: END IF;
1405:
1406: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1410: END populate_sessiongt_for_orgs;

Line 1409: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1405:
1406: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1410: END populate_sessiongt_for_orgs;
1411:
1412: --------------------------------------------------------------------------------
1413: --Start of Comments

Line 1473: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

1469:
1470: l_key PO_SESSION_GT.key%TYPE;
1471: l_base_lang FND_LANGUAGES.language_code%TYPE;
1472: BEGIN
1473: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1474:
1475: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
1476: l_progress := '010';
1477: -- pick a new key for temp table

Line 1527: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE descriptions selected to synch='||SQL%rowcount); END IF;

1523: AND (POL.item_description <> POLA.item_description OR
1524: (POL.item_description IS NULL AND POLA.item_description IS NOT NULL) OR
1525: (POL.item_description IS NOT NULL AND POLA.item_description IS NULL))));
1526:
1527: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE descriptions selected to synch='||SQL%rowcount); END IF;
1528:
1529: l_progress := '050';
1530: -- For all the lines whose description have changed, update the TLP records as well.
1531: FORALL i IN 1 .. l_po_line_id_list.COUNT

Line 1537: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE descriptions synchd='||SQL%rowcount); END IF;

1533: SET description = l_item_description_list(i)
1534: WHERE POTLP.po_line_id = l_po_line_id_list(i)
1535: AND language = l_created_lang_list(i);
1536:
1537: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE descriptions synchd='||SQL%rowcount); END IF;
1538:
1539: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1540:
1541: l_progress := '060';

Line 1556: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line descriptions selected to synch='||SQL%rowcount); END IF;

1552: FROM PO_REQEXPRESS_LINES_ALL PORTL
1553: WHERE PORTL.express_name = p_reqexpress_name
1554: AND PORTL.org_id = p_org_id;
1555:
1556: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line descriptions selected to synch='||SQL%rowcount); END IF;
1557:
1558: l_progress := '070';
1559: -- Get the base language
1560: SELECT language_code

Line 1565: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Base language is = '||l_base_lang); END IF;

1561: INTO l_base_lang
1562: FROM FND_LANGUAGES
1563: WHERE installed_flag='B';
1564:
1565: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Base language is = '||l_base_lang); END IF;
1566:
1567: l_progress := '080';
1568: -- For all the lines whose description have changed, update the TLP records as well.
1569: FORALL i IN 1 .. l_req_template_line_num_list.COUNT

Line 1577: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line descriptions synchd='||SQL%rowcount); END IF;

1573: AND req_template_line_num = l_req_template_line_num_list(i)
1574: AND org_id = l_req_template_org_id_list(i)
1575: AND language = l_base_lang;
1576:
1577: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line descriptions synchd='||SQL%rowcount); END IF;
1578: END IF;
1579:
1580: l_progress := '090';
1581:

Line 1582: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1578: END IF;
1579:
1580: l_progress := '090';
1581:
1582: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1586: END synch_item_description;

Line 1585: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1581:
1582: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1586: END synch_item_description;
1587:
1588: --------------------------------------------------------------------------------
1589: --Start of Comments

Line 1651: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;

1647: l_req_template_org_id_list PO_TBL_NUMBER;
1648:
1649: l_key PO_SESSION_GT.key%TYPE;
1650: BEGIN
1651: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1652:
1653: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
1654: l_progress := '010';
1655: -- pick a new key for temp table

Line 1696: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE category ids selected to synch='||SQL%rowcount); END IF;

1692: AND POL.po_header_id = POH.po_header_id
1693: AND POL.po_line_id = POATR.po_line_id
1694: AND POL.category_id IS NOT NULL;
1695:
1696: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE category ids selected to synch='||SQL%rowcount); END IF;
1697:
1698: l_progress := '050';
1699: -- Get the ip_category_id for all the po lines selected above and update
1700: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

Line 1716: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE category ids synchd='||SQL%rowcount); END IF;

1712: WHERE po_line_id = l_po_line_id_list(i);
1713: END IF;
1714: END LOOP;
1715:
1716: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE category ids synchd='||SQL%rowcount); END IF;
1717:
1718: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1719:
1720: l_progress := '060';

Line 1739: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line category ids selected to synch='||SQL%rowcount); END IF;

1735: WHERE PORTL.express_name = p_reqexpress_name
1736: AND PORTL.po_line_id = POATR.po_line_id
1737: AND PORTL.org_id = p_org_id;
1738:
1739: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line category ids selected to synch='||SQL%rowcount); END IF;
1740:
1741: l_progress := '070';
1742:
1743: -- Get the ip_category_id for all the po lines selected above and update

Line 1764: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line category ids synchd='||SQL%rowcount); END IF;

1760: AND org_id = l_req_template_org_id_list(i);
1761: END IF;
1762: END LOOP;
1763:
1764: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line category ids synchd='||SQL%rowcount); END IF;
1765: END IF;
1766:
1767: l_progress := '080';
1768:

Line 1769: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

1765: END IF;
1766:
1767: l_progress := '080';
1768:
1769: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1773: END synch_item_category;

Line 1772: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

1768:
1769: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1773: END synch_item_category;
1774:
1775: END PO_CATALOG_INDEX_PVT;