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_ASL_API_PUB dependencies on PO_ASL_API_PVT

Line 141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');

137: unexp_err_psit EXCEPTION;
138:
139: BEGIN
140: x_return_msg := NULL;
141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');
142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);

Line 142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);

138:
139: BEGIN
140: x_return_msg := NULL;
141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');
142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);

Line 143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);

139: BEGIN
140: x_return_msg := NULL;
141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');
142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);

Line 144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);

140: x_return_msg := NULL;
141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');
142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);

Line 145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);

141: po_asl_api_pvt.Log('START ::: PROCEDURE create_update_asl ');
142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);

Line 146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);

142: --po_asl_api_pvt.Log('p_asl_rec count:' || p_asl_rec.user_key.Count);
143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);

Line 147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);

143: --po_asl_api_pvt.Log('p_asl_attr_rec count:' || p_asl_attr_rec.user_key.Count);
144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);

Line 148: po_asl_api_pvt.Log(p_asl_rec);

144: --po_asl_api_pvt.Log('p_asl_doc_rec count:' || p_asl_doc_rec.user_key.Count);
145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);

Line 149: po_asl_api_pvt.Log(p_asl_attr_rec);

145: --po_asl_api_pvt.Log('p_chv_auth_rec count:' || p_chv_auth_rec.user_key.Count);
146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);

Line 150: po_asl_api_pvt.Log(p_asl_doc_rec);

146: --po_asl_api_pvt.Log('p_capacity_rec count:' || p_capacity_rec.user_key.Count);
147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);

Line 151: po_asl_api_pvt.Log(p_chv_auth_rec);

147: --po_asl_api_pvt.Log('p_tolerance_rec count:'|| p_tolerance_rec.user_key.Count);
148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables

Line 152: po_asl_api_pvt.Log(p_capacity_rec);

148: po_asl_api_pvt.Log(p_asl_rec);
149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables
156: DELETE FROM po_approved_supplier_list_gt;

Line 153: po_asl_api_pvt.Log(p_tolerance_rec);

149: po_asl_api_pvt.Log(p_asl_attr_rec);
150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables
156: DELETE FROM po_approved_supplier_list_gt;
157: DELETE FROM po_asl_documents_gt ;

Line 154: po_asl_api_pvt.Log('p_commit:' || p_commit);

150: po_asl_api_pvt.Log(p_asl_doc_rec);
151: po_asl_api_pvt.Log(p_chv_auth_rec);
152: po_asl_api_pvt.Log(p_capacity_rec);
153: po_asl_api_pvt.Log(p_tolerance_rec);
154: po_asl_api_pvt.Log('p_commit:' || p_commit);
155: --Empty GT tables
156: DELETE FROM po_approved_supplier_list_gt;
157: DELETE FROM po_asl_documents_gt ;
158: DELETE FROM chv_authorizations_gt;

Line 165: po_asl_api_pvt.Log('session key:' || x_session_key);

161: DELETE FROM po_supplier_item_tolerance_gt;
162:
163: --generate the session key.
164: SELECT po_session_gt_s.NEXTVAL INTO x_session_key FROM dual;
165: po_asl_api_pvt.Log('session key:' || x_session_key);
166:
167: g_session_key := x_session_key;
168:
169: l_progress := 10;

Line 339: po_asl_api_pvt.log('x_return_status is null');

335: --commit the transaction if p_commit value is 'Y' and there is no error in
336: --subsequent processes.
337: IF x_return_status IS NULL
338: THEN
339: po_asl_api_pvt.log('x_return_status is null');
340: END IF;
341: IF (p_commit = 'Y' AND
342: Nvl(x_return_status,' ') NOT IN (FND_API.G_RET_STS_ERROR,
343: FND_API.G_RET_STS_UNEXP_ERROR)

Line 347: po_asl_api_pvt.log('Transaction committed');

343: FND_API.G_RET_STS_UNEXP_ERROR)
344: )
345: THEN
346: COMMIT;
347: po_asl_api_pvt.log('Transaction committed');
348: END IF;
349:
350: l_progress := 100;
351:

Line 356: po_asl_api_pvt.log('END ::: PROCEDURE create_update_asl ');

