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:
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:
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:
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:
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:
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:
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 388: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');

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

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

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

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

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

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

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

Line 755: L_API_ERROR_WITH_FND_MESSAGE EXCEPTION;

751:
752: -- Added for bug:5408354
753: l_arith_operator qp_list_lines.arithmetic_operator%type;
754: l_currency_code qp_list_headers.currency_code%type;
755: L_API_ERROR_WITH_FND_MESSAGE EXCEPTION;
756: --
757: --
758: -- Added this to get account_id after submitting an order to OM.
759: --

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

920: , L_LOG_MODULE || 'get_request_info_end'
921: , 'invalid input parameter :' || 'p_incident_id'
922: );
923: END IF;
924: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
925: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
926: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
927: FND_MSG_PUB.Add;
928: RAISE FND_API.G_EXC_ERROR;

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

921: , 'invalid input parameter :' || 'p_incident_id'
922: );
923: END IF;
924: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
925: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
926: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
927: FND_MSG_PUB.Add;
928: RAISE FND_API.G_EXC_ERROR;
929: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

922: );
923: END IF;
924: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
925: FND_MESSAGE.Set_Token('PARAM','p_incident_id');
926: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
927: FND_MSG_PUB.Add;
928: RAISE FND_API.G_EXC_ERROR;
929: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;

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

935: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
936: , 'p_party_id'
937: );
938: END IF;
939: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
940: FND_MESSAGE.Set_Token('PARAM','p_party_id');
941: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
942: FND_MSG_PUB.Add;
943: RAISE FND_API.G_EXC_ERROR;

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

936: , 'p_party_id'
937: );
938: END IF;
939: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
940: FND_MESSAGE.Set_Token('PARAM','p_party_id');
941: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
942: FND_MSG_PUB.Add;
943: RAISE FND_API.G_EXC_ERROR;
944: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

937: );
938: END IF;
939: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
940: FND_MESSAGE.Set_Token('PARAM','p_party_id');
941: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
942: FND_MSG_PUB.Add;
943: RAISE FND_API.G_EXC_ERROR;
944: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;

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

954: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
955: , 'p_book_order_flag'
956: );
957: END IF;
958: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
959: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
960: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_ERROR;

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

955: , 'p_book_order_flag'
956: );
957: END IF;
958: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
959: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
960: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_ERROR;
963: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

956: );
957: END IF;
958: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
959: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
960: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_ERROR;
963: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END IF;

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

970: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
971: , 'p_submit_source'
972: );
973: END IF;
974: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
975: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
976: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
977: FND_MSG_PUB.Add;
978: RAISE FND_API.G_EXC_ERROR;

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

971: , 'p_submit_source'
972: );
973: END IF;
974: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
975: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
976: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
977: FND_MSG_PUB.Add;
978: RAISE FND_API.G_EXC_ERROR;
979: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

972: );
973: END IF;
974: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
975: FND_MESSAGE.Set_Token('PARAM','p_submit_source');
976: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
977: FND_MSG_PUB.Add;
978: RAISE FND_API.G_EXC_ERROR;
979: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;

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

994: FND_LOG.String
995: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
996: );
997: END IF;
998: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
999: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1000: FND_MSG_PUB.Add;
1001: RAISE FND_API.G_EXC_ERROR;
1002: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

995: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
996: );
997: END IF;
998: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
999: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1000: FND_MSG_PUB.Add;
1001: RAISE FND_API.G_EXC_ERROR;
1002: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003:

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

1006: Open Get_party_number;
1007: Fetch Get_party_number into l_party_number;
1008: Close Get_party_number;
1009:
1010: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');
1011: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);
1012: FND_MSG_PUB.Add;
1013: RAISE FND_API.G_EXC_ERROR;
1014: End if;

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

1007: Fetch Get_party_number into l_party_number;
1008: Close Get_party_number;
1009:
1010: FND_MESSAGE.Set_Name('CS','CS_SR_NO_VALID_ACCT');
1011: FND_MESSAGE.Set_Token('SOLD_TO_PARTY',l_party_number);
1012: FND_MSG_PUB.Add;
1013: RAISE FND_API.G_EXC_ERROR;
1014: End if;
1015: END IF;

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

