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 159: PO_DEBUG.debug_begin(l_log_head);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

245: populate_sessiongt_for_rt( p_reqexpress_name => p_reqexpress_name
246: , p_org_id => p_org_id);
247: ELSE
248: -- Invalid type
249: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Invalid type:'||p_type); END IF;
250: END IF;
251:
252: l_progress := '020';
253: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;

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

249: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Invalid type:'||p_type); END IF;
250: END IF;
251:
252: l_progress := '020';
253: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
254:
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;

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

253: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
254:
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
258: -- do not raise the exception as rebuild_index errors have to be ignored
259: -- by the calling program.
260: END rebuild_index;
261:

Line 314: PO_DEBUG.debug_begin(l_log_head);

310:
311: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
312: BEGIN
313: IF g_debug_stmt THEN
314: PO_DEBUG.debug_begin(l_log_head);
315: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
316: END IF;
317:
318: l_progress := '010';

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

311: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
312: BEGIN
313: IF g_debug_stmt THEN
314: PO_DEBUG.debug_begin(l_log_head);
315: PO_DEBUG.debug_var(l_log_head,l_progress,'p_po_header_id',p_po_header_id);
316: END IF;
317:
318: l_progress := '010';
319: -- pick a new key for temp table

Line 344: 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;

340:
341: l_num_rows_is_gt := SQL%rowcount;
342:
343: l_progress := '030';
344: 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;
345:
346: IF (l_num_rows_is_gt > 0) THEN
347: IF g_debug_stmt THEN
348: PO_LOG.stmt_session_gt

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

357: INTO l_segment1
358: FROM PO_HEADERS_ALL
359: WHERE po_header_id = p_po_header_id;
360:
361: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
362: END IF;
363:
364: 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;
365: -- Call iproc api for rebuild index for Quotations

Line 364: 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;

360:
361: PO_DEBUG.debug_stmt(l_log_head,l_progress,'SEGMENT1 = '||l_segment1||', for PO_HEADER_ID = '||p_po_header_id);
362: END IF;
363:
364: 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;
365: -- Call iproc api for rebuild index for Quotations
366: -- Pass in the key for PO_SESSION_GT table
367: l_progress := '040';
368:

Line 384: 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;

380: -- In case of error, just log in debug logs. There is no need to raise
381: -- it up, because rebuild_index errors have to be ignored by the calling
382: -- program.
383: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
384: 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;
385: END IF;
386: ELSE
387: 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;
388: END IF;

Line 387: 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;

383: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
384: 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;
385: END IF;
386: ELSE
387: 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;
388: END IF;
389:
390: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
391: EXCEPTION

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

386: ELSE
387: 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;
388: END IF;
389:
390: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
391: EXCEPTION
392: WHEN OTHERS THEN
393: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
394: END populate_sessiongt_for_quote;

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

389:
390: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
391: EXCEPTION
392: WHEN OTHERS THEN
393: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
394: END populate_sessiongt_for_quote;
395:
396: --------------------------------------------------------------------------------
397: --Start of Comments

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

438: l_key PO_SESSION_GT.key%TYPE;
439: l_return_status VARCHAR2(1);
440: l_num_rows_is_gt NUMBER := 0;
441: BEGIN
442: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
443:
444: l_progress := '010';
445: -- pick a new key for temp table
446: SELECT PO_SESSION_GT_S.nextval

Line 473: 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;

469:
470: l_num_rows_is_gt := SQL%rowcount;
471:
472: l_progress := '030';
473: 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;
474:
475: IF (l_num_rows_is_gt > 0) THEN
476: IF g_debug_stmt THEN
477: PO_LOG.stmt_session_gt

Line 486: 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;

482: , p_column_name_tbl => NULL -- IN PO_TBL_VARCHAR30 DEFAULT NULL (For all columns)
483: );
484: END IF;
485:
486: 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;
487: -- Call iproc api for rebuild index for ReqTemplates
488: -- Pass in the key for PO_SESSION_GT table
489: l_progress := '040';
490:

Line 506: 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;

502: -- In case of error, just log in debug logs. There is no need to raise
503: -- it up, because rebuild_index errors have to be ignored by the calling
504: -- program.
505: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
506: 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;
507: END IF;
508: ELSE
509: 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;
510: END IF;

Line 509: 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;

505: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
506: 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;
507: END IF;
508: ELSE
509: 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;
510: END IF;
511:
512: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
513: EXCEPTION

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

