DBA Data[Home] [Help]

APPS.PO_COPYDOC_S3 dependencies on PO_COPYDOC_S1

Line 56: po_copydoc_s1.online_report(x_online_report_id,

52:
53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN
55: x_line_type_id := NULL;
56: po_copydoc_s1.online_report(x_online_report_id,
57: x_sequence,
58: 'Invalid Line type',
59: x_line_num, 0, 0);
60: x_return_code := -1;

Line 63: po_copydoc_s1.copydoc_sql_error('validate_line_type_id', x_progress, sqlcode,

59: x_line_num, 0, 0);
60: x_return_code := -1;
61: WHEN OTHERS THEN
62: x_line_type_id := NULL;
63: po_copydoc_s1.copydoc_sql_error('validate_line_type_id', x_progress, sqlcode,
64: x_online_report_id,
65: x_sequence,
66: x_line_num, 0, 0);
67: x_return_code := -1;

Line 103: po_copydoc_s1.online_report(x_online_report_id,

99:
100: EXCEPTION
101: WHEN NO_DATA_FOUND THEN
102: x_transaction_reason_code := NULL;
103: po_copydoc_s1.online_report(x_online_report_id,
104: x_sequence,
105: 'Invalid Transaction reason code',
106: x_line_num, 0, 0);
107: x_return_code := 0;

Line 110: po_copydoc_s1.copydoc_sql_error('validate_trx_reason_code', x_progress, sqlcode,

106: x_line_num, 0, 0);
107: x_return_code := 0;
108: WHEN OTHERS THEN
109: x_transaction_reason_code := NULL;
110: po_copydoc_s1.copydoc_sql_error('validate_trx_reason_code', x_progress, sqlcode,
111: x_online_report_id,
112: x_sequence,
113: x_line_num, 0, 0);
114: x_return_code := -1;

Line 178: po_copydoc_s1.copydoc_debug('validate_line()');

174: l_category_set_id mtl_category_sets_v.category_set_id%TYPE;
175: --Bug 16559524
176: BEGIN
177:
178: po_copydoc_s1.copydoc_debug('validate_line()');
179:
180: /****** Unchanged Attributes
181: note_to_vendor
182: qty_rcv_tolerance

Line 275: PO_COPYDOC_S1.online_report(x_online_report_id,

271: p_message => 'category id is invalid: '|| x_po_line_record.category_id);
272: END IF;
273:
274: FND_MESSAGE.set_name('PO', 'PO_RI_INVALID_CATEGORY_ID');
275: PO_COPYDOC_S1.online_report(x_online_report_id,
276: x_sequence,
277: substr(fnd_message.get, 1, 240),
278: x_po_line_record.line_num, 0, 0);
279: x_return_code := -1;

Line 282: PO_COPYDOC_S1.copydoc_sql_error('validate_category',

278: x_po_line_record.line_num, 0, 0);
279: x_return_code := -1;
280: RETURN;
281: WHEN OTHERS THEN
282: PO_COPYDOC_S1.copydoc_sql_error('validate_category',
283: x_progress,
284: sqlcode,
285: x_online_report_id,
286: x_sequence,

Line 382: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,

378: FROM po_line_types
379: WHERE line_type_id = x_po_line_record.line_type_id;
380: exception
381: when others then
382: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,
383: x_online_report_id,
384: x_sequence,
385: x_po_line_record.line_num, 0, 0);
386: x_return_code := -1;

Line 590: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,

586: FROM SYS.DUAL;
587: EXCEPTION
588: WHEN OTHERS THEN
589: x_po_line_record.po_line_id := NULL;
590: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,
591: x_online_report_id,
592: x_sequence,
593: x_po_line_record.line_num, 0, 0);
594: RAISE COPYDOC_LINE_FAILURE;

Line 604: po_copydoc_s1.copydoc_debug('End: validate_line()');

600: x_po_line_record.price_break_lookup_code := NULL;
601: END IF;
602:
603: x_return_code := 0;
604: po_copydoc_s1.copydoc_debug('End: validate_line()');
605:
606: EXCEPTION
607: WHEN COPYDOC_LINE_FAILURE THEN
608: x_return_code := -1;

Line 610: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,

606: EXCEPTION
607: WHEN COPYDOC_LINE_FAILURE THEN
608: x_return_code := -1;
609: WHEN OTHERS THEN
610: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,
611: x_online_report_id,
612: x_sequence,
613: x_po_line_record.line_num, 0, 0);
614: x_return_code := -1;