1033: CLOSE Get_Modifier_Header;
1034: END IF;
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_DEFAULT_MODIFIER');
1038: FND_MSG_PUB.Add;
1039: RAISE FND_API.G_EXC_ERROR;
1040: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END;

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

1067: END IF;
1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1072: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1073: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;

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

1068:
1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1072: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1073: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
1072: FND_MESSAGE.Set_Token('PARAM','p_book_order_flag');
1073: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077:

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

1238: --
1239: -- VALIDATE CATEGORY CODE
1240: IF EstDtlTab(i).line_category_code <> 'RETURN'
1241: AND EstDtlTab(i).line_category_code <> 'ORDER' THEN
1242: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_CAT_CODE');
1243: FND_MSG_PUB.Add;
1244: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1245: p_count => x_msg_count,
1246: p_data => x_msg_data);

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

1250: END IF;
1251:
1252: IF EstDtlTab(i).quantity_required is null
1253: OR EstDtlTab(i).quantity_required = 0 THEN
1254: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_QTY');
1255: FND_MSG_PUB.Add;
1256: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1257: p_count => x_msg_count,
1258: p_data => x_msg_data);

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

1273: END IF;
1274:
1275: EXCEPTION
1276: WHEN L_OM_ERROR THEN
1277: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_OMTYPES');
1278: FND_MSG_PUB.Add;
1279: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1280: p_count => x_msg_count,
1281: p_data => x_msg_data);

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

1473: ELSIF EstDtlTab(i).purchase_order_num <> '-999' AND
1474: l_purchase_order_num <> EstDtlTab(i).purchase_order_num THEN
1475:
1476: ROLLBACK TO CS_Charge_Create_Order_PVT;
1477: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_PO');
1478: FND_MESSAGE.Set_Token('PURCHASE_ORDER_NUM',l_purchase_order_num);
1479: FND_MSG_PUB.Add; -- 5455064
1480: -- APP_EXCEPTION.Raise_Exception;
1481: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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

1474: l_purchase_order_num <> EstDtlTab(i).purchase_order_num THEN
1475:
1476: ROLLBACK TO CS_Charge_Create_Order_PVT;
1477: FND_MESSAGE.Set_Name('CS', 'CS_CHG_INVALID_PO');
1478: FND_MESSAGE.Set_Token('PURCHASE_ORDER_NUM',l_purchase_order_num);
1479: FND_MSG_PUB.Add; -- 5455064
1480: -- APP_EXCEPTION.Raise_Exception;
1481: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1482: p_count => x_msg_count,

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

1676: END IF;
1677:
1678: IF l_inv_item_id = NULL THEN */
1679: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1680: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1681: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1682: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1683: FND_MSG_PUB.Add;
1684: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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

1677:
1678: IF l_inv_item_id = NULL THEN */
1679: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1680: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1681: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1682: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1683: FND_MSG_PUB.Add;
1684: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1685: p_count => x_msg_count,

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

1678: IF l_inv_item_id = NULL THEN */
1679: IF EstDtlTab(i).rollup_item_id IS NULL THEN
1680: --FND_MESSAGE.Set_Name('CS', 'CS_CHG_DEFINE_PROFILE_OPTION');
1681: --FND_MESSAGE.Set_Token('PROFILE_OPTION', l_profile_option);
1682: FND_MESSAGE.Set_Name('CS', 'CS_CHG_BILLING_TYPE_NO_ROLLUP');
1683: FND_MSG_PUB.Add;
1684: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1685: p_count => x_msg_count,
1686: p_data => x_msg_data);

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

1828: AND l.list_line_id = l_modifier_line_id;
1829:
1830: If l_arith_operator Not In ('%','AMT') Then
1831: --Only amount-based and percent-based modifiers are supported as default modifier in Charges.
1832: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_PER_MODIF_SUPP');
1833: FND_MSG_PUB.Add;
1834: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1835: p_count => x_msg_count,
1836: p_data => x_msg_data);

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

