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

Line 20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

16: l_min_unit gl_currencies.minimum_accountable_unit%TYPE;
17:
18: BEGIN
19:
20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);
24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);

Line 21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');

17:
18: BEGIN
19:
20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);
24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);
25: END IF;

Line 22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);

18: BEGIN
19:
20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);
24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);
25: END IF;
26:

Line 23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);

19:
20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);
24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);
25: END IF;
26:
27: SELECT currency_code INTO l_currency_code

Line 24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);

20: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
21: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.getPoLineAmount procedure');
22: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_header_id: ' || p_po_header_id);
23: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_line_id: ' || p_po_line_id);
24: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_po_draft_id: ' || p_po_draft_id);
25: END IF;
26:
27: SELECT currency_code INTO l_currency_code
28: FROM po_headers_draft_all

Line 33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

29: WHERE po_header_id = p_po_header_id AND draft_id = p_po_draft_id;
30:
31: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);
32:
33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);
36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);

Line 34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);

30:
31: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);
32:
33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);
36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);
38: END IF;

Line 35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);

31: fnd_currency.get_info(l_currency_code, l_precision, l_ext_precision, l_min_unit);
32:
33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);
36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);
38: END IF;
39:

Line 36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);

32:
33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);
36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);
38: END IF;
39:
40: SELECT DECODE(matching_basis, 'AMOUNT', amount, nvl2(l_min_unit, round(quantity*unit_price/l_min_unit) * l_min_unit, round((quantity*unit_price),l_precision)) ) -- Bug# 5378134

Line 37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);

33: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
34: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_currency_code: ' || l_currency_code);
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_precision: ' || l_precision);
36: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_ext_precision: ' || l_ext_precision);
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_min_unit: ' || l_min_unit);
38: END IF;
39:
40: SELECT DECODE(matching_basis, 'AMOUNT', amount, nvl2(l_min_unit, round(quantity*unit_price/l_min_unit) * l_min_unit, round((quantity*unit_price),l_precision)) ) -- Bug# 5378134
41: INTO l_line_amount

Line 45: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

41: INTO l_line_amount
42: FROM po_lines_merge_v
43: WHERE po_line_id = p_po_line_id AND draft_id = p_po_draft_id;
44:
45: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_line_amount: ' || l_line_amount);
47: END IF;
48:
49: IF(l_line_amount IS NULL ) THEN

Line 46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_line_amount: ' || l_line_amount);

42: FROM po_lines_merge_v
43: WHERE po_line_id = p_po_line_id AND draft_id = p_po_draft_id;
44:
45: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'l_line_amount: ' || l_line_amount);
47: END IF;
48:
49: IF(l_line_amount IS NULL ) THEN
50: l_line_amount := 0;

Line 56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

52:
53: RETURN l_line_amount;
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting po line amount. Error:' || sqlerrm);
58: END IF;
59: RETURN -1;
60: END getPoLineAmount;

Line 57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting po line amount. Error:' || sqlerrm);

53: RETURN l_line_amount;
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting po line amount. Error:' || sqlerrm);
58: END IF;
59: RETURN -1;
60: END getPoLineAmount;
61:

Line 88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

84: l_fsc_svc_codes PO_TBL_VARCHAR4000; --for IDV wihtout lines document fsc svc is a multi row attribute. For fetching them we will be using this variable
85:
86: BEGIN
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);

Line 89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');

85:
86: BEGIN
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);

Line 90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);

86: BEGIN
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);

Line 91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);

87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);

Line 92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);

88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);

Line 93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);

89: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);

Line 94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);

90: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_contract_id: ' || p_contract_id);
91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);

Line 95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);

91: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_id: ' || p_source_doc_id);
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);

92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter p_source_doc_type: ' || p_source_doc_type);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);

Line 97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);

93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_buyer_name: ' || x_buyer_name);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;

Line 98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);

94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;
102:

Line 99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_total_amount: ' || x_total_amount);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;
102:
103: IF p_source_doc_id IS NULL OR p_source_doc_type IS NULL THEN