352: IF x_return_status IS NULL
353: THEN
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355: END IF;
356: po_asl_api_pvt.log('END ::: PROCEDURE create_update_asl ');
357:
358: EXCEPTION
359: WHEN duplicate_keys THEN
360: po_asl_api_pvt.log('create_update_asl : Existing the process

Line 360: po_asl_api_pvt.log('create_update_asl : Existing the process

356: po_asl_api_pvt.log('END ::: PROCEDURE create_update_asl ');
357:
358: EXCEPTION
359: WHEN duplicate_keys THEN
360: po_asl_api_pvt.log('create_update_asl : Existing the process
361: due to duplicate user_keys');
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: x_return_msg := 'Existing the process due to duplicate user_keys';
364:

Line 366: po_asl_api_pvt.log('create_update_asl : Parent user_key not found');

362: x_return_status := FND_API.G_RET_STS_ERROR;
363: x_return_msg := 'Existing the process due to duplicate user_keys';
364:
365: WHEN parent_key_not_found THEN
366: po_asl_api_pvt.log('create_update_asl : Parent user_key not found');
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: x_return_msg := 'Parent user_key not found';
369:
370: WHEN unexp_err_pasl THEN

Line 371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');

367: x_return_status := FND_API.G_RET_STS_ERROR;
368: x_return_msg := 'Parent user_key not found';
369:
370: WHEN unexp_err_pasl THEN
371: po_asl_api_pvt.log('Unexpected while dumping to po_approved_supplier_list_gt');
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN

Line 376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN

Line 381: po_asl_api_pvt.log('Unexpected while dumping to po_asl_documents_gt');

377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN
381: po_asl_api_pvt.log('Unexpected while dumping to po_asl_documents_gt');
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: x_return_msg := 'Unexpected while dumping to po_asl_documents_gt';
384:
385: WHEN unexp_err_chv THEN

Line 386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_gt');

382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: x_return_msg := 'Unexpected while dumping to po_asl_documents_gt';
384:
385: WHEN unexp_err_chv THEN
386: po_asl_api_pvt.log('Unexpected while dumping to chv_authorizations_gt');
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';
389:
390: WHEN unexp_err_psic THEN

Line 391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');

387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: x_return_msg := 'Unexpected while dumping to chv_authorizations_gt';
389:
390: WHEN unexp_err_psic THEN
391: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_capacity_gt');
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN

Line 396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_gt');

392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: x_return_msg := 'Unexpected while dumping to po_supplier_item_capacity_gt';
394:
395: WHEN unexp_err_psit THEN
396: po_asl_api_pvt.log('Unexpected while dumping to po_supplier_item_tolerance_gt');
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_gt';
399:
400: WHEN OTHERS THEN

Line 401: po_asl_api_pvt.log('create_update_asl : when others exception at '

397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: x_return_msg := 'Unexpected while dumping to po_supplier_item_tolerance_gt';
399:
400: WHEN OTHERS THEN
401: po_asl_api_pvt.log('create_update_asl : when others exception at '
402: || l_progress || ';' || SQLERRM );
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_return_msg := SQLERRM;
405:

Line 435: po_asl_api_pvt.log('START ::: po_asl_api_pub.process');

431: IS
432: l_progress NUMBER := 0;
433:
434: BEGIN
435: po_asl_api_pvt.log('START ::: po_asl_api_pub.process');
436: x_return_msg := NULL;
437:
438: --derive the id fields based on the display values provided
439: --updating po_approved_supplier_list_gt to derive id fields

Line 513: po_asl_api_pvt.log('END ::: po_asl_api_pub.process ');

509: x_return_msg => x_return_msg
510: );
511:
512: l_progress := 100;
513: po_asl_api_pvt.log('END ::: po_asl_api_pub.process ');
514:
515: EXCEPTION
516:
517: WHEN OTHERS THEN

Line 519: po_asl_api_pvt.log('po_asl_api_pub.process : when others exception at '

515: EXCEPTION
516:
517: WHEN OTHERS THEN
518:
519: po_asl_api_pvt.log('po_asl_api_pub.process : when others exception at '
520: || l_progress || ';' || SQLERRM );
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: x_return_msg := SQLERRM;
523: END process;

Line 554: po_asl_api_pvt.log('START ::: dump_to_asl_gtt');

550: )
551: IS
552: counter NUMBER;
553: BEGIN
554: po_asl_api_pvt.log('START ::: dump_to_asl_gtt');
555: po_asl_api_pvt.log(p_asl_rec);
556: x_return_msg := NULL;
557:
558: FORALL l_index IN 1 .. p_asl_rec.user_key.Count

Line 555: po_asl_api_pvt.log(p_asl_rec);

551: IS
552: counter NUMBER;
553: BEGIN
554: po_asl_api_pvt.log('START ::: dump_to_asl_gtt');
555: po_asl_api_pvt.log(p_asl_rec);
556: x_return_msg := NULL;
557:
558: FORALL l_index IN 1 .. p_asl_rec.user_key.Count
559: INSERT INTO po_approved_supplier_list_gt (

Line 613: PO_ASL_API_PVT.g_STATUS_PENDING ,

609: VALUES (
610: g_session_key ,
611: p_asl_rec.user_key(l_index) ,
612: p_asl_rec.process_action(l_index) ,
613: PO_ASL_API_PVT.g_STATUS_PENDING ,
614: NULL ,
615: Decode(p_asl_rec.global_flag(l_index), 'Y', -1) ,
616: NULL ,
617: p_asl_rec.owning_organization_id(l_index) ,

Line 660: po_asl_api_pvt.log('dump_to_asl_gtt : rowcount :' || SQL%ROWCOUNT);

656: p_asl_rec.program_update_date(l_index) ,
657: p_asl_rec.disable_flag(l_index)
658: );
659:
660: po_asl_api_pvt.log('dump_to_asl_gtt : rowcount :' || SQL%ROWCOUNT);
661: --To check if there are any duplicate user_keys in gt table
662: --If there are duplicates the following query returns the couner.
663: --Ideal case is, the query should throw No Data Found exception.
664: --Otherwise, it is expected error.

Line 679: po_asl_api_pvt.log('END ::: dump_to_asl_gtt');

675: ELSE
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677: END IF;
678:
679: po_asl_api_pvt.log('END ::: dump_to_asl_gtt');
680: EXCEPTION
681: WHEN OTHERS THEN
682:
683: po_asl_api_pvt.log('dump_to_asl_gtt : when others exception ' || SQLERRM );

Line 683: po_asl_api_pvt.log('dump_to_asl_gtt : when others exception ' || SQLERRM );

679: po_asl_api_pvt.log('END ::: dump_to_asl_gtt');
680: EXCEPTION
681: WHEN OTHERS THEN
682:
683: po_asl_api_pvt.log('dump_to_asl_gtt : when others exception ' || SQLERRM );
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: x_return_msg := SQLERRM;
686:
687: END dump_to_asl_gtt;

Line 717: po_asl_api_pvt.log('START ::: dump_to_asl_attr_gtt');

713: )
714: IS
715:
716: BEGIN
717: po_asl_api_pvt.log('START ::: dump_to_asl_attr_gtt');
718: po_asl_api_pvt.log(p_asl_attr_rec);
719: x_return_msg := NULL;
720:
721: FORALL l_index IN 1 .. p_asl_attr_rec.user_key.Count

Line 718: po_asl_api_pvt.log(p_asl_attr_rec);

714: IS
715:
716: BEGIN
717: po_asl_api_pvt.log('START ::: dump_to_asl_attr_gtt');
718: po_asl_api_pvt.log(p_asl_attr_rec);
719: x_return_msg := NULL;
720:
721: FORALL l_index IN 1 .. p_asl_attr_rec.user_key.Count
722: INSERT INTO po_asl_attributes_gt (

Line 877: po_asl_api_pvt.log('dump_to_asl_attr_gtt : rowcount :' || SQL%ROWCOUNT);

873: p_asl_attr_rec.fixed_order_quantity_dsp(l_index) ,
874: p_asl_attr_rec.forecast_horizon_dsp(l_index)
875: );
876:
877: po_asl_api_pvt.log('dump_to_asl_attr_gtt : rowcount :' || SQL%ROWCOUNT);
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: po_asl_api_pvt.log('END ::: dump_to_asl_attr_gtt');
881: EXCEPTION

Line 880: po_asl_api_pvt.log('END ::: dump_to_asl_attr_gtt');

876:
877: po_asl_api_pvt.log('dump_to_asl_attr_gtt : rowcount :' || SQL%ROWCOUNT);
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: po_asl_api_pvt.log('END ::: dump_to_asl_attr_gtt');
881: EXCEPTION
882:
883: WHEN OTHERS THEN
884:

Line 885: po_asl_api_pvt.log('dump_to_asl_attr_gtt-when others exception ' || SQLERRM);

881: EXCEPTION
882:
883: WHEN OTHERS THEN
884:
885: po_asl_api_pvt.log('dump_to_asl_attr_gtt-when others exception ' || SQLERRM);
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: x_return_msg := SQLERRM;
888:
889: END dump_to_asl_attr_gtt;

Line 919: po_asl_api_pvt.log('START ::: dump_to_asl_doc_gtt');

915: )
916: IS
917:
918: BEGIN
919: po_asl_api_pvt.log('START ::: dump_to_asl_doc_gtt');
920: po_asl_api_pvt.log(p_asl_doc_rec);
921: x_return_msg := NULL;
922:
923: FORALL l_index IN 1 .. p_asl_doc_rec.user_key.Count

Line 920: po_asl_api_pvt.log(p_asl_doc_rec);

916: IS
917:
918: BEGIN
919: po_asl_api_pvt.log('START ::: dump_to_asl_doc_gtt');
920: po_asl_api_pvt.log(p_asl_doc_rec);
921: x_return_msg := NULL;
922:
923: FORALL l_index IN 1 .. p_asl_doc_rec.user_key.Count
924: INSERT INTO po_asl_documents_gt (

Line 997: po_asl_api_pvt.log('dump_to_asl_doc_gtt : rowcount :' || SQL%ROWCOUNT);

993: p_asl_doc_rec.program_update_date(l_index) ,
994: p_asl_doc_rec.org_id(l_index)
995: );
996:
997: po_asl_api_pvt.log('dump_to_asl_doc_gtt : rowcount :' || SQL%ROWCOUNT);
998: x_return_status := FND_API.G_RET_STS_SUCCESS;
999:
1000: po_asl_api_pvt.log('END ::: dump_to_asl_doc_gtt');
1001: EXCEPTION

Line 1000: po_asl_api_pvt.log('END ::: dump_to_asl_doc_gtt');

996:
997: po_asl_api_pvt.log('dump_to_asl_doc_gtt : rowcount :' || SQL%ROWCOUNT);
998: x_return_status := FND_API.G_RET_STS_SUCCESS;
999:
1000: po_asl_api_pvt.log('END ::: dump_to_asl_doc_gtt');
1001: EXCEPTION
1002:
1003: WHEN OTHERS THEN
1004:

Line 1005: po_asl_api_pvt.log('dump_to_asl_doc_gtt: when others exception ' || SQLERRM);

1001: EXCEPTION
1002:
1003: WHEN OTHERS THEN
1004:
1005: po_asl_api_pvt.log('dump_to_asl_doc_gtt: when others exception ' || SQLERRM);
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: x_return_msg := SQLERRM;
1008:
1009: END dump_to_asl_doc_gtt;

Line 1039: po_asl_api_pvt.log('START ::: dump_to_chv_auth_gtt');

1035: )
1036: IS
1037:
1038: BEGIN
1039: po_asl_api_pvt.log('START ::: dump_to_chv_auth_gtt');
1040: po_asl_api_pvt.log(p_chv_auth_rec);
1041: x_return_msg := NULL;
1042:
1043: FORALL l_index IN 1 .. p_chv_auth_rec.user_key.Count

Line 1040: po_asl_api_pvt.log(p_chv_auth_rec);

1036: IS
1037:
1038: BEGIN
1039: po_asl_api_pvt.log('START ::: dump_to_chv_auth_gtt');
1040: po_asl_api_pvt.log(p_chv_auth_rec);
1041: x_return_msg := NULL;
1042:
1043: FORALL l_index IN 1 .. p_chv_auth_rec.user_key.Count
1044: INSERT INTO chv_authorizations_gt (

Line 1111: po_asl_api_pvt.log('dump_to_chv_auth_gtt : rowcount :' || SQL%ROWCOUNT);

1107: p_chv_auth_rec.using_organization_id(l_index) ,
1108: p_chv_auth_rec.using_organization_dsp(l_index)
1109: );
1110:
1111: po_asl_api_pvt.log('dump_to_chv_auth_gtt : rowcount :' || SQL%ROWCOUNT);
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: po_asl_api_pvt.log('END ::: dump_to_chv_auth_gtt');
1115: EXCEPTION

Line 1114: po_asl_api_pvt.log('END ::: dump_to_chv_auth_gtt');

1110:
1111: po_asl_api_pvt.log('dump_to_chv_auth_gtt : rowcount :' || SQL%ROWCOUNT);
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113:
1114: po_asl_api_pvt.log('END ::: dump_to_chv_auth_gtt');
1115: EXCEPTION
1116:
1117: WHEN OTHERS THEN
1118:

Line 1119: po_asl_api_pvt.log('dump_to_chv_auth_gtt-when others exception ' || SQLERRM);

1115: EXCEPTION
1116:
1117: WHEN OTHERS THEN
1118:
1119: po_asl_api_pvt.log('dump_to_chv_auth_gtt-when others exception ' || SQLERRM);
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: x_return_msg := SQLERRM;
1122:
1123: END dump_to_chv_auth_gtt;

Line 1154: po_asl_api_pvt.log('START ::: dump_to_capacity_gtt');

1150: )
1151: IS
1152:
1153: BEGIN
1154: po_asl_api_pvt.log('START ::: dump_to_capacity_gtt');
1155: po_asl_api_pvt.log(p_capacity_rec);
1156: x_return_msg := NULL;
1157:
1158: FORALL l_index IN 1 .. p_capacity_rec.user_key.Count

