DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on FND_MESSAGE

Line 106: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

102: WHEN OTHERS THEN
103: IF c_financial_params%ISOPEN THEN
104: CLOSE c_financial_params;
105: END IF;
106: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
107: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'initialize- '||
108: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
109: FND_MSG_PUB.Add;
110:

Line 107: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'initialize- '||

103: IF c_financial_params%ISOPEN THEN
104: CLOSE c_financial_params;
105: END IF;
106: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
107: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'initialize- '||
108: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
109: FND_MSG_PUB.Add;
110:
111: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1301: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

1297: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification',
1298: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
1299: END IF;
1300: IF (appl_short_name = 'SQLAP') THEN
1301: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1305: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||

Line 1302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1298: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80) );
1299: END IF;
1300: IF (appl_short_name = 'SQLAP') THEN
1301: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1305: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1306: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||

Line 1303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1299: END IF;
1300: IF (appl_short_name = 'SQLAP') THEN
1301: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1305: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1306: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||
1307: ',p_ref_doc_event_class_code = '||p_ref_doc_event_class_code ||

Line 1304: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1300: IF (appl_short_name = 'SQLAP') THEN
1301: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1305: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1306: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||
1307: ',p_ref_doc_event_class_code = '||p_ref_doc_event_class_code ||
1308: ',p_ref_doc_trx_id = '||TO_CHAR(p_ref_doc_trx_id) ||

Line 1323: FND_MESSAGE.SET_NAME('PO', 'PO_DEBUG');

1319: ', FUNC_SHORT_NAME = '||FUNC_SHORT_NAME ||
1320: ', p_calling_sequence = '||p_calling_sequence);
1321:
1322: ELSIF (appl_short_name = 'PO') THEN --Bug 6510307
1323: FND_MESSAGE.SET_NAME('PO', 'PO_DEBUG');
1324: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1325: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1326: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1327: 'p_ship_to_location_id = '||to_char (p_ship_to_location_id) ||

Line 1324: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1320: ', p_calling_sequence = '||p_calling_sequence);
1321:
1322: ELSIF (appl_short_name = 'PO') THEN --Bug 6510307
1323: FND_MESSAGE.SET_NAME('PO', 'PO_DEBUG');
1324: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1325: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1326: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1327: 'p_ship_to_location_id = '||to_char (p_ship_to_location_id) ||
1328: ', p_ship_to_loc_org_id = '||to_char (p_ship_to_loc_org_id) ||

Line 1325: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1321:
1322: ELSIF (appl_short_name = 'PO') THEN --Bug 6510307
1323: FND_MESSAGE.SET_NAME('PO', 'PO_DEBUG');
1324: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1325: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1326: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1327: 'p_ship_to_location_id = '||to_char (p_ship_to_location_id) ||
1328: ', p_ship_to_loc_org_id = '||to_char (p_ship_to_loc_org_id) ||
1329: ', p_inventory_item_id = '||to_char (p_inventory_item_id) ||

Line 1326: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1322: ELSIF (appl_short_name = 'PO') THEN --Bug 6510307
1323: FND_MESSAGE.SET_NAME('PO', 'PO_DEBUG');
1324: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1325: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1326: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1327: 'p_ship_to_location_id = '||to_char (p_ship_to_location_id) ||
1328: ', p_ship_to_loc_org_id = '||to_char (p_ship_to_loc_org_id) ||
1329: ', p_inventory_item_id = '||to_char (p_inventory_item_id) ||
1330: ', p_item_org_id = '||to_char (p_item_org_id) ||

Line 1339: FND_MESSAGE.SET_NAME('IGC', 'IGC_DEBUG');

1335: ', FUNC_SHORT_NAME = '||FUNC_SHORT_NAME ||
1336: ', p_calling_sequence = '||p_calling_sequence);
1337:
1338: ELSE --Bug 6510307
1339: FND_MESSAGE.SET_NAME('IGC', 'IGC_DEBUG');
1340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1342: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1343: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||

Line 1340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1336: ', p_calling_sequence = '||p_calling_sequence);
1337:
1338: ELSE --Bug 6510307
1339: FND_MESSAGE.SET_NAME('IGC', 'IGC_DEBUG');
1340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1342: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1343: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1344: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||

Line 1341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1337:
1338: ELSE --Bug 6510307
1339: FND_MESSAGE.SET_NAME('IGC', 'IGC_DEBUG');
1340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1342: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1343: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1344: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||
1345: ',p_ref_doc_event_class_code = '||p_ref_doc_event_class_code ||

