DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on FND_MESSAGE

Line 169: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');

165: Open get_inv_org_name;
166: Fetch get_inv_org_name into l_inv_org_name;
167: Close get_inv_org_name;
168:
169: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
170: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
171: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
172: FND_MSG_PUB.Add;
173: RAISE FND_API.G_EXC_ERROR;

Line 170: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);

166: Fetch get_inv_org_name into l_inv_org_name;
167: Close get_inv_org_name;
168:
169: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
170: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
171: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
172: FND_MSG_PUB.Add;
173: RAISE FND_API.G_EXC_ERROR;
174: End if;

Line 171: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);

167: Close get_inv_org_name;
168:
169: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
170: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
171: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
172: FND_MSG_PUB.Add;
173: RAISE FND_API.G_EXC_ERROR;
174: End if;
175: End if;

Line 260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');

256: IF acct_site_csr%NOTFOUND THEN
257: close acct_site_csr;
258: --srini
259: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;

Line 261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);

257: close acct_site_csr;
258: --srini
259: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;
265: End if;

Line 262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);

258: --srini
259: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
260: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
261: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
262: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_ERROR;
265: End if;
266: ELSE

Line 272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');

268: -- Raise error if active customer account site doesn't exist but an inactive
269: -- custoemr account site exist. Charges will raise a clear error message instead of
270: -- passing this data to OC.
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');
273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;

Line 273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);

269: -- custoemr account site exist. Charges will raise a clear error message instead of
270: -- passing this data to OC.
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');
273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;

Line 274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);

270: -- passing this data to OC.
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_CUST_ACCT_SITE');
273: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
274: FND_MESSAGE.SET_TOKEN('PARTY_SITE_ID', p_party_site_id);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_ERROR;
277: END IF;
278: ELSE

Line 296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');

292: IF acct_site_use_csr%NOTFOUND THEN
293: close acct_site_use_csr;
294: --srini
295: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;

Line 297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);

293: close acct_site_use_csr;
294: --srini
295: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: End if;

Line 298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);

294: --srini
295: If fnd_profile.value('CS_SR_ACTION_MISS_ACCT') = 'CHG_ABORT_SUB' Then
296: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT_SITE_USE');
297: FND_MESSAGE.Set_Token('BILL_SHIP_ADDR',l_bill_ship_addr);
298: FND_MESSAGE.Set_Token('OPER_UNIT',l_inv_org_name);
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: End if;
302: ELSE

Line 308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');

304: -- Raise error if active bill to or ship to account site use doesn't exist but an
305: -- inactive bill to or ship to account site use exist. Charges will raise a clear
306: -- error message instead of passing this data to OC.
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');
309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
312: FND_MSG_PUB.Add;

Line 309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);

305: -- inactive bill to or ship to account site use exist. Charges will raise a clear
306: -- error message instead of passing this data to OC.
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');
309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;

Line 310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);

306: -- error message instead of passing this data to OC.
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');
309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;

Line 311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);

307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_INVALID_ACCT_SITE_USE');
309: FND_MESSAGE.SET_TOKEN('SITE_USE_CODE', p_site_use_code);
310: FND_MESSAGE.SET_TOKEN('ACCT_SITE_USE_ID', l_site_use_id);
311: FND_MESSAGE.SET_TOKEN('ACCT_SITE_ID', l_cust_acct_site_id);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315: ELSE

Line 334: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');

330:
331:
332: WHEN OTHERS THEN
333: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
334: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
335: fnd_message.set_token('ROUTINE','CS_Charge_Create_Order_PKG.Submit_Order');
336: fnd_message.set_token('REASON',g_oraerrmsg);
337: app_exception.raise_exception;
338:

Line 335: fnd_message.set_token('ROUTINE','CS_Charge_Create_Order_PKG.Submit_Order');

331:
332: WHEN OTHERS THEN
333: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
334: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
335: fnd_message.set_token('ROUTINE','CS_Charge_Create_Order_PKG.Submit_Order');
336: fnd_message.set_token('REASON',g_oraerrmsg);
337: app_exception.raise_exception;
338:
339: END validate_acct_site_uses;

Line 336: fnd_message.set_token('REASON',g_oraerrmsg);