Line 1155: po_asl_api_pvt.log(p_capacity_rec);

1151: IS
1152:
1153: BEGIN
1154: po_asl_api_pvt.log('START ::: dump_to_capacity_gtt');
1155: po_asl_api_pvt.log(p_capacity_rec);
1156: x_return_msg := NULL;
1157:
1158: FORALL l_index IN 1 .. p_capacity_rec.user_key.Count
1159: INSERT INTO po_supplier_item_capacity_gt (

Line 1226: po_asl_api_pvt.log('dump_to_capacity_gtt : rowcount :' || SQL%ROWCOUNT);

1222: p_capacity_rec.program_id(l_index) ,
1223: p_capacity_rec.program_update_date(l_index)
1224: );
1225:
1226: po_asl_api_pvt.log('dump_to_capacity_gtt : rowcount :' || SQL%ROWCOUNT);
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: po_asl_api_pvt.log('END ::: dump_to_capacity_gtt');
1230: EXCEPTION

Line 1229: po_asl_api_pvt.log('END ::: dump_to_capacity_gtt');

1225:
1226: po_asl_api_pvt.log('dump_to_capacity_gtt : rowcount :' || SQL%ROWCOUNT);
1227: x_return_status := FND_API.G_RET_STS_SUCCESS;
1228:
1229: po_asl_api_pvt.log('END ::: dump_to_capacity_gtt');
1230: EXCEPTION
1231:
1232: WHEN OTHERS THEN
1233:

Line 1234: po_asl_api_pvt.log('dump_to_capacity_gtt-when others exception ' || SQLERRM);

1230: EXCEPTION
1231:
1232: WHEN OTHERS THEN
1233:
1234: po_asl_api_pvt.log('dump_to_capacity_gtt-when others exception ' || SQLERRM);
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: x_return_msg := SQLERRM;
1237:
1238: END dump_to_capacity_gtt;

Line 1269: po_asl_api_pvt.log('START ::: dump_to_tolerance_gtt');

1265: )
1266: IS
1267:
1268: BEGIN
1269: po_asl_api_pvt.log('START ::: dump_to_tolerance_gtt');
1270: po_asl_api_pvt.log(p_tolerance_rec);
1271: x_return_msg := NULL;
1272:
1273: FORALL l_index IN 1 .. p_tolerance_rec.user_key.Count

Line 1270: po_asl_api_pvt.log(p_tolerance_rec);

1266: IS
1267:
1268: BEGIN
1269: po_asl_api_pvt.log('START ::: dump_to_tolerance_gtt');
1270: po_asl_api_pvt.log(p_tolerance_rec);
1271: x_return_msg := NULL;
1272:
1273: FORALL l_index IN 1 .. p_tolerance_rec.user_key.Count
1274: INSERT INTO po_supplier_item_tolerance_gt (

Line 1335: po_asl_api_pvt.log('dump_to_tolerance_gtt : rowcount :' || SQL%ROWCOUNT);

1331: p_tolerance_rec.program_id(l_index) ,
1332: p_tolerance_rec.program_update_date(l_index)
1333: );
1334:
1335: po_asl_api_pvt.log('dump_to_tolerance_gtt : rowcount :' || SQL%ROWCOUNT);
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: po_asl_api_pvt.log('END ::: dump_to_tolerance_gtt');
1339: EXCEPTION

Line 1338: po_asl_api_pvt.log('END ::: dump_to_tolerance_gtt');

1334:
1335: po_asl_api_pvt.log('dump_to_tolerance_gtt : rowcount :' || SQL%ROWCOUNT);
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: po_asl_api_pvt.log('END ::: dump_to_tolerance_gtt');
1339: EXCEPTION
1340:
1341: WHEN OTHERS THEN
1342:

Line 1343: po_asl_api_pvt.log('dump_to_tolerance_gtt-when others exception ' || SQLERRM);

1339: EXCEPTION
1340:
1341: WHEN OTHERS THEN
1342:
1343: po_asl_api_pvt.log('dump_to_tolerance_gtt-when others exception ' || SQLERRM);
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: x_return_msg := SQLERRM;
1346:
1347: END dump_to_tolerance_gtt;

Line 1375: po_asl_api_pvt.log('START ::: derive_ids_past');

