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 390: FND_MSG_PUB.add;

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: --
394: -- End of Update_Errors

Line 783: FND_MSG_PUB.initialize;

779: END IF;
780:
781: -- Initialize message list if p_init_msg_list is set to TRUE.
782: IF FND_API.to_Boolean( p_init_msg_list ) THEN
783: FND_MSG_PUB.initialize;
784: END IF;
785:
786: -- Initialize API return status to success
787: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 856: FND_MSG_PUB.Add;

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

Line 871: FND_MSG_PUB.Add;

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

Line 890: FND_MSG_PUB.Add;

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

Line 906: FND_MSG_PUB.Add;

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

Line 929: FND_MSG_PUB.Add;

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

Line 941: FND_MSG_PUB.Add;

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

Line 967: FND_MSG_PUB.Add;

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

Line 1003: FND_MSG_PUB.Add;

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

Line 1154: FND_MSG_PUB.Add;

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

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

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

Line 1166: FND_MSG_PUB.Add;

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

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

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

Line 1189: FND_MSG_PUB.Add;

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

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

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

Line 1365: FND_MSG_PUB.Add; -- 5455064

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

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

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,
1369: p_data => x_msg_data);
1370:
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1557: FND_MSG_PUB.Add;

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

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

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

Line 1695: FND_MSG_PUB.Add;

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

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

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

Line 1709: FND_MSG_PUB.Add;

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

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

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

Line 1722: FND_MSG_PUB.Add;

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

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

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

Line 1736: FND_MSG_PUB.Add;

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

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

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

Line 1867: FND_MSG_PUB.Add;

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

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

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

Line 1877: FND_MSG_PUB.Add;

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

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

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

Line 1902: FND_MSG_PUB.Add;

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

Line 1918: FND_MSG_PUB.Add;

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

Line 1933: FND_MSG_PUB.Add;

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

Line 1972: FND_MSG_PUB.Add;

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

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

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

Line 2050: FND_MSG_PUB.Add;

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

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

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

Line 2111: FND_MSG_PUB.Add;

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

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

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

Line 2131: FND_MSG_PUB.Add;

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

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

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

Line 2147: FND_MSG_PUB.Add;

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

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

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

Line 2170: FND_MSG_PUB.Add;

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

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

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

Line 2192: FND_MSG_PUB.Add;

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

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

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

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

2588: -- dbms_output.put_line('In the validate_acct_site_call');
2589: -- dbms_output.put_line('Return_Status' || x_return_status);
2590:
2591: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: END IF;

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

2608: -- dbms_output.put_line('In the validate_acct_site_call2');
2609: -- dbms_output.put_line('Return_Status2' || x_return_status);
2610:
2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2616: END IF;

Line 2623: FND_MSG_PUB.initialize;

2619: -- r12 code start
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 ;

Line 2626: FND_MSG_PUB.Add ;

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:
2630: mo_global.set_policy_context('S',l_org_id);

Line 2710: FND_MSG_PUB.Add;

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

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

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

Line 2818: FND_MSG_PUB.Add;

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

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

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,
2822: p_data => x_msg_data);
2823: END;
2824: --

Line 2843: FND_MSG_PUB.Add;

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

Line 2865: FND_MSG_PUB.Add;

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

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

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

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

2942: END IF; -- comms_nl_trackable_flag
2943:
2944: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2945:
2946: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2947: p_count => x_msg_count,
2948: p_data => x_msg_data);
2949:
2950: -- dbms_output.put_line('message status' || x_return_status);

Line 2993: -- FND_MSG_PUB.initialize;

2989:
2990: IF x_msg_count > 0 THEN
2991: -- Get next message
2992:
2993: -- FND_MSG_PUB.initialize;
2994: /* FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2995: p_count => x_msg_count,
2996: p_data => x_msg_data); */
2997:

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

2990: IF x_msg_count > 0 THEN
2991: -- Get next message
2992:
2993: -- FND_MSG_PUB.initialize;
2994: /* FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
2995: p_count => x_msg_count,
2996: p_data => x_msg_data); */
2997:
2998: for k in 1..x_msg_count loop

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

2995: p_count => x_msg_count,
2996: p_data => x_msg_data); */
2997:
2998: for k in 1..x_msg_count loop
2999: FND_MSG_PUB.get(p_encoded => 'F',
3000: p_data=>x_msg_data,
3001: p_msg_index_out=>l_dummy);
3002: end loop;
3003:

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

3003:
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3005:
3006: /* for k in 1..x_msg_count loop
3007: FND_MSG_PUB.get(p_encoded => 'F',
3008: p_data=>x_msg_data,
3009: p_msg_index_out=>l_dummy);
3010:
3011: -- changes for 11.5.10

Line 3032: FND_MSG_PUB.Add;

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

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

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

Line 3041: -- FND_MSG_PUB.Add;

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

Line 3054: FND_MSG_PUB.Add;

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

Line 3068: FND_MSG_PUB.Count_And_Get

3064: COMMIT WORK;
3065: END IF;
3066:
3067: -- Standard call to get message count and if count is 1, get message info.
3068: FND_MSG_PUB.Count_And_Get
3069: ( p_count => x_msg_count,
3070: p_data => x_msg_data
3071: );
3072:

Line 3080: FND_MSG_PUB.Add;

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

Line 3087: FND_MSG_PUB.Count_And_Get

3083: --7117301
3084: WHEN FND_API.G_EXC_ERROR THEN
3085: ROLLBACK TO CS_Charge_Create_Order_PVT;
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: FND_MSG_PUB.Count_And_Get
3088: ( p_count => x_msg_count,
3089: p_data => x_msg_data
3090: );
3091:

Line 3117: FND_MSG_PUB.Add;

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

Line 3118: IF FND_MSG_PUB.Check_Msg_Level

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
3121: FND_MSG_PUB.Add_Exc_Msg
3122: ( G_PKG_NAME,

Line 3119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
3121: FND_MSG_PUB.Add_Exc_Msg
3122: ( G_PKG_NAME,
3123: l_api_name

Line 3121: FND_MSG_PUB.Add_Exc_Msg

3117: FND_MSG_PUB.Add;
3118: IF FND_MSG_PUB.Check_Msg_Level
3119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3120: THEN
3121: FND_MSG_PUB.Add_Exc_Msg
3122: ( G_PKG_NAME,
3123: l_api_name
3124: );
3125: END IF;

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

3123: l_api_name
3124: );
3125: END IF;
3126:
3127: FND_MSG_PUB.Count_And_Get(p_encoded => 'F',
3128: p_count => x_msg_count,
3129: p_data => x_msg_data);
3130:
3131: --