1842: If NVL(l_currency_code,'@~') <> EstDtlTab(i).currency_code
1843: And l_arith_operator = 'AMT'
1844: Then
1845: --Default modifier currency must be the same as charge line currency.
1846: FND_MESSAGE.Set_Name('CS','CS_CHG_SAME_CURR_REQD');
1847: FND_MSG_PUB.Add;
1848: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1849: p_count => x_msg_count,
1850: p_data => x_msg_data);

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

1855: l_before_warranty_cost := (nvl(EstDtlTab(i).selling_price, 0) * EstDtlTab(i).quantity_required );
1856: -- Added according to PMs proposed bug fix
1857: IF (EstDtlTab(i).list_price = 0 AND
1858: l_before_warranty_cost <> 0 AND l_arith_operator <> 'AMT') THEN
1859: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');
1860: FND_MSG_PUB.Add;
1861: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1862: p_count => x_msg_count,
1863: p_data => x_msg_data);

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

1869: If l_arith_operator = 'AMT' Then
1870: l_operand := -1 * nvl (EstDtlTab(i).after_warranty_cost, 0);
1871: Else
1872: --Default modifier must be amount-based in order to support overrides of zero priced items.
1873: FND_MESSAGE.Set_Name('CS','CS_CHG_AMT_MODIF_0_PRICE_ITEM');
1874: FND_MSG_PUB.Add;
1875: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
1876: p_count => x_msg_count,
1877: p_data => x_msg_data);

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

2006: AND c.source_transaction_type =
2007: decode(EstDtlTab(i).line_category_code,'RETURN', 'RMA_RECEIPT', 'ORDER', 'OM_SHIPMENT',null);
2008: EXCEPTION
2009: WHEN TOO_MANY_ROWS THEN
2010: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_TOO_MANY_SOURCES');
2011: FND_MSG_PUB.Add;
2012: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2013: p_count => x_msg_count,
2014: p_data => x_msg_data);

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

2016:
2017: WHEN NO_DATA_FOUND THEN
2018: l_update_ib_flag := 'N';
2019: /* Commenting out this exception as part of IB changes */
2020: /* FND_MESSAGE.Set_Name('CS','CS_CHG_IB_NO_VALID_TXN_TYPE');
2021: FND_MSG_PUB.Add;
2022: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2023: p_count => x_msg_count,
2024: p_data => x_msg_data);

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

2043: where instance_id = EstDtlTab(i).customer_product_id;
2044: EXCEPTION
2045: -- Serial_number is available only if the instance is serialized
2046: /* WHEN NO_DATA_FOUND THEN
2047: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
2048: FND_MSG_PUB.Add;
2049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2050: WHEN OTHERS THEN
2051: RAISE;

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

2068: l_lot_serial_tbl(1).line_index := j;
2069: END IF;
2070: -- End Bug 8284773
2071: /* ELSE
2072: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
2073: FND_MSG_PUB.Add;
2074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2075: END IF;
2076: END IF;

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

2083: l_non_src_reference_reqd = 'Y') AND
2084: l_update_ib_flag = 'Y' AND
2085: EstDtlTab(i).customer_product_id IS NULL THEN
2086:
2087: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_MISSING_INSTANCE');
2088: FND_MSG_PUB.Add;
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090: END IF;
2091: --

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

2133: Close get_parent_instance;
2134: End If;
2135: -- End Bug 8203856
2136: ELSE
2137: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_RET_TXN_DATA');
2138: FND_MSG_PUB.Add;
2139: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2140: p_count => x_msg_count,
2141: p_data => x_msg_data);

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

2243:
2244: /* Do not raise any error message if instance is missing.New 11.5.10 changes */
2245:
2246: /* ELSE
2247: FND_MESSAGE.Set_Name('CS','CS_CHG_IB_INVALID_SHP_TXN_DATA');
2248: FND_MSG_PUB.Add;
2249: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2250: p_count => x_msg_count,
2251: p_data => x_msg_data);

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

2347: RAISE l_IB_ERROR;
2348: END IF;
2349: EXCEPTION
2350: WHEN OTHERS THEN
2351: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2352: FND_MSG_PUB.Add;
2353: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2354: p_count => x_msg_count,
2355: p_data => x_msg_data);

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

2441: WHERE cust_account_id = EstDtlTab(i).account_id);
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');
2446: FND_MSG_PUB.Add;
2447: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2448: p_count => x_msg_count,
2449: p_data => x_msg_data);

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

2457: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
2458: csi_txn_party_detail_tbl(1).contact_flag := 'N';*/
2459: csi_txn_pty_acct_detail_tbl.delete;
2460: ELSE
2461: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');
2462: FND_MSG_PUB.Add;
2463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2464: p_count => x_msg_count,
2465: p_data => x_msg_data);

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