508: ELSE
509: 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;
510: END IF;
511:
512: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
513: EXCEPTION
514: WHEN OTHERS THEN
515: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
516: END populate_sessiongt_for_rt;

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

511:
512: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
513: EXCEPTION
514: WHEN OTHERS THEN
515: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
516: END populate_sessiongt_for_rt;
517:
518: --------------------------------------------------------------------------------
519: --Start of Comments

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

567: l_return_status VARCHAR2(1);
568: l_num_rows_is_gt NUMBER := 0;
569:
570: BEGIN
571: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
572:
573: l_progress := '010';
574: -- pick a new key for temp table, to store records to be passed to iProc
575: SELECT PO_SESSION_GT_S.nextval

Line 603: 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;

599: , p_po_header_ids(i) -- List of Input PO_HEADER_ID's
600: , 'Remaining PO_HEADER_IDs' -- DATA INFO: Internal to PO
601: );
602:
603: 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;
604:
605: -- Insert lines for headers that have been modified
606: -- The fields that need rebuild index are:
607: -- SUPPLIER, SUPPLIER_SITE

Line 681: 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;

677: INTO l_num_rows_is_gt
678: FROM PO_SESSION_GT
679: WHERE key = l_key;
680:
681: 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;
682:
683: IF (l_num_rows_is_gt > 0) THEN
684: 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;
685: -- Call iproc api for rebuild index for ReqTemplates

Line 684: 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;

680:
681: 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;
682:
683: IF (l_num_rows_is_gt > 0) THEN
684: 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;
685: -- Call iproc api for rebuild index for ReqTemplates
686: -- Pass in the key for PO_SESSION_GT table
687: l_progress := '040';
688:

Line 714: 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;

710: -- In case of error, just log in debug logs. There is no need to raise
711: -- it up, because rebuild_index errors have to be ignored by the calling
712: -- program.
713: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
714: 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;
715: END IF;
716: ELSE
717: 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;
718: END IF;

Line 717: 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;

713: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
714: 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;
715: END IF;
716: ELSE
717: 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;
718: END IF;
719:
720: -- Finally, see if Org Assignments have changed, and call a separate
721: -- iProc API, to pass in Org Assignment information

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

723: (
724: p_po_header_ids => p_po_header_ids
725: );
726:
727: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
728: EXCEPTION
729: WHEN OTHERS THEN
730: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
731: END populate_sessiongt_for_pa;

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

726:
727: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
728: EXCEPTION
729: WHEN OTHERS THEN
730: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
731: END populate_sessiongt_for_pa;
732:
733: --------------------------------------------------------------------------------
734: --Start of Comments

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

772: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
773: l_progress VARCHAR2(3) := '000';
774:
775: BEGIN
776: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
777:
778: l_progress := '010';
779:
780: -- Insert lines for headers that have been modified

Line 832: 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;

828: POH.vendor_contact_id <> POHA.vendor_contact_id OR
829: (POH.vendor_contact_id IS NULL AND POHA. vendor_contact_id IS NOT NULL) OR
830: (POH.vendor_contact_id IS NOT NULL AND POHA.vendor_contact_id IS NULL))));
831:
832: 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;
833:
834: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
835: EXCEPTION
836: WHEN OTHERS THEN

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

830: (POH.vendor_contact_id IS NOT NULL AND POHA.vendor_contact_id IS NULL))));
831:
832: 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;
833:
834: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
835: EXCEPTION
836: WHEN OTHERS THEN
837: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
838: END insert_header_changes;

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

833:
834: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
835: EXCEPTION
836: WHEN OTHERS THEN
837: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
838: END insert_header_changes;
839:
840: --------------------------------------------------------------------------------
841: --Start of Comments

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

880: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
881: l_progress VARCHAR2(3) := '000';
882:
883: BEGIN
884: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
885:
886: l_progress := '010';
887: -- Now we have only those documents that did not have header changes
888: -- For these documents check if there were any line changes

Line 943: 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;

939: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID
940: ) --Bug 13343886
941: );
942:
943: 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:
945: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
946: EXCEPTION
947: WHEN OTHERS THEN

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

941: );
942:
943: 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:
945: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
946: EXCEPTION
947: WHEN OTHERS THEN
948: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
949: END insert_line_changes;

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

944:
945: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
946: EXCEPTION
947: WHEN OTHERS THEN
948: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
949: END insert_line_changes;
950:
951: --------------------------------------------------------------------------------
952: --Start of Comments

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

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

Line 1049: 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;

1045: ) --Bug 13343886
1046: );
1047:
1048:
1049: 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;
1050:
1051: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1052: EXCEPTION
1053: WHEN OTHERS THEN

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