332: WHEN OTHERS THEN
333: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
334: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
335: fnd_message.set_token('ROUTINE','CS_Charge_Create_Order_PKG.Submit_Order');
336: fnd_message.set_token('REASON',g_oraerrmsg);
337: app_exception.raise_exception;
338:
339: END validate_acct_site_uses;
340: --

Line 386: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

382: -- NULL;
383:
384: WHEN OTHERS THEN
385: ROLLBACK;
386: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
387: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'Cs_Charge_Create_Order_PVT.Update_Errors');
388: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
389: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
390: FND_MSG_PUB.add;

Line 387: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'Cs_Charge_Create_Order_PVT.Update_Errors');

383:
384: WHEN OTHERS THEN
385: ROLLBACK;
386: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
387: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'Cs_Charge_Create_Order_PVT.Update_Errors');
388: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
389: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
390: FND_MSG_PUB.add;
391:

Line 388: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

384: WHEN OTHERS THEN
385: ROLLBACK;
386: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
387: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'Cs_Charge_Create_Order_PVT.Update_Errors');
388: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
389: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
390: FND_MSG_PUB.add;
391:
392: END Update_Errors;

Line 389: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

385: ROLLBACK;
386: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
387: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'Cs_Charge_Create_Order_PVT.Update_Errors');
388: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
389: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
390: FND_MSG_PUB.add;
391:
392: END Update_Errors;
393: --

Line 721: L_API_ERROR_WITH_FND_MESSAGE EXCEPTION;

717:
718: -- Added for bug:5408354
719: l_arith_operator qp_list_lines.arithmetic_operator%type;
720: l_currency_code qp_list_headers.currency_code%type;
721: L_API_ERROR_WITH_FND_MESSAGE EXCEPTION;
722: --
723: --
724: -- Added this to get account_id after submitting an order to OM.
725: --

Line 853: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');

849: , L_LOG_MODULE || 'get_request_info_end'
850: , 'invalid input parameter :' || 'p_incident_id'
851: );
852: END IF;
853: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
856: FND_MSG_PUB.Add;
857: RAISE FND_API.G_EXC_ERROR;

Line 854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');

850: , 'invalid input parameter :' || 'p_incident_id'
851: );
852: END IF;
853: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
856: FND_MSG_PUB.Add;
857: RAISE FND_API.G_EXC_ERROR;
858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

851: );
852: END IF;
853: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
854: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
855: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
856: FND_MSG_PUB.Add;
857: RAISE FND_API.G_EXC_ERROR;
858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;

Line 868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');

864: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
865: , 'p_party_id'
866: );
867: END IF;
868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
869: FND_MESSAGE.Set_Token('PARAM','p_party_id');
870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
871: FND_MSG_PUB.Add;
872: RAISE FND_API.G_EXC_ERROR;

Line 869: FND_MESSAGE.Set_Token('PARAM','p_party_id');

865: , 'p_party_id'
866: );
867: END IF;
868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
869: FND_MESSAGE.Set_Token('PARAM','p_party_id');
870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
871: FND_MSG_PUB.Add;
872: RAISE FND_API.G_EXC_ERROR;
873: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

866: );
867: END IF;
868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
869: FND_MESSAGE.Set_Token('PARAM','p_party_id');
870: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
871: FND_MSG_PUB.Add;
872: RAISE FND_API.G_EXC_ERROR;
873: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;

Line 887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');

883: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
884: , 'p_book_order_flag'
885: );
886: END IF;
887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
890: FND_MSG_PUB.Add;
891: RAISE FND_API.G_EXC_ERROR;

Line 888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');

884: , 'p_book_order_flag'
885: );
886: END IF;
887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
890: FND_MSG_PUB.Add;
891: RAISE FND_API.G_EXC_ERROR;
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

885: );
886: END IF;
887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
888: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
889: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
890: FND_MSG_PUB.Add;
891: RAISE FND_API.G_EXC_ERROR;
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;

Line 903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');

899: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
900: , 'p_submit_source'
901: );
902: END IF;
903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
906: FND_MSG_PUB.Add;
907: RAISE FND_API.G_EXC_ERROR;

Line 904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');

900: , 'p_submit_source'
901: );
902: END IF;
903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
906: FND_MSG_PUB.Add;
907: RAISE FND_API.G_EXC_ERROR;
908: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

901: );
902: END IF;
903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
904: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
905: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
906: FND_MSG_PUB.Add;
907: RAISE FND_API.G_EXC_ERROR;
908: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;

