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.CS_CHARGE_CREATE_ORDER_PVT dependencies on FND_MSG_PUB

Line 172: FND_MSG_PUB.Add;

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;
176: EXCEPTION

Line 263: FND_MSG_PUB.Add;

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
267: close acct_site_csr;

Line 275: FND_MSG_PUB.Add;

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
279: close acct_site_csr;

Line 299: FND_MSG_PUB.Add;

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
303: close acct_site_use_csr;

Line 312: FND_MSG_PUB.Add;

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
316: close acct_site_use_csr;

Line 327: FND_MSG_PUB.Count_And_Get

323: EXCEPTION
324: WHEN FND_API.G_EXC_ERROR THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: FND_MSG_PUB.Count_And_Get
328: (p_count => x_msg_count,
329: p_data => x_msg_data);
330:
331:

Line 392: FND_MSG_PUB.add;

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:
396:

Line 855: FND_MSG_PUB.initialize;

851: END IF;
852:
853: -- Initialize message list if p_init_msg_list is set to TRUE.
854: IF FND_API.to_Boolean( p_init_msg_list ) THEN
855: FND_MSG_PUB.initialize;
856: END IF;
857:
858: -- Initialize API return status to success
859: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 927: FND_MSG_PUB.Add;

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;
931: IF (p_party_id is null) THEN

Line 942: FND_MSG_PUB.Add;

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;
946:

Line 961: FND_MSG_PUB.Add;

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;
965:

Line 977: FND_MSG_PUB.Add;

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;
981: --- End of 11.5.10 parameter validations

Line 1000: FND_MSG_PUB.Add;

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:
1004: ELSIF l_acct_no = 0 then

Line 1012: FND_MSG_PUB.Add;

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;
1016:

Line 1038: FND_MSG_PUB.Add;

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;
1042:

Line 1074: FND_MSG_PUB.Add;

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:
1078: END;

Line 1243: FND_MSG_PUB.Add;

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);
1247:

Line 1244: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1247:
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1255: FND_MSG_PUB.Add;

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);
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1256: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;

Line 1278: FND_MSG_PUB.Add;

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);
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1279: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END;

Line 1479: FND_MSG_PUB.Add; -- 5455064

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,
1483: p_data => x_msg_data);

Line 1481: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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,
1483: p_data => x_msg_data);
1484:
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1683: FND_MSG_PUB.Add;

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);
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1684: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1688:

Line 1833: FND_MSG_PUB.Add;

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);
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1834: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838: End If;

Line 1847: FND_MSG_PUB.Add;

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);
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1848: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852:

Line 1860: FND_MSG_PUB.Add;

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);
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1861: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;

Line 1874: FND_MSG_PUB.Add;

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);
1878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1875: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
1878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1879: End If;

Line 2011: FND_MSG_PUB.Add;

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);
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2012: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016:

Line 2021: FND_MSG_PUB.Add;

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);
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

Line 2022: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2026: END;

Line 2048: FND_MSG_PUB.Add;

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;
2052: END;

Line 2073: FND_MSG_PUB.Add;

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;
2077:

Line 2088: FND_MSG_PUB.Add;

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: --
2092: -- Clear IB structures

Line 2138: FND_MSG_PUB.Add;

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);
2142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2139: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2143: -- null;

Line 2248: FND_MSG_PUB.Add;

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);
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */

Line 2249: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2253: END IF;

Line 2352: FND_MSG_PUB.Add;

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);
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2353: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2357: END;

Line 2446: FND_MSG_PUB.Add;

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);
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2447: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END;

Line 2462: FND_MSG_PUB.Add;

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);
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: END IF; -- IF l_src_change_owner_to_code = 'I'

Line 2485: FND_MSG_PUB.Add;

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);
2489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2486: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2490: END;

Line 2571: FND_MSG_PUB.Add;

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);
2575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/

Line 2572: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
2575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
2576: END;

Line 2983: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2979: -- dbms_output.put_line('In the validate_acct_site_call');
2980: -- dbms_output.put_line('Return_Status' || x_return_status);
2981:
2982: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2983: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2984: p_count => x_msg_count,
2985: p_data => x_msg_data);
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: END IF;

Line 3003: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

2999: -- dbms_output.put_line('In the validate_acct_site_call2');
3000: -- dbms_output.put_line('Return_Status2' || x_return_status);
3001:
3002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3003: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3004: p_count => x_msg_count,
3005: p_data => x_msg_data);
3006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3007: END IF;

Line 3029: FND_MSG_PUB.initialize;