1047:
1048:
1049: 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;
1050:
1051: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1055: END insert_attr_changes;

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

1050:
1051: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1055: END insert_attr_changes;
1056:
1057: --------------------------------------------------------------------------------
1058: --Start of Comments

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

1093: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1094: l_progress VARCHAR2(3) := '000';
1095:
1096: BEGIN
1097: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1098:
1099: l_progress := '010';
1100: -- Now we have the documents for which there were no Header/Line/Attr
1101: -- changes, but there could potentialy be some TLP changes

Line 1154: 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;

1150: SELECT '1' FROM ICX_CAT_ITEMS_CTX_HDRS_TLP hdrs WHERE HDRS.PO_LINE_ID = POL.PO_LINE_ID
1151: ) --Bug 13343886
1152: );
1153:
1154: 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;
1155:
1156: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1157: EXCEPTION
1158: WHEN OTHERS THEN

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

1152: );
1153:
1154: 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;
1155:
1156: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1160: END insert_tlp_changes;

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

1155:
1156: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1160: END insert_tlp_changes;
1161:
1162: --------------------------------------------------------------------------------
1163: --Start of Comments

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

1198: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1199: l_progress VARCHAR2(3) := '000';
1200:
1201: BEGIN
1202: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1203:
1204: l_progress := '010';
1205: -- From the input list, delete those that were already marked as having
1206: -- header level changes. The PO_HEADER_ID in the to-be-processed queue

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

1212: FROM PO_SESSION_GT GT1
1213: WHERE GT1.key = p_key
1214: AND GT1.index_num2 = GT_REMAINING_HDRS.index_num1);
1215:
1216: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs deleted='||SQL%rowcount); END IF;
1217:
1218: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1219: EXCEPTION
1220: WHEN OTHERS THEN

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

1214: AND GT1.index_num2 = GT_REMAINING_HDRS.index_num1);
1215:
1216: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_HEADER_IDs deleted='||SQL%rowcount); END IF;
1217:
1218: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1219: EXCEPTION
1220: WHEN OTHERS THEN
1221: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1222: END delete_processed_headers;

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

1217:
1218: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1219: EXCEPTION
1220: WHEN OTHERS THEN
1221: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1222: END delete_processed_headers;
1223:
1224: --------------------------------------------------------------------------------
1225: --Start of Comments

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

1268: l_key_org_assignments PO_SESSION_GT.key%TYPE;
1269: l_return_status VARCHAR2(1);
1270: l_num_rows_is_gt NUMBER := 0;
1271: BEGIN
1272: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1273:
1274: l_progress := '010';
1275: -- Pick a key for temp table, used for org_assignemnts
1276: SELECT PO_SESSION_GT_S.nextval

Line 1300: 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;

1296: , p_po_header_ids(i) -- PO_HEADER_IDs to be processed
1297: , 'ORG_ASSIGNMENT:Input PO_HEADER_IDs' -- DATA INFO: Internal to PO
1298: );
1299:
1300: 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;
1301:
1302: -- Attribute changes that need rebuild index
1303: -- enabled_flag, purchasing org, purchasing site
1304: INSERT INTO PO_SESSION_GT

Line 1403: 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;

1399: AND ARCH.enabled_flag <> POGA.enabled_flag);
1400:
1401: l_num_rows_is_gt := SQL%rowcount;
1402:
1403: 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;
1404:
1405: IF (l_num_rows_is_gt > 0) THEN
1406: 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;
1407: -- Call iproc api for rebuild index for ReqTemplates

Line 1406: 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;

1402:
1403: 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;
1404:
1405: IF (l_num_rows_is_gt > 0) THEN
1406: 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;
1407: -- Call iproc api for rebuild index for ReqTemplates
1408: -- Pass in the key for PO_SESSION_GT table
1409: l_progress := '040';
1410:

Line 1436: 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;

1432: -- In case of error, just log in debug logs. There is no need to raise
1433: -- it up, because rebuild_index errors have to be ignored by the calling
1434: -- program.
1435: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1436: 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;
1437: END IF;
1438: ELSE
1439: 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;
1440: END IF;

Line 1439: 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;

1435: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1436: 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;
1437: END IF;
1438: ELSE
1439: 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;
1440: END IF;
1441:
1442: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1443: EXCEPTION

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

1438: ELSE
1439: 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;
1440: END IF;
1441:
1442: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1446: END populate_sessiongt_for_orgs;

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