Line 927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');

923: FND_LOG.String
924: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
925: );
926: END IF;
927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

924: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
925: );
926: END IF;
927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
929: FND_MSG_PUB.Add;
930: RAISE FND_API.G_EXC_ERROR;
931: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: --srini

Line 939: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');

935: Open Get_party_number;
936: Fetch Get_party_number into l_party_number;
937: Close Get_party_number;
938:
939: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');
940: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);
941: FND_MSG_PUB.Add;
942: RAISE FND_API.G_EXC_ERROR;
943: End if;

Line 940: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);

936: Fetch Get_party_number into l_party_number;
937: Close Get_party_number;
938:
939: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');
940: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);
941: FND_MSG_PUB.Add;
942: RAISE FND_API.G_EXC_ERROR;
943: End if;
944: END IF;

Line 966: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_DEFAULT_MODIFIER');

962: CLOSE Get_Modifier_Header;
963: END IF;
964: EXCEPTION
965: WHEN OTHERS THEN
966: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_DEFAULT_MODIFIER');
967: FND_MSG_PUB.Add;
968: RAISE FND_API.G_EXC_ERROR;
969: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END;

Line 1000: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');

996: END IF;
997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;

Line 1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');

997:
998: EXCEPTION
999: WHEN OTHERS THEN
1000: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

998: EXCEPTION
999: WHEN OTHERS THEN
1000: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1001: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1002: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006:

Line 1153: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_CAT_CODE');

1149: --
1150: -- VALIDATE CATEGORY CODE
1151: IF EstDtlTab(i).line_category_code <> 'RETURN'
1152: AND EstDtlTab(i).line_category_code <> 'ORDER' THEN
1153: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_CAT_CODE');
1154: FND_MSG_PUB.Add;
1155: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);

Line 1165: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_QTY');

1161: END IF;
1162:
1163: IF EstDtlTab(i).quantity_required is null
1164: OR EstDtlTab(i).quantity_required = 0 THEN
1165: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_QTY');
1166: FND_MSG_PUB.Add;
1167: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);

Line 1188: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_OMTYPES');

1184: END IF;
1185:
1186: EXCEPTION
1187: WHEN L_OM_ERROR THEN
1188: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_OMTYPES');
1189: FND_MSG_PUB.Add;
1190: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1191: p_count => x_msg_count,
1192: p_data => x_msg_data);

Line 1363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_PO');

1359: ELSIF EstDtlTab(i).purchase_order_num <> '-999' AND
1360: l_purchase_order_num <> EstDtlTab(i).purchase_order_num THEN
1361:
1362: ROLLBACK TO CS_Charge_Create_Order_PVT;
1363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_PO');
1364: FND_MESSAGE.Set_Token('PURCHASE_ORDER_NUM',l_purchase_order_num);
1365: FND_MSG_PUB.Add; -- 5455064
1366: -- APP_EXCEPTION.Raise_Exception;
1367: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

Line 1364: FND_MESSAGE.Set_Token('PURCHASE_ORDER_NUM',l_purchase_order_num);

1360: l_purchase_order_num <> EstDtlTab(i).purchase_order_num THEN
1361:
1362: ROLLBACK TO CS_Charge_Create_Order_PVT;
1363: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_PO');
1364: FND_MESSAGE.Set_Token('PURCHASE_ORDER_NUM',l_purchase_order_num);
1365: FND_MSG_PUB.Add; -- 5455064
1366: -- APP_EXCEPTION.Raise_Exception;
1367: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1368: p_count => x_msg_count,

Line 1554: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');

1550: END IF;
1551:
1552: IF l_inv_item_id = NULL THEN */
1553: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1554: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1555: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1556: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1557: FND_MSG_PUB.Add;
1558: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

Line 1555: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);

1551:
1552: IF l_inv_item_id = NULL THEN */
1553: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1554: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1555: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1556: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1557: FND_MSG_PUB.Add;
1558: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1559: p_count => x_msg_count,

Line 1556: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');

1552: IF l_inv_item_id = NULL THEN */
1553: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1554: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1555: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1556: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1557: FND_MSG_PUB.Add;
1558: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);

Line 1694: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_PER_MODIF_SUPP');