1371: IS
1372: l_progress NUMBER := 0;
1373:
1374: BEGIN
1375: po_asl_api_pvt.log('START ::: derive_ids_past');
1376:
1377: UPDATE po_approved_supplier_list_gt past
1378: SET past.owning_organization_id =
1379: (SELECT hout.organization_id

Line 1479: po_asl_api_pvt.log('derive_ids_past: po_approved_supplier_list_gt rowcount:'

1475: )
1476: WHERE asl1.manufacturer_asl_dsp IS NOT NULL;
1477: l_progress := 100;
1478:
1479: po_asl_api_pvt.log('derive_ids_past: po_approved_supplier_list_gt rowcount:'
1480: || SQL%ROWCOUNT);
1481: po_asl_api_pvt.log('END ::: derive_ids_past');
1482: EXCEPTION
1483:

Line 1481: po_asl_api_pvt.log('END ::: derive_ids_past');

1477: l_progress := 100;
1478:
1479: po_asl_api_pvt.log('derive_ids_past: po_approved_supplier_list_gt rowcount:'
1480: || SQL%ROWCOUNT);
1481: po_asl_api_pvt.log('END ::: derive_ids_past');
1482: EXCEPTION
1483:
1484: WHEN OTHERS THEN
1485:

Line 1486: po_asl_api_pvt.log('derive_ids_past when others exception '

1482: EXCEPTION
1483:
1484: WHEN OTHERS THEN
1485:
1486: po_asl_api_pvt.log('derive_ids_past when others exception '
1487: || l_progress || ';' || SQLERRM);
1488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489: x_return_msg := SQLERRM;
1490:

Line 1518: po_asl_api_pvt.log('START ::: derive_ids_podoc');

1514: )
1515: IS
1516: l_progress NUMBER := 0;
1517: BEGIN
1518: po_asl_api_pvt.log('START ::: derive_ids_podoc');
1519:
1520: UPDATE po_asl_documents_gt padt
1521: SET padt.using_organization_id =
1522: (SELECT hout.organization_id

Line 1557: po_asl_api_pvt.log('derive_ids_podoc UPDATE po_asl_documents_gt rowcount:'

1553: p_using_org_id => padt.using_organization_id ,
1554: p_line_num => padt.document_line_num_dsp)
1555: WHERE document_line_num_dsp IS NOT NULL;
1556: l_progress := 100;
1557: po_asl_api_pvt.log('derive_ids_podoc UPDATE po_asl_documents_gt rowcount:'
1558: || SQL%ROWCOUNT);
1559: po_asl_api_pvt.log('END ::: derive_ids_podoc');
1560: EXCEPTION
1561:

Line 1559: po_asl_api_pvt.log('END ::: derive_ids_podoc');

1555: WHERE document_line_num_dsp IS NOT NULL;
1556: l_progress := 100;
1557: po_asl_api_pvt.log('derive_ids_podoc UPDATE po_asl_documents_gt rowcount:'
1558: || SQL%ROWCOUNT);
1559: po_asl_api_pvt.log('END ::: derive_ids_podoc');
1560: EXCEPTION
1561:
1562: WHEN OTHERS THEN
1563:

Line 1564: po_asl_api_pvt.log('derive_ids_podoc when others exception '

1560: EXCEPTION
1561:
1562: WHEN OTHERS THEN
1563:
1564: po_asl_api_pvt.log('derive_ids_podoc when others exception '
1565: || l_progress || ';' || SQLERRM);
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: x_return_msg := SQLERRM;
1568:

Line 1597: po_asl_api_pvt.log('START ::: derive_ids_ch_auth');

1593: IS
1594: l_progress NUMBER := 0;
1595:
1596: BEGIN
1597: po_asl_api_pvt.log('START ::: derive_ids_ch_auth');
1598:
1599: UPDATE chv_authorizations_gt chv
1600: SET chv.authorization_code =
1601: (SELECT polc.lookup_code

Line 1619: po_asl_api_pvt.log('derive_ids_ch_auth update chv_authorizations_gt rowcount:'

1615: AND ROWNUM < 2)
1616: WHERE chv.using_organization_dsp IS NOT NULL;
1617: l_progress := 100;
1618:
1619: po_asl_api_pvt.log('derive_ids_ch_auth update chv_authorizations_gt rowcount:'
1620: || SQL%ROWCOUNT);
1621: po_asl_api_pvt.log('END ::: derive_ids_ch_auth');
1622: EXCEPTION
1623:

Line 1621: po_asl_api_pvt.log('END ::: derive_ids_ch_auth');

1617: l_progress := 100;
1618:
1619: po_asl_api_pvt.log('derive_ids_ch_auth update chv_authorizations_gt rowcount:'
1620: || SQL%ROWCOUNT);
1621: po_asl_api_pvt.log('END ::: derive_ids_ch_auth');
1622: EXCEPTION
1623:
1624: WHEN OTHERS THEN
1625:

Line 1626: po_asl_api_pvt.log('derive_ids_ch_auth when others exception '

1622: EXCEPTION
1623:
1624: WHEN OTHERS THEN
1625:
1626: po_asl_api_pvt.log('derive_ids_ch_auth when others exception '
1627: || l_progress || ';' || SQLERRM);
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629: x_return_msg := SQLERRM;
1630:

Line 1659: po_asl_api_pvt.log('START ::: derive_ids_asl_attr');

1655: IS
1656: l_progress NUMBER := 0;
1657:
1658: BEGIN
1659: po_asl_api_pvt.log('START ::: derive_ids_asl_attr');
1660:
1661: UPDATE po_asl_attributes_gt paa
1662: SET paa.using_organization_id =
1663: (SELECT hout.organization_id

Line 1788: po_asl_api_pvt.log('derive_ids_asl_attr UPDATE po_asl_attributes_gt rowcount:'

1784: 'Min Days and Fixed Order Qty' , 4)
1785: WHERE paa.replenishment_method_dsp IS NOT NULL;
1786: l_progress := 100;
1787:
1788: po_asl_api_pvt.log('derive_ids_asl_attr UPDATE po_asl_attributes_gt rowcount:'
1789: || l_progress || ';' || SQL%ROWCOUNT);
1790: po_asl_api_pvt.log('END ::: derive_ids_asl_attr');
1791: EXCEPTION
1792:

Line 1790: po_asl_api_pvt.log('END ::: derive_ids_asl_attr');

1786: l_progress := 100;
1787:
1788: po_asl_api_pvt.log('derive_ids_asl_attr UPDATE po_asl_attributes_gt rowcount:'
1789: || l_progress || ';' || SQL%ROWCOUNT);
1790: po_asl_api_pvt.log('END ::: derive_ids_asl_attr');
1791: EXCEPTION
1792:
1793: WHEN OTHERS THEN
1794:

Line 1795: po_asl_api_pvt.log('derive_ids_asl_attr when others exception ' || SQLERRM);

1791: EXCEPTION
1792:
1793: WHEN OTHERS THEN
1794:
1795: po_asl_api_pvt.log('derive_ids_asl_attr when others exception ' || SQLERRM);
1796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1797: x_return_msg := SQLERRM;
1798:
1799: END derive_ids_asl_attr;

Line 1826: po_asl_api_pvt.log('START ::: derive_ids_sup_cap');

1822: )
1823: IS
1824:
1825: BEGIN
1826: po_asl_api_pvt.log('START ::: derive_ids_sup_cap');
1827:
1828: UPDATE po_supplier_item_capacity_gt poic
1829: SET poic.using_organization_id =
1830: (SELECT hout.organization_id

Line 1837: po_asl_api_pvt.log('derive_ids_sup_cap UPDATE po_supplier_item_capacity_gt rowcount:'

1833: AND hout.language = UserEnv('lang')
1834: AND ROWNUM < 2)
1835: WHERE poic.using_organization_dsp IS NOT NULL;
1836:
1837: po_asl_api_pvt.log('derive_ids_sup_cap UPDATE po_supplier_item_capacity_gt rowcount:'
1838: || SQL%ROWCOUNT);
1839: po_asl_api_pvt.log('END ::: derive_ids_sup_cap');
1840: EXCEPTION
1841:

Line 1839: po_asl_api_pvt.log('END ::: derive_ids_sup_cap');

1835: WHERE poic.using_organization_dsp IS NOT NULL;
1836:
1837: po_asl_api_pvt.log('derive_ids_sup_cap UPDATE po_supplier_item_capacity_gt rowcount:'
1838: || SQL%ROWCOUNT);
1839: po_asl_api_pvt.log('END ::: derive_ids_sup_cap');
1840: EXCEPTION
1841:
1842: WHEN OTHERS THEN
1843:

Line 1844: po_asl_api_pvt.log('derive_ids_sup_cap when others exception ' || SQLERRM);

1840: EXCEPTION
1841:
1842: WHEN OTHERS THEN
1843:
1844: po_asl_api_pvt.log('derive_ids_sup_cap when others exception ' || SQLERRM);
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: x_return_msg := SQLERRM;
1847:
1848: END derive_ids_sup_cap;

Line 1875: po_asl_api_pvt.log('START ::: derive_ids_sup_tol');

1871: )
1872: IS
1873:
1874: BEGIN
1875: po_asl_api_pvt.log('START ::: derive_ids_sup_tol');
1876:
1877: UPDATE po_supplier_item_tolerance_gt poit
1878: SET poit.using_organization_id =
1879: (SELECT hout.organization_id

Line 1886: po_asl_api_pvt.log('derive_ids_sup_tol UPDATE po_supplier_item_tolerance_gt rowcount:'

1882: AND hout.language = UserEnv('lang')
1883: AND ROWNUM < 2)
1884: WHERE poit.using_organization_dsp IS NOT NULL;
1885:
1886: po_asl_api_pvt.log('derive_ids_sup_tol UPDATE po_supplier_item_tolerance_gt rowcount:'
1887: || SQL%ROWCOUNT);
1888: po_asl_api_pvt.log('END ::: derive_ids_sup_tol');
1889: EXCEPTION
1890:

Line 1888: po_asl_api_pvt.log('END ::: derive_ids_sup_tol');

1884: WHERE poit.using_organization_dsp IS NOT NULL;
1885:
1886: po_asl_api_pvt.log('derive_ids_sup_tol UPDATE po_supplier_item_tolerance_gt rowcount:'
1887: || SQL%ROWCOUNT);
1888: po_asl_api_pvt.log('END ::: derive_ids_sup_tol');
1889: EXCEPTION
1890:
1891: WHEN OTHERS THEN
1892:

Line 1893: po_asl_api_pvt.log('derive_ids_sup_tol when others exception ' || SQLERRM);

1889: EXCEPTION
1890:
1891: WHEN OTHERS THEN
1892:
1893: po_asl_api_pvt.log('derive_ids_sup_tol when others exception ' || SQLERRM);
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: x_return_msg := SQLERRM;
1896:
1897: END derive_ids_sup_tol;

Line 1931: po_asl_api_pvt.log('START ::: collect_invalids_in_asl_gt');

1927: l_entity_name1 po_tbl_varchar30;
1928: l_reject_reason1 po_tbl_varchar2000;
1929:
1930: BEGIN
1931: po_asl_api_pvt.log('START ::: collect_invalids_in_asl_gt');
1932:
1933: --SQL queries are broken since cost is greater than 10
1934: SELECT user_key ,
1935: entity ,

Line 2031: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL

2027: l_progress := 50;
2028: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
2029: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
2030: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
2031: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2032: po_asl_api_pvt.log('collect_invalids_in_asl_gt: reject count:' ||
2033: l_user_key_tbl1.Count);
2034: IF l_user_key_tbl1.Count > 0
2035: THEN

Line 2032: po_asl_api_pvt.log('collect_invalids_in_asl_gt: reject count:' ||

2028: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
2029: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
2030: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
2031: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2032: po_asl_api_pvt.log('collect_invalids_in_asl_gt: reject count:' ||
2033: l_user_key_tbl1.Count);
2034: IF l_user_key_tbl1.Count > 0
2035: THEN
2036: po_asl_api_pvt.reject_asl_record(

Line 2036: po_asl_api_pvt.reject_asl_record(

2032: po_asl_api_pvt.log('collect_invalids_in_asl_gt: reject count:' ||
2033: l_user_key_tbl1.Count);
2034: IF l_user_key_tbl1.Count > 0
2035: THEN
2036: po_asl_api_pvt.reject_asl_record(
2037: p_user_key_tbl => l_user_key_tbl1,
2038: p_rejection_reason=> l_reject_reason1,
2039: p_entity_name => l_entity_name1,
2040: p_session_key => g_session_key,

Line 2047: po_asl_api_pvt.log('END ::: collect_invalids_in_asl_gt');

2043: );
2044: END IF;
2045: l_progress := 100;
2046: x_return_status := FND_API.G_RET_STS_SUCCESS;
2047: po_asl_api_pvt.log('END ::: collect_invalids_in_asl_gt');
2048: EXCEPTION
2049:
2050: WHEN OTHERS THEN
2051:

Line 2052: po_asl_api_pvt.log('collect_invalids_in_asl_gt when others exception '

2048: EXCEPTION
2049:
2050: WHEN OTHERS THEN
2051:
2052: po_asl_api_pvt.log('collect_invalids_in_asl_gt when others exception '
2053: || l_progress || ';' || SQLERRM);
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2055: x_return_msg := SQLERRM;
2056:

Line 2090: po_asl_api_pvt.log('START ::: collect_invalids_in_aslattr_gt');

2086: l_entity_name1 po_tbl_varchar30;
2087: l_reject_reason1 po_tbl_varchar2000;
2088:
2089: BEGIN
2090: po_asl_api_pvt.log('START ::: collect_invalids_in_aslattr_gt');
2091:
2092: --SQL queries are broken since cost is greater than 10
2093: SELECT user_key ,
2094: entity ,

Line 2263: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL

2259: l_progress := 50;
2260: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
2261: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
2262: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
2263: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2264: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt: reject count:' ||
2265: l_user_key_tbl1.Count);
2266: IF l_user_key_tbl1.Count > 0
2267: THEN

Line 2264: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt: reject count:' ||

2260: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;
2261: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
2262: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
2263: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2264: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt: reject count:' ||
2265: l_user_key_tbl1.Count);
2266: IF l_user_key_tbl1.Count > 0
2267: THEN
2268: po_asl_api_pvt.reject_asl_record(

Line 2268: po_asl_api_pvt.reject_asl_record(

2264: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt: reject count:' ||
2265: l_user_key_tbl1.Count);
2266: IF l_user_key_tbl1.Count > 0
2267: THEN
2268: po_asl_api_pvt.reject_asl_record(
2269: p_user_key_tbl => l_user_key_tbl1,
2270: p_rejection_reason=> l_reject_reason1,
2271: p_entity_name => l_entity_name1,
2272: p_session_key => g_session_key,

Line 2279: po_asl_api_pvt.log('END ::: collect_invalids_in_aslattr_gt');

2275: );
2276: END IF;
2277: l_progress := 100;
2278: x_return_status := FND_API.G_RET_STS_SUCCESS;
2279: po_asl_api_pvt.log('END ::: collect_invalids_in_aslattr_gt');
2280: EXCEPTION
2281:
2282: WHEN OTHERS THEN
2283:

Line 2284: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt when others exception '

2280: EXCEPTION
2281:
2282: WHEN OTHERS THEN
2283:
2284: po_asl_api_pvt.log('collect_invalids_in_aslattr_gt when others exception '
2285: || l_progress || ';' || SQLERRM);
2286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2287: x_return_msg := SQLERRM;
2288:

Line 2328: po_asl_api_pvt.log('START ::: collect_invalids_in_other_gt');

2324: l_entity_name1 po_tbl_varchar30;
2325: l_reject_reason1 po_tbl_varchar2000;
2326:
2327: BEGIN
2328: po_asl_api_pvt.log('START ::: collect_invalids_in_other_gt');
2329:
2330: --SQL queries are broken since cost is greater than 10
2331: SELECT user_key ,
2332: entity ,

Line 2553: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL

2549: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
2550: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_rejection_reason;
2551:
2552: l_progress := 50;
2553: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2554: po_asl_api_pvt.log('collect_invalids_in_other_gt: reject count:' ||
2555: l_user_key_tbl1.Count);
2556: IF l_user_key_tbl1.Count > 0
2557: THEN

Line 2554: po_asl_api_pvt.log('collect_invalids_in_other_gt: reject count:' ||

2550: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_rejection_reason;
2551:
2552: l_progress := 50;
2553: --call po_asl_api_pvt.reject_asl_record for which the id VALUES remain NULL
2554: po_asl_api_pvt.log('collect_invalids_in_other_gt: reject count:' ||
2555: l_user_key_tbl1.Count);
2556: IF l_user_key_tbl1.Count > 0
2557: THEN
2558: po_asl_api_pvt.reject_asl_record(

Line 2558: po_asl_api_pvt.reject_asl_record(

2554: po_asl_api_pvt.log('collect_invalids_in_other_gt: reject count:' ||
2555: l_user_key_tbl1.Count);
2556: IF l_user_key_tbl1.Count > 0
2557: THEN
2558: po_asl_api_pvt.reject_asl_record(
2559: p_user_key_tbl => l_user_key_tbl1,
2560: p_rejection_reason => l_reject_reason1,
2561: p_entity_name => l_entity_name1,
2562: p_session_key => g_session_key,

Line 2569: po_asl_api_pvt.log('END ::: collect_invalids_in_other_gt');

2565: );
2566: END IF;
2567: l_progress := 100;
2568: x_return_status := FND_API.G_RET_STS_SUCCESS;
2569: po_asl_api_pvt.log('END ::: collect_invalids_in_other_gt');
2570: EXCEPTION
2571:
2572: WHEN OTHERS THEN
2573:

Line 2574: po_asl_api_pvt.log('collect_invalids_in_other_gt when others exception '

2570: EXCEPTION
2571:
2572: WHEN OTHERS THEN
2573:
2574: po_asl_api_pvt.log('collect_invalids_in_other_gt when others exception '
2575: || l_progress || ';' || SQLERRM);
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2577: x_return_msg := SQLERRM;
2578:

Line 2620: po_asl_api_pvt.log('START ::: get_doc_header');

2616: l_owning_org_id NUMBER;
2617:
2618:
2619: BEGIN
2620: po_asl_api_pvt.log('START ::: get_doc_header');
2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);
2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2624: po_asl_api_pvt.log('p_segment:' || p_segment);

Line 2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);

2617:
2618:
2619: BEGIN
2620: po_asl_api_pvt.log('START ::: get_doc_header');
2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);
2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2624: po_asl_api_pvt.log('p_segment:' || p_segment);
2625: SELECT ASL.item_id ,

Line 2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);

2618:
2619: BEGIN
2620: po_asl_api_pvt.log('START ::: get_doc_header');
2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);
2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2624: po_asl_api_pvt.log('p_segment:' || p_segment);
2625: SELECT ASL.item_id ,
2626: ASL.category_id ,

Line 2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);

2619: BEGIN
2620: po_asl_api_pvt.log('START ::: get_doc_header');
2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);
2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2624: po_asl_api_pvt.log('p_segment:' || p_segment);
2625: SELECT ASL.item_id ,
2626: ASL.category_id ,
2627: ASL.vendor_id ,

Line 2624: po_asl_api_pvt.log('p_segment:' || p_segment);

2620: po_asl_api_pvt.log('START ::: get_doc_header');
2621: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2622: po_asl_api_pvt.log('p_doc_type:' || p_doc_type);
2623: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2624: po_asl_api_pvt.log('p_segment:' || p_segment);
2625: SELECT ASL.item_id ,
2626: ASL.category_id ,
2627: ASL.vendor_id ,
2628: ASL.vendor_site_id ,

Line 2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);

2636: WHERE ASL.user_key = p_user_key
2637: AND ROWNUM < 2;
2638:
2639: l_progress := 20;
2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);
2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);
2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);
2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);

Line 2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);