Line 1342: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1338: ELSE --Bug 6510307
1339: FND_MESSAGE.SET_NAME('IGC', 'IGC_DEBUG');
1340: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1341: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1342: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1343: ' p_ref_doc_application_id = '|| to_char (p_ref_doc_application_id) ||
1344: ', p_ref_doc_entity_code = '||p_ref_doc_entity_code ||
1345: ',p_ref_doc_event_class_code = '||p_ref_doc_event_class_code ||
1346: ',p_ref_doc_trx_id = '||TO_CHAR(p_ref_doc_trx_id) ||

Line 1574: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1570: RETURN (l_tax_classification_code);
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1575: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_input_tax_classif_code- '||
1576: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1577: FND_MSG_PUB.Add;
1578: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1575: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_input_tax_classif_code- '||

1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1575: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_input_tax_classif_code- '||
1576: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1577: FND_MSG_PUB.Add;
1578: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1579: FND_LOG.STRING(g_level_unexpected,

Line 1721: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1717: RETURN (l_tax_classification_code);
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN
1721: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1722: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_site_tax- '||
1723: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1724: FND_MSG_PUB.Add;
1725: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1722: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_site_tax- '||

1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN
1721: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1722: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_site_tax- '||
1723: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1724: FND_MSG_PUB.Add;
1725: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1726: FND_LOG.STRING(g_level_unexpected,

Line 1871: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1867: RETURN (l_tax_classification_code);
1868:
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1872: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Vendor_Tax- '||
1873: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1874: FND_MSG_PUB.Add;
1875: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1872: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Vendor_Tax- '||

1868:
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1872: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Vendor_Tax- '||
1873: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1874: FND_MSG_PUB.Add;
1875: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1876: FND_LOG.STRING(g_level_unexpected,

Line 2042: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2038: RETURN (l_tax_classification_code);
2039:
2040: EXCEPTION
2041: WHEN OTHERS THEN
2042: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2043: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Ship_To_Location_Tax- '||
2044: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2045: FND_MSG_PUB.Add;
2046: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2043: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Ship_To_Location_Tax- '||

2039:
2040: EXCEPTION
2041: WHEN OTHERS THEN
2042: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2043: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'Get_Ship_To_Location_Tax- '||
2044: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2045: FND_MSG_PUB.Add;
2046: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2047: FND_LOG.STRING(g_level_unexpected,

Line 2194: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2190: RETURN (l_tax_classification_code);
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2195: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Item_Tax- '||
2196: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2197: FND_MSG_PUB.Add;
2198:

Line 2195: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Item_Tax- '||

2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2195: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Item_Tax- '||
2196: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2197: FND_MSG_PUB.Add;
2198:
2199: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2463: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2459: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2460: END IF;
2461:
2462: WHEN others THEN
2463: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2464: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_account_tax- '||
2465: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2466: FND_MSG_PUB.Add;
2467:

Line 2464: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_account_tax- '||

2460: END IF;
2461:
2462: WHEN others THEN
2463: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2464: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'get_account_tax- '||
2465: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2466: FND_MSG_PUB.Add;
2467:
2468: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2706: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2702: END IF;
2703: IF c_ioe_default_options%ISOPEN THEN
2704: CLOSE c_ioe_default_options;
2705: END IF;
2706: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2707: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_ap_def_option_hier- '||
2708: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2709: FND_MSG_PUB.Add;
2710:

Line 2707: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_ap_def_option_hier- '||

2703: IF c_ioe_default_options%ISOPEN THEN
2704: CLOSE c_ioe_default_options;
2705: END IF;
2706: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2707: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_ap_def_option_hier- '||
2708: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2709: FND_MSG_PUB.Add;
2710:
2711: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 2880: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

2876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2877: IF c_po_default_options%ISOPEN THEN
2878: CLOSE c_po_default_options;
2879: END IF;
2880: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2881: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_po_def_option_hier- '||
2882: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2883: FND_MSG_PUB.Add;
2884:

Line 2881: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_po_def_option_hier- '||

2877: IF c_po_default_options%ISOPEN THEN
2878: CLOSE c_po_default_options;
2879: END IF;
2880: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
2881: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_po_def_option_hier- '||
2882: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2883: FND_MSG_PUB.Add;
2884:
2885: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 3033: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

3029: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3030: IF c_cc_default_options%ISOPEN THEN
3031: CLOSE c_cc_default_options;
3032: END IF;
3033: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_cc_def_option_hier- '||
3035: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3036: FND_MSG_PUB.Add;
3037:

Line 3034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_cc_def_option_hier- '||

3030: IF c_cc_default_options%ISOPEN THEN
3031: CLOSE c_cc_default_options;
3032: END IF;
3033: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
3034: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', 'pop_cc_def_option_hier- '||
3035: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3036: FND_MSG_PUB.Add;
3037:
3038: IF (g_level_unexpected >= g_current_runtime_level ) THEN