1690: AND l.list_line_id = l_modifier_line_id;
1691:
1692: If l_arith_operator Not In ('%','AMT') Then
1693: --Only amount-based and percent-based modifiers are supported as default modifier in Charges.
1694: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_PER_MODIF_SUPP');
1695: FND_MSG_PUB.Add;
1696: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1697: p_count => x_msg_count,
1698: p_data => x_msg_data);

Line 1708: FND_MESSAGE.Set_Name('CS','CS_CHG_SAME_CURR_REQD');

1704: If NVL(l_currency_code,'@~') <> EstDtlTab(i).currency_code
1705: And l_arith_operator = 'AMT'
1706: Then
1707: --Default modifier currency must be the same as charge line currency.
1708: FND_MESSAGE.Set_Name('CS','CS_CHG_SAME_CURR_REQD');
1709: FND_MSG_PUB.Add;
1710: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1711: p_count => x_msg_count,
1712: p_data => x_msg_data);

Line 1721: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');

1717: l_before_warranty_cost := (nvl(EstDtlTab(i).selling_price, 0) * EstDtlTab(i).quantity_required );
1718: -- Added according to PMs proposed bug fix
1719: IF (EstDtlTab(i).list_price = 0 AND
1720: l_before_warranty_cost <> 0 AND l_arith_operator <> 'AMT') THEN
1721: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');
1722: FND_MSG_PUB.Add;
1723: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1724: p_count => x_msg_count,
1725: p_data => x_msg_data);

Line 1735: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');

1731: If l_arith_operator = 'AMT' Then
1732: l_operand := -1 * nvl (EstDtlTab(i).after_warranty_cost, 0);
1733: Else
1734: --Default modifier must be amount-based in order to support overrides of zero priced items.
1735: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');
1736: FND_MSG_PUB.Add;
1737: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1738: p_count => x_msg_count,
1739: p_data => x_msg_data);

Line 1866: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_TOO_MANY_SOURCES');

1862: AND c.source_transaction_type =
1863: decode(EstDtlTab(i).line_category_code,'RETURN', 'RMA_RECEIPT', 'ORDER', 'OM_SHIPMENT',null);
1864: EXCEPTION
1865: WHEN TOO_MANY_ROWS THEN
1866: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_TOO_MANY_SOURCES');
1867: FND_MSG_PUB.Add;
1868: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1869: p_count => x_msg_count,
1870: p_data => x_msg_data);