Line 100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);

96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_currency: ' || x_currency);
97: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_naics_code: ' || x_naics_code);
98: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_size_standard: ' || x_size_standard);
99: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;
102:
103: IF p_source_doc_id IS NULL OR p_source_doc_type IS NULL THEN
104: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 104: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Input Parameter x_item_long_desc: ' || x_item_long_desc);
101: END IF;
102:
103: IF p_source_doc_id IS NULL OR p_source_doc_type IS NULL THEN
104: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving the procedure as the source documents are not filled properly');
106: END IF;
107:
108: RETURN; --returning if source document details are not found

Line 105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving the procedure as the source documents are not filled properly');

101: END IF;
102:
103: IF p_source_doc_id IS NULL OR p_source_doc_type IS NULL THEN
104: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving the procedure as the source documents are not filled properly');
106: END IF;
107:
108: RETURN; --returning if source document details are not found
109: END IF;

Line 135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

131: x_msg_count := '1';
132: x_msg_data := 'Exception in getting line details with maximum amount';
133: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
134:
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting line details with maximum amount. Error:' || sqlerrm);
137: END IF;
138: END;
139:

Line 136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting line details with maximum amount. Error:' || sqlerrm);

132: x_msg_data := 'Exception in getting line details with maximum amount';
133: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
134:
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while getting line details with maximum amount. Error:' || sqlerrm);
137: END IF;
138: END;
139:
140: /*

Line 144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

140: /*
141: --BUYER NAME DEFAULTING
142: */
143: -- IF x_buyer_name IS NULL THEN
144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Buyer Name from source document ');
146: END IF;
147: BEGIN
148: IF p_source_doc_type = 'SOLICITATION' THEN

Line 145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Buyer Name from source document ');

141: --BUYER NAME DEFAULTING
142: */
143: -- IF x_buyer_name IS NULL THEN
144: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Buyer Name from source document ');
146: END IF;
147: BEGIN
148: IF p_source_doc_type = 'SOLICITATION' THEN
149: SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')

Line 160: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

156: FROM po_headers_draft_all
157: WHERE draft_id = p_source_doc_id;
158: END IF;
159:
160: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted buyer name value to :' || x_buyer_name);
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN

Line 161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted buyer name value to :' || x_buyer_name);

157: WHERE draft_id = p_source_doc_id;
158: END IF;
159:
160: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted buyer name value to :' || x_buyer_name);
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

167: x_msg_count := '1';
168: x_msg_data := 'Exception in defaulting buyer name';
169: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
170:
171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting buyer name. Error:' || sqlerrm);
173: END IF;
174: END;
175: -- END IF;

Line 172: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting buyer name. Error:' || sqlerrm);

168: x_msg_data := 'Exception in defaulting buyer name';
169: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
170:
171: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting buyer name. Error:' || sqlerrm);
173: END IF;
174: END;
175: -- END IF;
176:

Line 181: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

177: /*
178: --OFFICE SYMBOL DEFAULTING
179: */
180: -- IF x_issuing_off_symbol IS NULL THEN
181: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Issuing Office Symbol from source document ');
183: END IF;
184:
185: BEGIN

Line 182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Issuing Office Symbol from source document ');

178: --OFFICE SYMBOL DEFAULTING
179: */
180: -- IF x_issuing_off_symbol IS NULL THEN
181: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Issuing Office Symbol from source document ');
183: END IF;
184:
185: BEGIN
186: IF p_source_doc_type = 'SOLICITATION' THEN

Line 198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

194: FROM po_headers_draft_all
195: WHERE draft_id = p_source_doc_id;
196: END IF;
197:
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted issuing office symbol value to :' || x_issuing_off_symbol);
200: END IF;
201: EXCEPTION
202: WHEN OTHERS THEN

Line 199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted issuing office symbol value to :' || x_issuing_off_symbol);

195: WHERE draft_id = p_source_doc_id;
196: END IF;
197:
198: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted issuing office symbol value to :' || x_issuing_off_symbol);
200: END IF;
201: EXCEPTION
202: WHEN OTHERS THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