2637: AND ROWNUM < 2;
2638:
2639: l_progress := 20;
2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);
2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);
2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);
2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);
2645: IF l_item_id IS NOT NULL

Line 2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);

2638:
2639: l_progress := 20;
2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);
2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);
2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);
2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);
2645: IF l_item_id IS NOT NULL
2646: THEN

Line 2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);

2639: l_progress := 20;
2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);
2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);
2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);
2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);
2645: IF l_item_id IS NOT NULL
2646: THEN
2647: po_asl_api_pvt.log('inside if');

Line 2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);

2640: po_asl_api_pvt.log('l_item_id:' || l_item_id);
2641: po_asl_api_pvt.log('l_category_id:' || l_category_id);
2642: po_asl_api_pvt.log('l_vendor_id:' || l_vendor_id);
2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);
2645: IF l_item_id IS NOT NULL
2646: THEN
2647: po_asl_api_pvt.log('inside if');
2648: SELECT poh.po_header_id

Line 2647: po_asl_api_pvt.log('inside if');

2643: po_asl_api_pvt.log('l_vendor_site_id:' || l_vendor_site_id);
2644: po_asl_api_pvt.log('l_owning_org_id:' || l_owning_org_id);
2645: IF l_item_id IS NOT NULL
2646: THEN
2647: po_asl_api_pvt.log('inside if');
2648: SELECT poh.po_header_id
2649: INTO l_header_id
2650: FROM po_lookup_codes plc,
2651: po_headers_all poh,