Line 1876: /* FND_MESSAGE.Set_Name('CS','CS_CHG_IB_NO_VALID_TXN_TYPE');

1872:
1873: WHEN NO_DATA_FOUND THEN
1874: l_update_ib_flag := 'N';
1875: /* Commenting out this exception as part of IB changes */
1876: /* FND_MESSAGE.Set_Name('CS','CS_CHG_IB_NO_VALID_TXN_TYPE');
1877: FND_MSG_PUB.Add;
1878: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);

Line 1901: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');

1897: where instance_id = EstDtlTab(i).customer_product_id;
1898: EXCEPTION
1899: -- Serial_number is available only if the instance is serialized
1900: /* WHEN NO_DATA_FOUND THEN
1901: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1902: FND_MSG_PUB.Add;
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
1904: WHEN OTHERS THEN
1905: RAISE;

Line 1917: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');

1913: l_lot_serial_tbl(1).operation := 'CREATE';
1914: l_lot_serial_tbl(1).line_index := j;
1915: END IF;
1916: /* ELSE
1917: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1918: FND_MSG_PUB.Add;
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
1920: END IF;
1921: END IF;

Line 1932: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');

1928: l_non_src_reference_reqd = 'Y') AND
1929: l_update_ib_flag = 'Y' AND
1930: EstDtlTab(i).customer_product_id IS NULL THEN
1931:
1932: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
1933: FND_MSG_PUB.Add;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: END IF;
1936:

Line 1971: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_RET_TXN_DATA');

1967: (EstDtlTab(i).Customer_product_id is not null) THEN
1968: csi_txn_line_detail_tbl(1).instance_id := EstDtlTab(i).Customer_Product_Id;
1969: csi_txn_line_detail_tbl(1).instance_exists_flag := 'Y';
1970: ELSE
1971: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_RET_TXN_DATA');
1972: FND_MSG_PUB.Add;
1973: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1974: p_count => x_msg_count,
1975: p_data => x_msg_data);

Line 2049: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_SHP_TXN_DATA');

2045:
2046: /* Do not raise any error message if instance is missing.New 11.5.10 changes */
2047:
2048: /* ELSE
2049: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_SHP_TXN_DATA');
2050: FND_MSG_PUB.Add;
2051: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2052: p_count => x_msg_count,
2053: p_data => x_msg_data);

Line 2110: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');

2106: RAISE l_IB_ERROR;
2107: END IF;
2108: EXCEPTION
2109: WHEN OTHERS THEN
2110: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2111: FND_MSG_PUB.Add;
2112: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2113: p_count => x_msg_count,
2114: p_data => x_msg_data);

Line 2130: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');

2126: WHERE cust_account_id = EstDtlTab(i).account_id);
2127:
2128: EXCEPTION
2129: WHEN OTHERS THEN
2130: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');
2131: FND_MSG_PUB.Add;
2132: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);

Line 2146: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');

2142: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2143: csi_txn_party_detail_tbl(1).contact_flag := 'N';
2144: csi_txn_pty_acct_detail_tbl.delete;
2145: ELSE
2146: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');
2147: FND_MSG_PUB.Add;
2148: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2149: p_count => x_msg_count,
2150: p_data => x_msg_data);

Line 2169: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');

2165: RAISE l_IB_ERROR;
2166: END IF;
2167: EXCEPTION
2168: WHEN OTHERS THEN
2169: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2170: FND_MSG_PUB.Add;
2171: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2172: p_count => x_msg_count,
2173: p_data => x_msg_data);

Line 2191: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');

2187: END IF;
2188:
2189: EXCEPTION
2190: WHEN OTHERS THEN
2191: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');
2192: FND_MSG_PUB.Add;
2193: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2194: p_count => x_msg_count,
2195: p_data => x_msg_data);

Line 2624: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;

2620:
2621: IF (MO_GLOBAL.check_valid_org(l_org_id) ='N')
2622: THEN
2623: FND_MSG_PUB.initialize;
2624: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;
2625: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;
2626: FND_MSG_PUB.Add ;
2627: raise FND_API.G_EXC_ERROR ;
2628: END IF;

Line 2625: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;

2621: IF (MO_GLOBAL.check_valid_org(l_org_id) ='N')
2622: THEN
2623: FND_MSG_PUB.initialize;
2624: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;
2625: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;
2626: FND_MSG_PUB.Add ;
2627: raise FND_API.G_EXC_ERROR ;
2628: END IF;
2629:

Line 2708: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ORD_NUM_RETURNED');

2704: -- moved this to elsif below.
2705: -- X_ORDER_HEADER_ID := X_ORDER_HEADER_REC.ORDER_HEADER_ID;
2706:
2707: IF X_ORDER_HEADER_REC.ORDER_HEADER_ID IS NULL THEN
2708: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ORD_NUM_RETURNED');
2709: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
2710: FND_MSG_PUB.Add;
2711: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2712: p_count => x_msg_count,

Line 2709: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);

2705: -- X_ORDER_HEADER_ID := X_ORDER_HEADER_REC.ORDER_HEADER_ID;
2706:
2707: IF X_ORDER_HEADER_REC.ORDER_HEADER_ID IS NULL THEN
2708: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ORD_NUM_RETURNED');
2709: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
2710: FND_MSG_PUB.Add;
2711: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2712: p_count => x_msg_count,
2713: p_data => x_msg_data);

Line 2817: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_CREATED');

2813: WHERE party_id = p_party_id
2814: AND status = 'A';
2815: EXCEPTION
2816: WHEN NO_DATA_FOUND THEN
2817: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_CREATED');
2818: FND_MSG_PUB.Add;
2819:
2820: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2821: p_count => x_msg_count,

Line 2842: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');

2838: RAISE l_IB_ERROR;
2839: END IF;
2840: EXCEPTION
2841: WHEN OTHERS THEN
2842: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2843: FND_MSG_PUB.Add;
2844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2845: END;
2846:

Line 2864: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');

2860: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2861: csi_txn_party_detail_tbl(1).contact_flag := 'N';
2862: csi_txn_pty_acct_detail_tbl.delete;
2863: ELSE
2864: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');
2865: FND_MSG_PUB.Add;
2866: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2867: p_count => x_msg_count,
2868: p_data => x_msg_data);

Line 2958: -- FND_MESSAGE.Set_Encoded(xi_msg_data);

2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2955:
2956: END IF;
2957:
2958: -- FND_MESSAGE.Set_Encoded(xi_msg_data);
2959: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2960:
2961:
2962: END IF; -- if billing flag = 'M'

Line 3031: FND_MESSAGE.Set_Name('CS','CS_CHG_OM_ERR_WITH_NO_MSG');

3027: END IF; -- end of message count
3028:
3029: IF x_msg_count = 0 THEN
3030: -- dbms_output.put_line('Before set_name');
3031: FND_MESSAGE.Set_Name('CS','CS_CHG_OM_ERR_WITH_NO_MSG');
3032: FND_MSG_PUB.Add;
3033: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3034: p_count => x_msg_count,
3035: p_data => x_msg_data);

Line 3040: -- FND_MESSAGE.Set_Encoded(x_msg_data);

3036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3037:
3038: END IF;
3039:
3040: -- FND_MESSAGE.Set_Encoded(x_msg_data);
3041: -- FND_MSG_PUB.Add;
3042: -- RAISE FND_API.G_EXC_ERROR;
3043:
3044: END IF;

Line 3050: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');

3046: END LOOP;
3047:
3048: -- If no records are been submitted to OM, return a message.
3049: IF l_record_found = 'N' THEN
3050: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3054: FND_MSG_PUB.Add;

Line 3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);

3047:
3048: -- If no records are been submitted to OM, return a message.
3049: IF l_record_found = 'N' THEN
3050: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3054: FND_MSG_PUB.Add;
3055: RAISE FND_API.G_EXC_ERROR;

Line 3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);

3048: -- If no records are been submitted to OM, return a message.
3049: IF l_record_found = 'N' THEN
3050: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3054: FND_MSG_PUB.Add;
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;

Line 3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);

3049: IF l_record_found = 'N' THEN
3050: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3051: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3052: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3053: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3054: FND_MSG_PUB.Add;
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:

Line 3079: FND_MESSAGE.Set_Name('CS','CS_CH_SUBMIT_IN_PROCESS');

3075: -- This exception is for SR level
3076: --
3077: --7117301
3078: WHEN RESOURCE_BUSY THEN
3079: FND_MESSAGE.Set_Name('CS','CS_CH_SUBMIT_IN_PROCESS');
3080: FND_MSG_PUB.Add;
3081: RAISE FND_API.G_EXC_ERROR;
3082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3083: --7117301

Line 3108: FND_MESSAGE.Set_Encoded(x_msg_data);

3104: p_submit_restriction_message => NULL,
3105: p_submit_error_message => x_msg_data,
3106: p_submit_from_system => p_submit_from_system);
3107:
3108: FND_MESSAGE.Set_Encoded(x_msg_data);
3109: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111:
3112: WHEN OTHERS THEN

Line 3114: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');

3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111:
3112: WHEN OTHERS THEN
3113: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3114: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3115: fnd_message.set_token('ROUTINE',l_api_name_full);
3116: fnd_message.set_token('REASON',g_oraerrmsg);
3117: FND_MSG_PUB.Add;
3118: IF FND_MSG_PUB.Check_Msg_Level

Line 3115: fnd_message.set_token('ROUTINE',l_api_name_full);

3111:
3112: WHEN OTHERS THEN
3113: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3114: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3115: fnd_message.set_token('ROUTINE',l_api_name_full);
3116: fnd_message.set_token('REASON',g_oraerrmsg);
3117: FND_MSG_PUB.Add;
3118: IF FND_MSG_PUB.Check_Msg_Level
3119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3116: fnd_message.set_token('REASON',g_oraerrmsg);

3112: WHEN OTHERS THEN
3113: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3114: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3115: fnd_message.set_token('ROUTINE',l_api_name_full);
3116: fnd_message.set_token('REASON',g_oraerrmsg);
3117: FND_MSG_PUB.Add;
3118: IF FND_MSG_PUB.Check_Msg_Level
3119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3120: THEN

Line 3141: FND_MESSAGE.Set_Encoded(x_msg_data);

3137: p_submit_restriction_message => NULL,
3138: p_submit_error_message => x_msg_data,
3139: p_submit_from_system => p_submit_from_system);
3140:
3141: FND_MESSAGE.Set_Encoded(x_msg_data);
3142:
3143:
3144: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;