205: x_msg_count := '1';
206: x_msg_data := 'Exception in defaulting issuing office symbol';
207: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
208:
209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting issuing office symbol. Error:' || sqlerrm);
211: END IF;
212: END;
213: -- END IF;

Line 210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting issuing office symbol. Error:' || sqlerrm);

206: x_msg_data := 'Exception in defaulting issuing office symbol';
207: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
208:
209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting issuing office symbol. Error:' || sqlerrm);
211: END IF;
212: END;
213: -- END IF;
214:

Line 219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

215: /*
216: --TOTAL ESTIMATED VALUE DEFAULTING
217: */
218: -- IF x_total_amount IS NULL THEN
219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Total Estimated value from source document ');
221: END IF;
222:
223: BEGIN

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Total Estimated value from source document ');

216: --TOTAL ESTIMATED VALUE DEFAULTING
217: */
218: -- IF x_total_amount IS NULL THEN
219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Total Estimated value from source document ');
221: END IF;
222:
223: BEGIN
224: IF p_source_doc_type = 'SOLICITATION' THEN

Line 234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

230: FROM po_drafts
231: WHERE draft_id = p_source_doc_id;
232: END IF;
233:
234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Total Estimated value to :' || x_total_amount);
236: END IF;
237: EXCEPTION
238: WHEN OTHERS THEN

Line 235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Total Estimated value to :' || x_total_amount);

231: WHERE draft_id = p_source_doc_id;
232: END IF;
233:
234: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Total Estimated value to :' || x_total_amount);
236: END IF;
237: EXCEPTION
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 245: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

241: x_msg_count := '1';
242: x_msg_data := 'Exception in defaulting Total Estimated value';
243: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
244:
245: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Total Estimated value. Error:' || sqlerrm);
247: END IF;
248: END;
249: -- END IF;

Line 246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Total Estimated value. Error:' || sqlerrm);

242: x_msg_data := 'Exception in defaulting Total Estimated value';
243: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
244:
245: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Total Estimated value. Error:' || sqlerrm);
247: END IF;
248: END;
249: -- END IF;
250:

Line 255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

251: /*
252: --CURRENCY DEFAULTING
253: */
254: -- IF x_currency IS NULL THEN
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting currency from source document ');
257: END IF;
258:
259: BEGIN

Line 256: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting currency from source document ');

252: --CURRENCY DEFAULTING
253: */
254: -- IF x_currency IS NULL THEN
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting currency from source document ');
257: END IF;
258:
259: BEGIN
260: IF p_source_doc_type = 'SOLICITATION' THEN

Line 270: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

266: FROM po_headers_draft_all
267: WHERE draft_id = p_source_doc_id;
268: END IF;
269:
270: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted currency value to :' || x_currency);
272: END IF;
273: EXCEPTION
274: WHEN OTHERS THEN

Line 271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted currency value to :' || x_currency);

267: WHERE draft_id = p_source_doc_id;
268: END IF;
269:
270: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted currency value to :' || x_currency);
272: END IF;
273: EXCEPTION
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

277: x_msg_count := '1';
278: x_msg_data := 'Exception in defaulting currency';
279: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
280:
281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting currency. Error:' || sqlerrm);
283: END IF;
284: END;
285: -- END IF;

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting currency. Error:' || sqlerrm);

278: x_msg_data := 'Exception in defaulting currency';
279: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
280:
281: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
282: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting currency. Error:' || sqlerrm);
283: END IF;
284: END;
285: -- END IF;
286:

Line 291: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

287: /*
288: -- NAICS CODE DEFAULTING
289: */
290: -- IF x_naics_code IS NULL THEN
291: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Naics code from source document ');
293: END IF;
294:
295: BEGIN

Line 292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Naics code from source document ');

288: -- NAICS CODE DEFAULTING
289: */
290: -- IF x_naics_code IS NULL THEN
291: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Naics code from source document ');
293: END IF;
294:
295: BEGIN
296: IF p_source_doc_type = 'SOLICITATION' THEN