1441:
1442: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1443: EXCEPTION
1444: WHEN OTHERS THEN
1445: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1446: END populate_sessiongt_for_orgs;
1447:
1448: --
1449: -- Commented out procedures - synch_item_description and synch_item_category

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

1507:
1508: l_key PO_SESSION_GT.key%TYPE;
1509: l_base_lang FND_LANGUAGES.language_code%TYPE;
1510: BEGIN
1511: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1512:
1513: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
1514: l_progress := '010';
1515: -- pick a new key for temp table

Line 1565: 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;

1561: AND (POL.item_description <> POLA.item_description OR
1562: (POL.item_description IS NULL AND POLA.item_description IS NOT NULL) OR
1563: (POL.item_description IS NOT NULL AND POLA.item_description IS NULL))));
1564:
1565: 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;
1566:
1567: l_progress := '050';
1568: -- For all the lines whose description have changed, update the TLP records as well.
1569: FORALL i IN 1 .. l_po_line_id_list.COUNT

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

1571: SET description = l_item_description_list(i)
1572: WHERE POTLP.po_line_id = l_po_line_id_list(i)
1573: AND language = l_created_lang_list(i);
1574:
1575: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or PO_LINE descriptions synchd='||SQL%rowcount); END IF;
1576:
1577: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1578:
1579: l_progress := '060';

Line 1594: 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;

1590: FROM PO_REQEXPRESS_LINES_ALL PORTL
1591: WHERE PORTL.express_name = p_reqexpress_name
1592: AND PORTL.org_id = p_org_id;
1593:
1594: 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;
1595:
1596: l_progress := '070';
1597: -- Get the base language
1598: SELECT language_code

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

1599: INTO l_base_lang
1600: FROM FND_LANGUAGES
1601: WHERE installed_flag='B';
1602:
1603: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Base language is = '||l_base_lang); END IF;
1604:
1605: l_progress := '080';
1606: -- For all the lines whose description have changed, update the TLP records as well.
1607: FORALL i IN 1 .. l_req_template_line_num_list.COUNT

Line 1615: 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;

1611: AND req_template_line_num = l_req_template_line_num_list(i)
1612: AND org_id = l_req_template_org_id_list(i)
1613: AND language = l_base_lang;
1614:
1615: 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;
1616: END IF;
1617:
1618: l_progress := '090';
1619:

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

1616: END IF;
1617:
1618: l_progress := '090';
1619:
1620: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1624: END synch_item_description;

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

1619:
1620: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1624: END synch_item_description;
1625:
1626: --------------------------------------------------------------------------------
1627: --Start of Comments

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

1685: l_req_template_org_id_list PO_TBL_NUMBER;
1686:
1687: l_key PO_SESSION_GT.key%TYPE;
1688: BEGIN
1689: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1690:
1691: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
1692: l_progress := '010';
1693: -- pick a new key for temp table

Line 1734: 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;

1730: AND POL.po_header_id = POH.po_header_id
1731: AND POL.po_line_id = POATR.po_line_id
1732: AND POL.category_id IS NOT NULL;
1733:
1734: 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;
1735:
1736: l_progress := '050';
1737: -- Get the ip_category_id for all the po lines selected above and update
1738: -- PO_ATTRIBUTE_VALUES and PO_ATTRIBUTE_VALUES_TLP

Line 1754: 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;

1750: WHERE po_line_id = l_po_line_id_list(i);
1751: END IF;
1752: END LOOP;
1753:
1754: 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;
1755:
1756: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1757:
1758: l_progress := '060';

Line 1777: 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;

1773: WHERE PORTL.express_name = p_reqexpress_name
1774: AND PORTL.po_line_id = POATR.po_line_id
1775: AND PORTL.org_id = p_org_id;
1776:
1777: 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;
1778:
1779: l_progress := '070';
1780:
1781: -- Get the ip_category_id for all the po lines selected above and update

Line 1802: 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;

1798: AND org_id = l_req_template_org_id_list(i);
1799: END IF;
1800: END LOOP;
1801:
1802: 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;
1803: END IF;
1804:
1805: l_progress := '080';
1806:

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

1803: END IF;
1804:
1805: l_progress := '080';
1806:
1807: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1811: END synch_item_category;*/

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

1806:
1807: IF g_debug_stmt THEN PO_DEBUG.debug_end(l_log_head); END IF;
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: IF g_debug_unexp THEN PO_DEBUG.debug_exc(l_log_head,l_progress); END IF;
1811: END synch_item_category;*/
1812:
1813: END PO_CATALOG_INDEX_PVT;