3025: If fnd_profile.value('CS_SR_RESTRICT_OPERATING_UNIT')='Y' then -- Bug 10375246
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 ;

Line 3032: FND_MSG_PUB.Add ;

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:
3036: End if;

Line 3282: FND_MSG_PUB.Add;

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);
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3283: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287:

Line 3390: FND_MSG_PUB.Add;

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,
3394: p_data => x_msg_data);

Line 3392: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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,
3394: p_data => x_msg_data);
3395: END;
3396: --

Line 3415: FND_MSG_PUB.Add;

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:
3419: SELECT instance_party_id

Line 3437: FND_MSG_PUB.Add;

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);
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3438: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
3441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3442:

Line 3523: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3519: END IF; -- comms_nl_trackable_flag
3520:
3521: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3522:
3523: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3524: p_count => x_msg_count,
3525: p_data => x_msg_data);
3526:
3527: -- dbms_output.put_line('message status' || x_return_status);

Line 3589: -- FND_MSG_PUB.initialize;

3585:
3586: IF x_msg_count > 0 THEN
3587: -- Get next message
3588:
3589: -- FND_MSG_PUB.initialize;
3590: /* FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3591: p_count => x_msg_count,
3592: p_data => x_msg_data); */
3593:

Line 3590: /* FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3586: IF x_msg_count > 0 THEN
3587: -- Get next message
3588:
3589: -- FND_MSG_PUB.initialize;
3590: /* FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3591: p_count => x_msg_count,
3592: p_data => x_msg_data); */
3593:
3594: for k in 1..x_msg_count loop

Line 3595: FND_MSG_PUB.get(p_encoded => 'F',

3591: p_count => x_msg_count,
3592: p_data => x_msg_data); */
3593:
3594: for k in 1..x_msg_count loop
3595: FND_MSG_PUB.get(p_encoded => 'F',
3596: p_data=>x_msg_data,
3597: p_msg_index_out=>l_dummy);
3598: end loop;
3599:

Line 3603: FND_MSG_PUB.get(p_encoded => 'F',

3599:
3600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3601:
3602: /* for k in 1..x_msg_count loop
3603: FND_MSG_PUB.get(p_encoded => 'F',
3604: p_data=>x_msg_data,
3605: p_msg_index_out=>l_dummy);
3606:
3607: -- changes for 11.5.10

Line 3628: FND_MSG_PUB.Add;

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);
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3629: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

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);
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3633:

Line 3637: -- FND_MSG_PUB.Add;

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;
3641:

Line 3652: FND_MSG_PUB.Add;

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:
3656: --

Line 3666: FND_MSG_PUB.Count_And_Get

3662: COMMIT WORK;
3663: END IF;
3664:
3665: -- Standard call to get message count and if count is 1, get message info.
3666: FND_MSG_PUB.Count_And_Get
3667: ( p_count => x_msg_count,
3668: p_data => x_msg_data
3669: );
3670:

Line 3678: FND_MSG_PUB.Add;

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
3682: WHEN FND_API.G_EXC_ERROR THEN

Line 3685: FND_MSG_PUB.Count_And_Get

3681: --7117301
3682: WHEN FND_API.G_EXC_ERROR THEN
3683: ROLLBACK TO CS_Charge_Create_Order_PVT;
3684: x_return_status := FND_API.G_RET_STS_ERROR;
3685: FND_MSG_PUB.Count_And_Get
3686: ( p_count => x_msg_count,
3687: p_data => x_msg_data
3688: );
3689:

Line 3715: FND_MSG_PUB.Add;

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
3719: FND_MSG_PUB.Add_Exc_Msg

Line 3716: IF FND_MSG_PUB.Check_Msg_Level

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
3719: FND_MSG_PUB.Add_Exc_Msg
3720: ( G_PKG_NAME,

Line 3717: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
3719: FND_MSG_PUB.Add_Exc_Msg
3720: ( G_PKG_NAME,
3721: l_api_name

Line 3719: FND_MSG_PUB.Add_Exc_Msg

3715: FND_MSG_PUB.Add;
3716: IF FND_MSG_PUB.Check_Msg_Level
3717: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3718: THEN
3719: FND_MSG_PUB.Add_Exc_Msg
3720: ( G_PKG_NAME,
3721: l_api_name
3722: );
3723: END IF;

Line 3725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',

3721: l_api_name
3722: );
3723: END IF;
3724:
3725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3726: p_count => x_msg_count,
3727: p_data => x_msg_data);
3728:
3729: --