Line 318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

314: p_attr_grp_int_name => 'FED_CUST_DESG',
315: p_attr_int_name => 'NAICS');
316: END IF;
317:
318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Naics code value to :' || x_naics_code);
320: END IF;
321: EXCEPTION
322: WHEN OTHERS THEN

Line 319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Naics code value to :' || x_naics_code);

315: p_attr_int_name => 'NAICS');
316: END IF;
317:
318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Naics code value to :' || x_naics_code);
320: END IF;
321: EXCEPTION
322: WHEN OTHERS THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

325: x_msg_count := '1';
326: x_msg_data := 'Exception in defaulting Naics code';
327: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
328:
329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Naics code. Error:' || sqlerrm);
331: END IF;
332: END;
333: -- END IF;

Line 330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Naics code. Error:' || sqlerrm);

326: x_msg_data := 'Exception in defaulting Naics code';
327: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
328:
329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Naics code. Error:' || sqlerrm);
331: END IF;
332: END;
333: -- END IF;
334:

Line 339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

335: /*
336: -- SIZE STANDARD DEFAULTING
337: */
338: -- IF x_size_standard IS NULL THEN
339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');
341: END IF;
342:
343: BEGIN

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');

336: -- SIZE STANDARD DEFAULTING
337: */
338: -- IF x_size_standard IS NULL THEN
339: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Size Standard from source document ');
341: END IF;
342:
343: BEGIN
344: IF p_source_doc_type = 'SOLICITATION' THEN

Line 356: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

352: FROM po_headers_draft_all
353: WHERE draft_id = p_source_doc_id;
354: END IF;
355:
356: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);

353: WHERE draft_id = p_source_doc_id;
354: END IF;
355:
356: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 367: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

363: x_msg_count := '1';
364: x_msg_data := 'Exception in defaulting Size Standard';
365: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
366:
367: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);
369: END IF;
370: END;
371: -- END IF;

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);

364: x_msg_data := 'Exception in defaulting Size Standard';
365: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
366:
367: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Size Standard. Error:' || sqlerrm);
369: END IF;
370: END;
371: -- END IF;
372:

Line 377: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

373: /*
374: -- FSC/SVC CODE DEFAULTING
375: */
376: -- IF x_fsc_svc_code IS NULL THEN
377: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting FSC/SVC Code from source document ');
379: END IF;
380:
381: BEGIN

Line 378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting FSC/SVC Code from source document ');

374: -- FSC/SVC CODE DEFAULTING
375: */
376: -- IF x_fsc_svc_code IS NULL THEN
377: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting FSC/SVC Code from source document ');
379: END IF;
380:
381: BEGIN
382: IF p_source_doc_type = 'SOLICITATION' THEN

Line 408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

404: p_attr_grp_int_name => 'FED_CUST_DESG',
405: p_attr_int_name => 'FSC_PSC');
406: END IF;
407:
408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted FSC/SVC Code value to :' || x_fsc_svc_code);
410: END IF;
411: EXCEPTION
412: WHEN OTHERS THEN

Line 409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted FSC/SVC Code value to :' || x_fsc_svc_code);

405: p_attr_int_name => 'FSC_PSC');
406: END IF;
407:
408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted FSC/SVC Code value to :' || x_fsc_svc_code);
410: END IF;
411: EXCEPTION
412: WHEN OTHERS THEN
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

415: x_msg_count := '1';
416: x_msg_data := 'Exception in defaulting FSC/SVC Code';
417: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
418:
419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting FSC/SVC Code. Error:' || sqlerrm);
421: END IF;
422: END;
423: -- END IF;

Line 420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting FSC/SVC Code. Error:' || sqlerrm);

416: x_msg_data := 'Exception in defaulting FSC/SVC Code';
417: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
418:
419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting FSC/SVC Code. Error:' || sqlerrm);
421: END IF;
422: END;
423: -- END IF;
424:

Line 429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

425: /*
426: -- ITEM DESCRIPTION DEFAULTING
427: */
428: -- IF x_item_long_desc IS NULL THEN
429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Item Description from source document ');
431: END IF;
432:
433: BEGIN

Line 430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Item Description from source document ');

426: -- ITEM DESCRIPTION DEFAULTING
427: */
428: -- IF x_item_long_desc IS NULL THEN
429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulting Item Description from source document ');
431: END IF;
432:
433: BEGIN
434: IF p_source_doc_type = 'SOLICITATION' THEN

Line 450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

446: p_attr_grp_int_name => 'ADD_ITEM_INFO',
447: p_attr_int_name => 'EXTND_DESC');
448: END IF;
449:
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Item long Description value to :' || x_item_long_desc);
452: END IF;
453: EXCEPTION
454: WHEN OTHERS THEN

Line 451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Item long Description value to :' || x_item_long_desc);

447: p_attr_int_name => 'EXTND_DESC');
448: END IF;
449:
450: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Item long Description value to :' || x_item_long_desc);
452: END IF;
453: EXCEPTION
454: WHEN OTHERS THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

457: x_msg_count := '1';
458: x_msg_data := 'Exception in defaulting Item Description';
459: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Item Description. Error:' || sqlerrm);
463: END IF;
464: END;
465: -- END IF;

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Item Description. Error:' || sqlerrm);

458: x_msg_data := 'Exception in defaulting Item Description';
459: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured while defaulting Item Description. Error:' || sqlerrm);
463: END IF;
464: END;
465: -- END IF;
466:

Line 472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

468: x_errorcode := '0';
469: x_msg_count := '1';
470: x_msg_data := 'SUCCESS';
471:
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);

Line 473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');

469: x_msg_count := '1';
470: x_msg_data := 'SUCCESS';
471:
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);

Line 474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);

470: x_msg_data := 'SUCCESS';
471:
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);

Line 475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);

471:
472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

Line 476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);

472: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);

473: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);

Line 478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);

474: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);

Line 479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);

Line 480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);

Line 481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);

477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);

Line 482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);

478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');

Line 483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);

479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
487: END IF;

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);

480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
487: END IF;
488:

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);

481: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
487: END IF;
488:
489: EXCEPTION

Line 486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');

482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
487: END IF;
488:
489: EXCEPTION
490: WHEN OTHERS THEN

Line 497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

493: x_msg_count := '1';
494: x_msg_data := 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT';
495: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
496:
497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);

Line 498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);

494: x_msg_data := 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT';
495: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
496:
497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);

Line 499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');

495: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);
496:
497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);

Line 500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);

496:
497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);

Line 501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);

497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

Line 502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);

498: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT:' || sqlerrm);
499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

Line 503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);

499: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Entered OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure');
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);

Line 504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);

500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_buyer_name: ' || x_buyer_name);
501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);

Line 505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);

501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_issuing_off_symbol: ' || x_issuing_off_symbol);
502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);

Line 506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);

502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_total_amount: ' || x_total_amount);
503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);

Line 507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);

503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_currency: ' || x_currency);
504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);

Line 508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);

504: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_naics_code: ' || x_naics_code);
505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');

Line 509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);

505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_size_standard: ' || x_size_standard);
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
513: END IF;

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);

506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_fsc_svc_code: ' || x_fsc_svc_code);
507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
513: END IF;
514: END sbcr_source_doc_default;

Line 511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);

507: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_item_long_desc: ' || x_item_long_desc);
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
513: END IF;
514: END sbcr_source_doc_default;
515:

Line 512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');

508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_return_status: ' || x_return_status);
509: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_errorcode: ' || x_errorcode);
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_count: ' || x_msg_count);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Output Parameter x_msg_data: ' || x_msg_data);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Leaving OKC_REP_UDA_FUNCTIONS.sbcr_source_doc_default procedure.');
513: END IF;
514: END sbcr_source_doc_default;
515:
516: END OKC_REP_UDA_FUNCTIONS;