2480: RAISE l_IB_ERROR;
2481: END IF;
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
2485: FND_MSG_PUB.Add;
2486: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2487: p_count => x_msg_count,
2488: p_data => x_msg_data);

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

2566: END IF;
2567:
2568: /* EXCEPTION
2569: WHEN OTHERS THEN
2570: FND_MESSAGE.Set_Name('CS','CS_CHG_INSTANCE_NOT_OWN_BY_PTY');
2571: FND_MSG_PUB.Add;
2572: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2573: p_count => x_msg_count,
2574: p_data => x_msg_data);

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

3026:
3027: IF (MO_GLOBAL.check_valid_org(l_org_id) ='N')
3028: THEN
3029: FND_MSG_PUB.initialize;
3030: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;
3031: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;
3032: FND_MSG_PUB.Add ;
3033: raise FND_API.G_EXC_ERROR ;
3034: END IF;

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

3027: IF (MO_GLOBAL.check_valid_org(l_org_id) ='N')
3028: THEN
3029: FND_MSG_PUB.initialize;
3030: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_MISMATCH') ;
3031: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full) ;
3032: FND_MSG_PUB.Add ;
3033: raise FND_API.G_EXC_ERROR ;
3034: END IF;
3035:

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

3276: -- moved this to elsif below.
3277: -- X_ORDER_HEADER_ID := X_ORDER_HEADER_REC.ORDER_HEADER_ID;
3278:
3279: IF X_ORDER_HEADER_REC.ORDER_HEADER_ID IS NULL THEN
3280: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ORD_NUM_RETURNED');
3281: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
3282: FND_MSG_PUB.Add;
3283: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3284: p_count => x_msg_count,

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

3277: -- X_ORDER_HEADER_ID := X_ORDER_HEADER_REC.ORDER_HEADER_ID;
3278:
3279: IF X_ORDER_HEADER_REC.ORDER_HEADER_ID IS NULL THEN
3280: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ORD_NUM_RETURNED');
3281: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
3282: FND_MSG_PUB.Add;
3283: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3284: p_count => x_msg_count,
3285: p_data => x_msg_data);

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

3385: WHERE party_id = p_party_id
3386: AND status = 'A';
3387: EXCEPTION
3388: WHEN NO_DATA_FOUND THEN
3389: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_CREATED');
3390: FND_MSG_PUB.Add;
3391:
3392: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3393: p_count => x_msg_count,

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

3410: RAISE l_IB_ERROR;
3411: END IF;
3412: EXCEPTION
3413: WHEN OTHERS THEN
3414: FND_MESSAGE.Set_Name('CS','CS_CHG_INTERNAL_PARTY_NOT_DEF');
3415: FND_MSG_PUB.Add;
3416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3417: END;
3418:

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

3432: csi_txn_party_detail_tbl(1).txn_line_details_index := 1;
3433: csi_txn_party_detail_tbl(1).contact_flag := 'N';
3434: csi_txn_pty_acct_detail_tbl.delete;
3435: ELSE
3436: FND_MESSAGE.Set_Name('CS','CS_CHG_RTN_TO_EXT_PTY_NOT_SUP');
3437: FND_MSG_PUB.Add;
3438: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3439: p_count => x_msg_count,
3440: p_data => x_msg_data);

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

3531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3532:
3533: END IF;
3534:
3535: -- FND_MESSAGE.Set_Encoded(xi_msg_data);
3536: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3537:
3538:
3539: END IF; -- if billing flag = 'M'

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

3623: END IF; -- end of message count
3624:
3625: IF x_msg_count = 0 THEN
3626: -- dbms_output.put_line('Before set_name');
3627: FND_MESSAGE.Set_Name('CS','CS_CHG_OM_ERR_WITH_NO_MSG');
3628: FND_MSG_PUB.Add;
3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3630: p_count => x_msg_count,
3631: p_data => x_msg_data);

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

3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633:
3634: END IF;
3635:
3636: -- FND_MESSAGE.Set_Encoded(x_msg_data);
3637: -- FND_MSG_PUB.Add;
3638: -- RAISE FND_API.G_EXC_ERROR;
3639:
3640: END IF;

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

3644:
3645:
3646: -- If no records are been submitted to OM, return a message.
3647: IF l_record_found = 'N' THEN
3648: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3649: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3650: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3651: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3652: FND_MSG_PUB.Add;

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

3645:
3646: -- If no records are been submitted to OM, return a message.
3647: IF l_record_found = 'N' THEN
3648: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3649: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3650: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3651: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3652: FND_MSG_PUB.Add;
3653: RAISE FND_API.G_EXC_ERROR;

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

3646: -- If no records are been submitted to OM, return a message.
3647: IF l_record_found = 'N' THEN
3648: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3649: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3650: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3651: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3652: FND_MSG_PUB.Add;
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;

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

3647: IF l_record_found = 'N' THEN
3648: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_CHARGES_SUBMITTED');
3649: --FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_incident_id, TRUE);
3650: --FND_MESSAGE.SET_TOKEN('PARTY_ID', p_party_id, TRUE);
3651: --FND_MESSAGE.SET_TOKEN('ACCOUNT_ID', p_account_id, TRUE);
3652: FND_MSG_PUB.Add;
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;
3655:

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

3673: -- This exception is for SR level
3674: --
3675: --7117301
3676: WHEN RESOURCE_BUSY THEN
3677: FND_MESSAGE.Set_Name('CS','CS_CH_SUBMIT_IN_PROCESS');
3678: FND_MSG_PUB.Add;
3679: RAISE FND_API.G_EXC_ERROR;
3680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3681: --7117301

Line 3706: FND_MESSAGE.Set_Encoded(x_msg_data);

3702: p_submit_restriction_message => NULL,
3703: p_submit_error_message => x_msg_data,
3704: p_submit_from_system => p_submit_from_system);
3705:
3706: FND_MESSAGE.Set_Encoded(x_msg_data);
3707: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3709:
3710: WHEN OTHERS THEN

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

3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3709:
3710: WHEN OTHERS THEN
3711: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3712: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3713: fnd_message.set_token('ROUTINE',l_api_name_full);
3714: fnd_message.set_token('REASON',g_oraerrmsg);
3715: FND_MSG_PUB.Add;
3716: IF FND_MSG_PUB.Check_Msg_Level

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

3709:
3710: WHEN OTHERS THEN
3711: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3712: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3713: fnd_message.set_token('ROUTINE',l_api_name_full);
3714: fnd_message.set_token('REASON',g_oraerrmsg);
3715: FND_MSG_PUB.Add;
3716: IF FND_MSG_PUB.Check_Msg_Level
3717: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

3710: WHEN OTHERS THEN
3711: g_oraerrmsg := substrb(sqlerrm,1,G_MAXERRLEN);
3712: fnd_message.set_name('CS','CS_CHG_SUBMIT_ORDER_FAILED');
3713: fnd_message.set_token('ROUTINE',l_api_name_full);
3714: fnd_message.set_token('REASON',g_oraerrmsg);
3715: FND_MSG_PUB.Add;
3716: IF FND_MSG_PUB.Check_Msg_Level
3717: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3718: THEN

Line 3739: FND_MESSAGE.Set_Encoded(x_msg_data);

3735: p_submit_restriction_message => NULL,
3736: p_submit_error_message => x_msg_data,
3737: p_submit_from_system => p_submit_from_system);
3738:
3739: FND_MESSAGE.Set_Encoded(x_msg_data);
3740:
3741:
3742: --ROLLBACK TO CS_Charge_Create_Order_PVT; --7117301
3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;