Line 2749: po_asl_api_pvt.log('inside else if');

2745: plc.lookup_type(+)
2746: AND poh.segment1 = p_segment;
2747: ELSIF l_category_id IS NOT NULL
2748: THEN
2749: po_asl_api_pvt.log('inside else if');
2750: SELECT poh.po_header_id
2751: INTO l_header_id
2752: FROM po_lookup_codes plc,
2753: po_headers_all poh,

Line 2851: po_asl_api_pvt.log('l_header_id ::: ' || l_header_id);

2847: 'CONTRACT', 'AUTHORIZATION STATUS') =
2848: plc.lookup_type(+)
2849: AND poh.segment1 = p_segment;
2850: END IF;
2851: po_asl_api_pvt.log('l_header_id ::: ' || l_header_id);
2852: po_asl_api_pvt.log('END ::: get_doc_header');
2853: RETURN l_header_id;
2854: EXCEPTION
2855: WHEN OTHERS THEN

Line 2852: po_asl_api_pvt.log('END ::: get_doc_header');

2848: plc.lookup_type(+)
2849: AND poh.segment1 = p_segment;
2850: END IF;
2851: po_asl_api_pvt.log('l_header_id ::: ' || l_header_id);
2852: po_asl_api_pvt.log('END ::: get_doc_header');
2853: RETURN l_header_id;
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856:

Line 2857: po_asl_api_pvt.log('get_doc_header when others exception '

2853: RETURN l_header_id;
2854: EXCEPTION
2855: WHEN OTHERS THEN
2856:
2857: po_asl_api_pvt.log('get_doc_header when others exception '
2858: || l_progress || ';' || SQLERRM);
2859: RETURN NULL;
2860:
2861: END get_doc_header;

Line 2898: po_asl_api_pvt.log('START ::: get_doc_line_id');

2894: l_item_id NUMBER;
2895: l_category_id NUMBER;
2896:
2897: BEGIN
2898: po_asl_api_pvt.log('START ::: get_doc_line_id');
2899: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2900: po_asl_api_pvt.log('p_header_id:' || p_header_id);
2901: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2902:

Line 2899: po_asl_api_pvt.log('p_user_key:' || p_user_key);

2895: l_category_id NUMBER;
2896:
2897: BEGIN
2898: po_asl_api_pvt.log('START ::: get_doc_line_id');
2899: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2900: po_asl_api_pvt.log('p_header_id:' || p_header_id);
2901: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2902:
2903: SELECT ASL.item_id ,

Line 2900: po_asl_api_pvt.log('p_header_id:' || p_header_id);

2896:
2897: BEGIN
2898: po_asl_api_pvt.log('START ::: get_doc_line_id');
2899: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2900: po_asl_api_pvt.log('p_header_id:' || p_header_id);
2901: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2902:
2903: SELECT ASL.item_id ,
2904: ASL.category_id

Line 2901: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);

2897: BEGIN
2898: po_asl_api_pvt.log('START ::: get_doc_line_id');
2899: po_asl_api_pvt.log('p_user_key:' || p_user_key);
2900: po_asl_api_pvt.log('p_header_id:' || p_header_id);
2901: po_asl_api_pvt.log('p_using_org_id:' || p_using_org_id);
2902:
2903: SELECT ASL.item_id ,
2904: ASL.category_id
2905: INTO l_item_id ,

Line 2911: po_asl_api_pvt.log('l_item_id :' || l_item_id);

2907: FROM po_approved_supplier_list_gt ASL
2908: WHERE ASL.user_key = p_user_key
2909: AND ROWNUM < 2;
2910:
2911: po_asl_api_pvt.log('l_item_id :' || l_item_id);
2912: po_asl_api_pvt.log('l_category_id :' || l_category_id);
2913:
2914: l_progress := 20;
2915:

Line 2912: po_asl_api_pvt.log('l_category_id :' || l_category_id);

2908: WHERE ASL.user_key = p_user_key
2909: AND ROWNUM < 2;
2910:
2911: po_asl_api_pvt.log('l_item_id :' || l_item_id);
2912: po_asl_api_pvt.log('l_category_id :' || l_category_id);
2913:
2914: l_progress := 20;
2915:
2916: IF l_item_id IS NOT NULL

Line 2918: po_asl_api_pvt.log('inside if :');

2914: l_progress := 20;
2915:
2916: IF l_item_id IS NOT NULL
2917: THEN
2918: po_asl_api_pvt.log('inside if :');
2919: SELECT pol.po_line_id
2920: INTO l_line_id
2921: FROM po_lines_all pol,
2922: fnd_currencies_vl fnc,

Line 2971: po_asl_api_pvt.log('inside else :');

2967: AND poh.currency_code = fnc.currency_code
2968: AND pol.line_num = p_line_num;
2969: ELSIF l_category_id IS NOT NULL
2970: THEN
2971: po_asl_api_pvt.log('inside else :');
2972: SELECT pol.po_line_id
2973: INTO l_line_id
2974: FROM po_lines_all pol,
2975: fnd_currencies_vl fnc,

Line 3028: po_asl_api_pvt.log('END ::: get_doc_line_id');

3024:
3025: END IF;
3026:
3027: l_progress := 100;
3028: po_asl_api_pvt.log('END ::: get_doc_line_id');
3029: RETURN l_line_id;
3030: EXCEPTION
3031: WHEN OTHERS THEN
3032:

Line 3033: po_asl_api_pvt.log('get_doc_line_id when others exception '

3029: RETURN l_line_id;
3030: EXCEPTION
3031: WHEN OTHERS THEN
3032:
3033: po_asl_api_pvt.log('get_doc_line_id when others exception '
3034: || l_progress || ';' || SQLERRM);
3035: RETURN NULL;
3036:
3037: END get_doc_line_id;