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.OKS_ATTR_DEFAULTS_PVT dependencies on OKC_API

Line 34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

30: --Fix for Bug# 3542273
31:
32: PROCEDURE validate_date
33: ( p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35: p_hdr_id IN NUMBER,
36: p_top_line_id IN NUMBER,
37: p_sub_line_id IN NUMBER,
38: x_return_status OUT NOCOPY VARCHAR2,

Line 90: x_return_status := OKC_API.G_RET_STS_SUCCESS;

86:
87:
88: BEGIN
89: x_flag := TRUE ;
90: x_return_status := OKC_API.G_RET_STS_SUCCESS;
91: -- Start of if for Header to Top line validation.
92:
93: If (p_hdr_id is not null and p_hdr_id > 0 ) and (p_top_line_id is not null
94: and p_top_line_id > 0 ) and (p_sub_line_id is null) then

Line 167: x_return_status := OKC_API.G_RET_STS_ERROR;

163: END IF;
164: RETURN;
165: END IF;
166: x_flag := FALSE;
167: x_return_status := OKC_API.G_RET_STS_ERROR;
168:
169: EXCEPTION
170: WHEN OTHERS THEN
171:

Line 172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

168:
169: EXCEPTION
170: WHEN OTHERS THEN
171:
172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
173: OKC_API.set_message('OKS',
174: 'OKC_CONTRACTS_UNEXP_ERROR',
175: 'SQLcode',
176: SQLCODE,

Line 173: OKC_API.set_message('OKS',

169: EXCEPTION
170: WHEN OTHERS THEN
171:
172: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
173: OKC_API.set_message('OKS',
174: 'OKC_CONTRACTS_UNEXP_ERROR',
175: 'SQLcode',
176: SQLCODE,
177: 'SQLerrm',

Line 239: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

235: End If;
236:
237: Exception
238: When Others Then
239: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
240: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
241: END update_line;
242:
243: FUNCTION CHECK_LINE_PARTY_ROLE(p_dnz_chr_id IN NUMBER,

Line 240: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

236:
237: Exception
238: When Others Then
239: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
240: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
241: END update_line;
242:
243: FUNCTION CHECK_LINE_PARTY_ROLE(p_dnz_chr_id IN NUMBER,
244: P_Cle_Id IN NUMBER,

Line 904: l_error_tbl OKC_API.ERROR_TBL_TYPE;

900: l_bpf_lse_id NUMBER;
901: L_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
902: l_top_bs_tbl oks_bill_level_elements_pvt.letv_tbl_type;
903: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;
904: l_error_tbl OKC_API.ERROR_TBL_TYPE;
905: p_klnv_tbl oks_kln_pvt.klnv_tbl_type;
906: l_klnv_tbl oks_kln_pvt.klnv_tbl_type := p_klnv_tbl;
907: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
908: l_payment_method VARCHAR2(150);--for payment method

Line 1153: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1149: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1150: l_tot_msg_count := l_tot_msg_count + 1;
1151: l_msg_data := NULL;
1152: End Loop;
1153: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1154: Else
1155: If l_flag <> TRUE then
1156: fnd_msg_pub.initialize;
1157:

Line 1158: OKC_API.SET_MESSAGE(

1154: Else
1155: If l_flag <> TRUE then
1156: fnd_msg_pub.initialize;
1157:
1158: OKC_API.SET_MESSAGE(
1159: p_app_name => 'OKS', --G_APP_NAME_OKS,
1160: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
1161: p_token1 => 'Line No ',
1162: p_token1_value => l_line_number);

Line 1170: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1166: x_msg_tbl(l_tot_msg_count).status := 'E';
1167: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1168: l_tot_msg_count := l_tot_msg_count + 1;
1169: l_msg_data := NULL;
1170: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: End If;
1172: End If;
1173:
1174: End If;

Line 1202: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1198: substr(SubStr(l_oks_lines_rec.invoice_text,1,InStr(l_oks_lines_rec.invoice_text,':')-1)
1199: ||':'|| header_dates_rec.start_date
1200: ||':'|| header_dates_rec.end_date,1,450);
1201:
1202: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1203: fnd_msg_pub.initialize;
1204: OKC_API.SET_MESSAGE(
1205: p_app_name => G_APP_NAME_OKS,
1206: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 1204: OKC_API.SET_MESSAGE(

1200: ||':'|| header_dates_rec.end_date,1,450);
1201:
1202: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1203: fnd_msg_pub.initialize;
1204: OKC_API.SET_MESSAGE(
1205: p_app_name => G_APP_NAME_OKS,
1206: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1207: p_token1 => 'ATTRIBUTE',
1208: p_token1_value => 'Invoicing Text');

Line 1240: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1236: l_clev_tbl_in(1).id := l_cle_id;
1237: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
1238: l_clev_tbl_in(1).cust_acct_id := l_head_cust_acct;
1239:
1240: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1241: fnd_msg_pub.initialize;
1242: OKC_API.SET_MESSAGE(
1243: p_app_name => G_APP_NAME_OKS,
1244: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 1242: OKC_API.SET_MESSAGE(

1238: l_clev_tbl_in(1).cust_acct_id := l_head_cust_acct;
1239:
1240: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1241: fnd_msg_pub.initialize;
1242: OKC_API.SET_MESSAGE(
1243: p_app_name => G_APP_NAME_OKS,
1244: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1245: p_token1 => 'ATTRIBUTE',
1246: p_token1_value => 'Bill To Address');

Line 1262: OKC_API.SET_MESSAGE(

1258: /* ElsIf l_head_cust_acct <> l_line_cust_acct and
1259: l_line_cust_acct is not NULL and l_head_cust_acct is not NULL Then
1260: fnd_msg_pub.initialize;
1261:
1262: OKC_API.SET_MESSAGE(
1263: p_app_name => G_APP_NAME_OKS,
1264: p_msg_name => 'OKS_CASCADE_ACCOUNT_MISMATCH',
1265: p_token1 => 'Line No ',
1266: p_token1_value => l_line_number);

Line 1276: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1272: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1273: l_tot_msg_count := l_tot_msg_count + 1;
1274: l_msg_data := NULL;
1275: If header_lines_tbl.FIRST = header_lines_tbl.LAST Then
1276: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1277: End If; */
1278:
1279:
1280: END IF; --l_head_cust_acct check

Line 1304: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1300:
1301: l_clev_tbl_in(1).id := l_cle_id;
1302: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1303:
1304: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1305: fnd_msg_pub.initialize;
1306: OKC_API.SET_MESSAGE(
1307: p_app_name => G_APP_NAME_OKS,
1308: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 1306: OKC_API.SET_MESSAGE(

1302: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1303:
1304: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1305: fnd_msg_pub.initialize;
1306: OKC_API.SET_MESSAGE(
1307: p_app_name => G_APP_NAME_OKS,
1308: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1309: p_token1 => 'ATTRIBUTE',
1310: p_token1_value => 'Ship To Address');

Line 1362: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1358: l_clev_tbl_in(1).cust_acct_id := l_header_cust_acct;
1359: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
1360: l_oks_header_id := 1;
1361:
1362: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1363: IF l_line_cust_acct IS NULL THEN
1364: fnd_msg_pub.initialize;
1365: OKC_API.SET_MESSAGE(
1366: p_app_name => G_APP_NAME_OKS,

Line 1365: OKC_API.SET_MESSAGE(

1361:
1362: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1363: IF l_line_cust_acct IS NULL THEN
1364: fnd_msg_pub.initialize;
1365: OKC_API.SET_MESSAGE(
1366: p_app_name => G_APP_NAME_OKS,
1367: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1368: p_token1 => 'ATTRIBUTE',
1369: p_token1_value => 'Bill To Address');

Line 1383: OKC_API.SET_MESSAGE(

1379:
1380:
1381:
1382: fnd_msg_pub.initialize;
1383: OKC_API.SET_MESSAGE(
1384: p_app_name => G_APP_NAME_OKS, -- bug 5468539 G_APP_NAME,
1385: p_msg_name =>'OKS_DEFAULT_ATTR_SUCCESS_NEW',
1386: p_token1 => 'TOKEN1' , -- bug 5468539 'RULE',
1387: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'));

Line 1419: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1415: l_klnv_tbl_in(1).EXEMPT_CERTIFICATE_NUMBER:= NULL;
1416: l_klnv_tbl_in(1).CLE_ID := l_cle_id;
1417: l_oks_header_id := 1;
1418: -- Display a message --
1419: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1420: fnd_msg_pub.initialize;
1421: OKC_API.SET_MESSAGE(
1422: p_app_name => G_APP_NAME,
1423: p_msg_name =>'OKS_CASCADE_DELETE_EXEMPTION',

Line 1421: OKC_API.SET_MESSAGE(

1417: l_oks_header_id := 1;
1418: -- Display a message --
1419: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1420: fnd_msg_pub.initialize;
1421: OKC_API.SET_MESSAGE(
1422: p_app_name => G_APP_NAME,
1423: p_msg_name =>'OKS_CASCADE_DELETE_EXEMPTION',
1424: p_token1 =>'TOKEN1' ,
1425: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

Line 1449: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1445: l_klnv_tbl_in(1).CLE_ID := l_cle_id;
1446: l_klnv_tbl_in(1).commitment_id := NULL ;
1447: l_klnv_tbl_in(1).payment_type := NULL ;
1448: -- Display a message --
1449: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1450: fnd_msg_pub.initialize;
1451: OKC_API.SET_MESSAGE(
1452: p_app_name => G_APP_NAME,
1453: p_msg_name =>'OKS_CASCADE_DELETE_COMMITMENT',

Line 1451: OKC_API.SET_MESSAGE(

1447: l_klnv_tbl_in(1).payment_type := NULL ;
1448: -- Display a message --
1449: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1450: fnd_msg_pub.initialize;
1451: OKC_API.SET_MESSAGE(
1452: p_app_name => G_APP_NAME,
1453: p_msg_name =>'OKS_CASCADE_DELETE_COMMITMENT',
1454: p_token1 =>'TOKEN1' ,
1455: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

Line 1540: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1536: p_ctcv_tbl => l_ctcv_tbl_in
1537: );
1538:
1539: -- Delete Party Role --
1540: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1541: -- Check if there is any contaact Present belonging to the party role ---
1542: l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
1543: IF nvl(l_temp_contact_id,0) = 0 THEN
1544:

Line 1558: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1554: x_msg_data => l_msg_data,
1555: p_cplv_tbl => l_cplv_tbl_in);
1556:
1557:
1558: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1559: Open cur_get_line_number(l_cle_id, l_chr_id);
1560: fetch cur_get_line_number into l_temp_line_number;
1561: close cur_get_line_number;
1562: fnd_msg_pub.initialize;

Line 1563: OKC_API.SET_MESSAGE(

1559: Open cur_get_line_number(l_cle_id, l_chr_id);
1560: fetch cur_get_line_number into l_temp_line_number;
1561: close cur_get_line_number;
1562: fnd_msg_pub.initialize;
1563: OKC_API.SET_MESSAGE(
1564: p_app_name => G_APP_NAME,
1565: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1566: p_token1 =>'TOKEN1' ,
1567: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

Line 1581: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1577: l_tot_msg_count := l_tot_msg_count + 1;
1578: l_msg_data := NULL;
1579: END IF;
1580: ELSE
1581: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1582: Open cur_get_line_number(l_cle_id, l_chr_id);
1583: fetch cur_get_line_number into l_temp_line_number;
1584: close cur_get_line_number;
1585: fnd_msg_pub.initialize;

Line 1586: OKC_API.SET_MESSAGE(

1582: Open cur_get_line_number(l_cle_id, l_chr_id);
1583: fetch cur_get_line_number into l_temp_line_number;
1584: close cur_get_line_number;
1585: fnd_msg_pub.initialize;
1586: OKC_API.SET_MESSAGE(
1587: p_app_name => G_APP_NAME,
1588: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1589: p_token1 =>'TOKEN1' ,
1590: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

Line 1606: ELSIF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1602: END IF;
1603:
1604: END IF; -- IF nvl(l_temp_contact_id,0) = 0 THEN
1605: -- Bug 5227077 --
1606: ELSIF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1607: FOR i in 1..fnd_msg_pub.count_msg
1608: Loop
1609: fnd_msg_pub.get
1610: (

Line 1621: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1617: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1618: l_tot_msg_count := l_tot_msg_count + 1;
1619: l_msg_data := NULL;
1620: End Loop;
1621: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: END IF;
1623: -- Bug 5227077 --
1624: END IF;
1625: END IF; -- IF l_contact_id is NOT NULL THEN

Line 1662: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1658: IF l_header_cust_acct <> nvl(l_line_cust_acct, -1) THEN
1659: -- Create/UPDATE a CAN RULE and Create/UPDATE the BTO Rule --
1660: l_clev_tbl_in(1).id := l_cle_id;
1661: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1662: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1663:
1664: IF l_line_cust_acct IS NULL THEN
1665: fnd_msg_pub.initialize;
1666: OKC_API.SET_MESSAGE(

Line 1666: OKC_API.SET_MESSAGE(

1662: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1663:
1664: IF l_line_cust_acct IS NULL THEN
1665: fnd_msg_pub.initialize;
1666: OKC_API.SET_MESSAGE(
1667: p_app_name => G_APP_NAME_OKS,
1668: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1669: p_token1 => 'ATTRIBUTE',
1670: p_token1_value => 'Ship To Address');

Line 1682: OKC_API.SET_MESSAGE(

1678: l_msg_data := NULL;
1679: END IF;
1680:
1681: fnd_msg_pub.initialize;
1682: OKC_API.SET_MESSAGE(
1683: p_app_name => G_APP_NAME_OKS, -- bug 5468539 G_APP_NAME,
1684: p_msg_name =>'OKS_DEFAULT_ATTR_SUCCESS_NEW',
1685: p_token1 => 'TOKEN1', -- bug 5468539 'RULE',
1686: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'));

Line 1771: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1767: p_ctcv_tbl => l_ctcv_tbl_in
1768: );
1769:
1770: -- Delete Party Role --
1771: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1772: -- Check if there is any contaact Present belonging to the party role ---
1773: l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
1774: IF nvl(l_temp_contact_id,0) = 0 THEN
1775: -- Open Party_role_csr(l_chr_id,l_cle_id);

Line 1791: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1787: x_msg_data => l_msg_data,
1788: p_cplv_tbl => l_cplv_tbl_in);
1789:
1790:
1791: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1792: Open cur_get_line_number(l_cle_id, l_chr_id);
1793: fetch cur_get_line_number into l_temp_line_number;
1794: close cur_get_line_number;
1795: fnd_msg_pub.initialize;

Line 1796: OKC_API.SET_MESSAGE(

1792: Open cur_get_line_number(l_cle_id, l_chr_id);
1793: fetch cur_get_line_number into l_temp_line_number;
1794: close cur_get_line_number;
1795: fnd_msg_pub.initialize;
1796: OKC_API.SET_MESSAGE(
1797: p_app_name => G_APP_NAME,
1798: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1799: p_token1 =>'TOKEN1' ,
1800: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

Line 1814: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1810: l_tot_msg_count := l_tot_msg_count + 1;
1811: l_msg_data := NULL;
1812: END IF;
1813: ELSE
1814: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1815: Open cur_get_line_number(l_cle_id, l_chr_id);
1816: fetch cur_get_line_number into l_temp_line_number;
1817: close cur_get_line_number;
1818: fnd_msg_pub.initialize;

Line 1819: OKC_API.SET_MESSAGE(

1815: Open cur_get_line_number(l_cle_id, l_chr_id);
1816: fetch cur_get_line_number into l_temp_line_number;
1817: close cur_get_line_number;
1818: fnd_msg_pub.initialize;
1819: OKC_API.SET_MESSAGE(
1820: p_app_name => G_APP_NAME,
1821: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1822: p_token1 =>'TOKEN1' ,
1823: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'),

Line 1839: ELSIF l_return_status <> OKC_API.G_RET_STS_SUCCESS

1835: END IF;
1836:
1837: END IF; -- IF nvl(l_temp_contact_id,0) = 0 THEN
1838: -- Bug 5227077 --
1839: ELSIF l_return_status <> OKC_API.G_RET_STS_SUCCESS
1840: THEN
1841: FOR i in 1..fnd_msg_pub.count_msg
1842: Loop
1843: fnd_msg_pub.get

Line 1855: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1851: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1852: l_tot_msg_count := l_tot_msg_count + 1;
1853: l_msg_data := NULL;
1854: End Loop;
1855: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1856:
1857: END IF;
1858: -- Bug 5227077 --
1859: END IF;

Line 1925: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1921: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1922: l_tot_msg_count := l_tot_msg_count + 1;
1923: l_msg_data := NULL;
1924: End Loop;
1925: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: END IF;
1927:
1928: -- Bug 5219132 --
1929: l_contact_id := CHECK_LINE_BILL_CONTACT(l_chr_id,l_cpl_id, 'OKX_CONTBILL', 'CUST_BILLING');-- Bug 5485054

Line 1971: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1967: l_tot_msg_count := l_tot_msg_count + 1;
1968: l_msg_data := NULL;
1969: End Loop;
1970: -- Bug 5227077 --
1971: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSE
1973: fnd_msg_pub.initialize;
1974: OKC_API.SET_MESSAGE(
1975: p_app_name => G_APP_NAME_OKS,

Line 1974: OKC_API.SET_MESSAGE(

1970: -- Bug 5227077 --
1971: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1972: ELSE
1973: fnd_msg_pub.initialize;
1974: OKC_API.SET_MESSAGE(
1975: p_app_name => G_APP_NAME_OKS,
1976: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1977: p_token1 => 'ATTRIBUTE',
1978: p_token1_value => 'Bill To Contact');

Line 2016: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2012: l_tot_msg_count := l_tot_msg_count + 1;
2013: l_msg_data := NULL;
2014: End Loop;
2015: -- Bug 5227077 --
2016: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSE
2018: fnd_msg_pub.initialize;
2019: OKC_API.SET_MESSAGE(
2020: p_app_name => G_APP_NAME_OKS,

Line 2019: OKC_API.SET_MESSAGE(

2015: -- Bug 5227077 --
2016: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSE
2018: fnd_msg_pub.initialize;
2019: OKC_API.SET_MESSAGE(
2020: p_app_name => G_APP_NAME_OKS,
2021: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2022: p_token1 => 'ATTRIBUTE',
2023: p_token1_value => 'Bill To Contact');

Line 2039: OKC_API.SET_MESSAGE(

2035:
2036: ELSIF(l_header_cust_acct <> l_line_cust_acct)
2037: THEN
2038: fnd_msg_pub.initialize;
2039: OKC_API.SET_MESSAGE(
2040: p_app_name => G_APP_NAME,
2041: p_msg_name => 'OKS_CASCADE_BTOACCT_MISMATCH',
2042: p_token1 => 'Line No ',
2043: p_token1_value => l_line_number);

Line 2215: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2211: --Fixed Tax exemption is cascading to line along with bug#4026268 --gbgupta
2212: --assigning tax exemption id
2213: l_klnv_tbl_in(1).tax_exemption_id := l_oks_headers_rec.tax_exemption_id;
2214: */
2215: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2216: fnd_msg_pub.initialize;
2217: OKC_API.SET_MESSAGE(
2218: p_app_name => G_APP_NAME_OKS,
2219: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2217: OKC_API.SET_MESSAGE(

2213: l_klnv_tbl_in(1).tax_exemption_id := l_oks_headers_rec.tax_exemption_id;
2214: */
2215: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2216: fnd_msg_pub.initialize;
2217: OKC_API.SET_MESSAGE(
2218: p_app_name => G_APP_NAME_OKS,
2219: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2220: p_token1 => 'ATTRIBUTE',
2221: p_token1_value => 'Tax');

Line 2271: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2267: -- Ebtax --
2268: l_klnv_tbl_in(1).tax_classification_code := l_header_tax_cls_code;
2269: -- Ebtax --
2270:
2271: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2272: fnd_msg_pub.initialize;
2273: OKC_API.SET_MESSAGE(
2274: p_app_name => G_APP_NAME_OKS,
2275: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2273: OKC_API.SET_MESSAGE(

2269: -- Ebtax --
2270:
2271: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2272: fnd_msg_pub.initialize;
2273: OKC_API.SET_MESSAGE(
2274: p_app_name => G_APP_NAME_OKS,
2275: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2276: p_token1 => 'ATTRIBUTE',
2277: p_token1_value => 'Tax Code');

Line 2313: OKC_API.SET_MESSAGE

2309: IF l_bpf_invoice_rule_id = -2 THEN
2310: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2311:
2312: fnd_msg_pub.initialize;
2313: OKC_API.SET_MESSAGE
2314: (
2315: p_app_name => G_APP_NAME_OKS,
2316: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2317: p_token1 => 'TOKEN1',

Line 2329: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2325: x_msg_tbl(l_tot_msg_count).status := 'E';
2326: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2327: l_tot_msg_count := l_tot_msg_count + 1;
2328: l_msg_data := NULL;
2329: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2330: End If;
2331: End If;
2332: End If;
2333: --Fix for Bug# 3542273

Line 2382: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2378: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2379: l_tot_msg_count := l_tot_msg_count + 1;
2380: l_msg_data := NULL;
2381: End Loop;
2382: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2383: END IF;
2384: -- Bug 5227077 --
2385:
2386:

Line 2414: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2410: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2411: l_tot_msg_count := l_tot_msg_count + 1;
2412: l_msg_data := NULL;
2413: End Loop;
2414: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2415: END IF;
2416: -- Bug 5227077 --
2417:
2418:

Line 2463: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2459: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2460: l_tot_msg_count := l_tot_msg_count + 1;
2461: l_msg_data := NULL;
2462: End Loop;
2463: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSE
2465: fnd_msg_pub.initialize;
2466: OKC_API.SET_MESSAGE(
2467: p_app_name => G_APP_NAME_OKS,

Line 2466: OKC_API.SET_MESSAGE(

2462: End Loop;
2463: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2464: ELSE
2465: fnd_msg_pub.initialize;
2466: OKC_API.SET_MESSAGE(
2467: p_app_name => G_APP_NAME_OKS,
2468: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2469: p_token1 => 'ATTRIBUTE',
2470: p_token1_value => 'Billing Schedule');

Line 2502: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2498:
2499: l_clev_tbl_in(1).id := l_cle_id;
2500: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
2501:
2502: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2503: fnd_msg_pub.initialize;
2504: OKC_API.SET_MESSAGE(
2505: p_app_name => G_APP_NAME_OKS,
2506: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2504: OKC_API.SET_MESSAGE(

2500: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
2501:
2502: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2503: fnd_msg_pub.initialize;
2504: OKC_API.SET_MESSAGE(
2505: p_app_name => G_APP_NAME_OKS,
2506: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2507: p_token1 => 'ATTRIBUTE',
2508: p_token1_value => 'Bill To Address');

Line 2523: OKC_API.SET_MESSAGE(

2519: END IF;
2520: Elsif l_billing_profile_id is NULL then
2521: --Display error message, saying required value missing.
2522: fnd_msg_pub.initialize;
2523: OKC_API.SET_MESSAGE(
2524: p_app_name => G_APP_NAME_OKS,
2525: p_msg_name => 'OKS_CASCADE_MISSING_REQD_ATTR',
2526: p_token1 => 'ATTRIBUTE',
2527: p_token1_value => 'Billing Profile');

Line 2550: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2546: l_klnv_tbl_in(1).acct_rule_id := l_oks_headers_rec.acct_rule_id;
2547: END IF;
2548: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2549:
2550: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2551: fnd_msg_pub.initialize;
2552: OKC_API.SET_MESSAGE(
2553: p_app_name => G_APP_NAME_OKS,
2554: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2552: OKC_API.SET_MESSAGE(

2548: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2549:
2550: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2551: fnd_msg_pub.initialize;
2552: OKC_API.SET_MESSAGE(
2553: p_app_name => G_APP_NAME_OKS,
2554: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2555: p_token1 => 'ATTRIBUTE',
2556: p_token1_value => 'Accounting Rule');

Line 2582: OKC_API.SET_MESSAGE

2578: IF l_bpf_invoice_rule_id = -2 THEN
2579: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2580:
2581: fnd_msg_pub.initialize;
2582: OKC_API.SET_MESSAGE
2583: (
2584: p_app_name => G_APP_NAME_OKS,
2585: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2586: p_token1 => 'TOKEN1',

Line 2598: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2594: x_msg_tbl(l_tot_msg_count).status := 'E';
2595: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2596: l_tot_msg_count := l_tot_msg_count + 1;
2597: l_msg_data := NULL;
2598: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: End If;
2600: End If;
2601: End If;
2602: --Fix for Bug# 3542273

Line 2607: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2603:
2604: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2605: l_klnv_tbl_in(1).acct_rule_id := l_bpf_acct_rule_id;
2606:
2607: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2608: fnd_msg_pub.initialize;
2609: OKC_API.SET_MESSAGE(
2610: p_app_name => G_APP_NAME_OKS,
2611: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2609: OKC_API.SET_MESSAGE(

2605: l_klnv_tbl_in(1).acct_rule_id := l_bpf_acct_rule_id;
2606:
2607: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2608: fnd_msg_pub.initialize;
2609: OKC_API.SET_MESSAGE(
2610: p_app_name => G_APP_NAME_OKS,
2611: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2612: p_token1 => 'ATTRIBUTE',
2613: p_token1_value => 'Accounting Rule');

Line 2646: OKC_API.SET_MESSAGE

2642: If l_clev_tbl_in(1).inv_rule_id = -2 then
2643: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2644:
2645: fnd_msg_pub.initialize;
2646: OKC_API.SET_MESSAGE
2647: (
2648: p_app_name => G_APP_NAME_OKS,
2649: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2650: p_token1 => 'TOKEN1',

Line 2662: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2658: x_msg_tbl(l_tot_msg_count).status := 'E';
2659: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2660: l_tot_msg_count := l_tot_msg_count + 1;
2661: l_msg_data := NULL;
2662: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2663: End If;
2664: End If;
2665: End If;
2666: --Fix for Bug# 3542273

Line 2679: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2675: x_msg_count => l_msg_count,
2676: x_msg_data => l_msg_data
2677: );
2678:
2679: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2680: fnd_msg_pub.initialize;
2681: OKC_API.SET_MESSAGE(
2682: p_app_name => G_APP_NAME_OKS,
2683: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2681: OKC_API.SET_MESSAGE(

2677: );
2678:
2679: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2680: fnd_msg_pub.initialize;
2681: OKC_API.SET_MESSAGE(
2682: p_app_name => G_APP_NAME_OKS,
2683: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2684: p_token1 => 'ATTRIBUTE',
2685: p_token1_value => 'Invoicing Rule');

Line 2710: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2706: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2707: l_tot_msg_count := l_tot_msg_count + 1;
2708: l_msg_data := NULL;
2709: End Loop;
2710: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2711: END IF;
2712: -- Bug 5227077 --
2713:
2714: ELSIF l_header_ire is NULL AND l_billing_profile IS NOT NULL and

Line 2726: OKC_API.SET_MESSAGE

2722: If l_usage_type in ('VRT','QTY') then
2723: IF l_bpf_invoice_rule_id = -2 THEN
2724: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2725: fnd_msg_pub.initialize;
2726: OKC_API.SET_MESSAGE
2727: (
2728: p_app_name => G_APP_NAME_OKS,
2729: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2730: p_token1 => 'TOKEN1',

Line 2741: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2737: x_msg_tbl(l_tot_msg_count).status := 'E';
2738: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2739: l_tot_msg_count := l_tot_msg_count + 1;
2740: l_msg_data := NULL;
2741: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2742: End If;
2743: End If;
2744: End If;
2745: --Fix for Bug# 3542273

Line 2776: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2772: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2773: l_tot_msg_count := l_tot_msg_count + 1;
2774: l_msg_data := NULL;
2775: End Loop;
2776: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2777:
2778: ELSE
2779: fnd_msg_pub.initialize;
2780: OKC_API.SET_MESSAGE(

Line 2780: OKC_API.SET_MESSAGE(

2776: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2777:
2778: ELSE
2779: fnd_msg_pub.initialize;
2780: OKC_API.SET_MESSAGE(
2781: p_app_name => G_APP_NAME_OKS,
2782: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2783: p_token1 => 'ATTRIBUTE',
2784: p_token1_value => 'Invoicing Rule');

Line 2837: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2833: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2834: l_tot_msg_count := l_tot_msg_count + 1;
2835: l_msg_data := NULL;
2836: End Loop;
2837: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2838: End if;
2839: -- Bug 5227077 --
2840:
2841: END IF; -- End if for plsql table count.

Line 2851: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2847: ,X_return_status => l_return_status
2848: );
2849:
2850:
2851: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2852: fnd_msg_pub.initialize;
2853: OKC_API.SET_MESSAGE(
2854: p_app_name => G_APP_NAME_OKS,
2855: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2853: OKC_API.SET_MESSAGE(

2849:
2850:
2851: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2852: fnd_msg_pub.initialize;
2853: OKC_API.SET_MESSAGE(
2854: p_app_name => G_APP_NAME_OKS,
2855: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2856: p_token1 => 'ATTRIBUTE',
2857: p_token1_value => 'Sales Credit');

Line 2881: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2877: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2878: l_tot_msg_count := l_tot_msg_count + 1;
2879: l_msg_data := NULL;
2880: End Loop;
2881: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2882: End if;
2883: -- Bug 5227077 --
2884:
2885: END IF;

Line 2963: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2959: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2960: l_tot_msg_count := l_tot_msg_count + 1;
2961: l_msg_data := NULL;
2962: End Loop;
2963: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2964: end if;
2965: -- Bug 5227077 --
2966:
2967: END IF;

Line 3006: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3002: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3003: l_tot_msg_count := l_tot_msg_count + 1;
3004: l_msg_data := NULL;
3005: End Loop;
3006: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3007: End if;
3008: -- Bug 5227077 --
3009:
3010: END IF;

Line 3062: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3058: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3059: l_tot_msg_count := l_tot_msg_count + 1;
3060: l_msg_data := NULL;
3061: End Loop;
3062: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: End if;
3064: -- Bug 5227077 --
3065:
3066: END IF;

Line 3108: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3104: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3105: l_tot_msg_count := l_tot_msg_count + 1;
3106: l_msg_data := NULL;
3107: End Loop;
3108: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3109: End if;
3110: -- Bug 5227077 --
3111:
3112: END IF;

Line 3140: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3136: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3137: l_tot_msg_count := l_tot_msg_count + 1;
3138: l_msg_data := NULL;
3139: End Loop;
3140: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3141: End if;
3142: -- Bug 5227077 --
3143:
3144:

Line 3200: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3196: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3197: l_tot_msg_count := l_tot_msg_count + 1;
3198: l_msg_data := NULL;
3199: End Loop;
3200: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3201: End if;
3202: -- Bug 5227077 --
3203:
3204: END IF;

Line 3213: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

3209:
3210: END IF;
3211:
3212: IF l_payment_method_com = 1 OR l_cust_po_flag = 0 OR l_payment_method_ccr = 1 THEN
3213: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3214:
3215: fnd_msg_pub.initialize;
3216: OKC_API.SET_MESSAGE(
3217: p_app_name => G_APP_NAME_OKS,

Line 3216: OKC_API.SET_MESSAGE(

3212: IF l_payment_method_com = 1 OR l_cust_po_flag = 0 OR l_payment_method_ccr = 1 THEN
3213: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3214:
3215: fnd_msg_pub.initialize;
3216: OKC_API.SET_MESSAGE(
3217: p_app_name => G_APP_NAME_OKS,
3218: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3219: p_token1 => 'ATTRIBUTE',
3220: p_token1_value => 'Payment Method');

Line 3242: OKC_API.SET_MESSAGE(

3238: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
3239: l_klnv_tbl_in(1).price_uom := l_oks_headers_rec.price_uom;
3240: ----errorout('UOM-'||l_klnv_tbl_in(1).price_uom);
3241: fnd_msg_pub.initialize;
3242: OKC_API.SET_MESSAGE(
3243: p_app_name => G_APP_NAME_OKS,
3244: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3245: p_token1 => 'ATTRIBUTE',
3246: p_token1_value => 'Price UOM');

Line 3273: OKC_API.SET_MESSAGE(

3269:
3270: IF NVL(l_validate_result,'N') IN ('U' ,'N') then -- Unexpected Error
3271: fnd_msg_pub.initialize;
3272: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,p_encoded => fnd_api.g_false);
3273: OKC_API.SET_MESSAGE(
3274: p_app_name => 'OKS', --G_APP_NAME_OKS,
3275: p_msg_name => 'OKS_INVALID_PRICE_LIST');
3276: x_msg_tbl(l_tot_msg_count).status := 'E';
3277: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 3280: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3276: x_msg_tbl(l_tot_msg_count).status := 'E';
3277: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3278: l_tot_msg_count := l_tot_msg_count + 1;
3279: l_msg_data := NULL;
3280: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3281: END IF;
3282:
3283: l_clev_tbl_in(1).ID := l_okc_lines_rec.ID;
3284: l_clev_tbl_in(1).price_list_id := l_okc_headers_rec.price_list_id;

Line 3317: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3313: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3314: l_tot_msg_count := l_tot_msg_count + 1;
3315: l_msg_data := NULL;
3316: End Loop;
3317: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3318: End if;
3319: -- Bug 5227077 --
3320:
3321: l_locked_prl_cnt := l_locked_prl_cnt + 1;

Line 3329: OKC_API.SET_MESSAGE(

3325: l_klnv_tbl_in(1).locked_price_list_line_id := null;
3326:
3327:
3328: fnd_msg_pub.initialize;
3329: OKC_API.SET_MESSAGE(
3330: p_app_name => G_APP_NAME_OKS,
3331: p_msg_name => 'OKS_HEADER_CASCADE_WARNING',
3332: p_token1 => 'ATTRIBUTE',
3333: p_token1_value => 'Price List');

Line 3345: OKC_API.SET_MESSAGE(

3341: ELSE
3342: -- To display the Cascade Message when
3343: -- Usage lines is not locked and the cascade take place --
3344: fnd_msg_pub.initialize;
3345: OKC_API.SET_MESSAGE(
3346: p_app_name => G_APP_NAME_OKS,
3347: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3348: p_token1 => 'ATTRIBUTE',
3349: p_token1_value => 'Price List');

Line 3361: OKC_API.SET_MESSAGE(

3357:
3358: END IF;
3359: Else
3360: fnd_msg_pub.initialize;
3361: OKC_API.SET_MESSAGE(
3362: p_app_name => G_APP_NAME_OKS,
3363: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3364: p_token1 => 'ATTRIBUTE',
3365: p_token1_value => 'Price List');

Line 3433: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3429: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3430: l_tot_msg_count := l_tot_msg_count + 1;
3431: l_msg_data := NULL;
3432: End Loop;
3433: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3434: End If;
3435:
3436:
3437: END IF;

Line 3482: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3478: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3479: l_tot_msg_count := l_tot_msg_count + 1;
3480: l_msg_data := NULL;
3481: End Loop;
3482: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3483: End If;
3484:
3485: END IF;
3486:

Line 3528: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

3524:
3525: End Loop;
3526: end if;
3527: -- Bug 5381082 --
3528: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3529: FOR i in 1..fnd_msg_pub.count_msg
3530: Loop
3531: fnd_msg_pub.get
3532: (

Line 3543: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3539: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3540: l_tot_msg_count := l_tot_msg_count + 1;
3541: l_msg_data := NULL;
3542: End Loop;
3543: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3544: End If;
3545: -- BUg 5381082 --
3546: END IF;
3547: -- End 8/23/2005 hkamdar R12 Partial Period

Line 3587: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3583: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3584: l_tot_msg_count := l_tot_msg_count + 1;
3585: l_msg_data := NULL;
3586: End Loop;
3587: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3588:
3589: ELSE
3590: -- Bug 5191587 --
3591: If l_okc_lines_rec.lse_id in ('1','14', '19') and l_sr_number IS NOT NULL

Line 3595: OKC_API.SET_MESSAGE(

3591: If l_okc_lines_rec.lse_id in ('1','14', '19') and l_sr_number IS NOT NULL
3592: then
3593: fnd_msg_pub.initialize;
3594:
3595: OKC_API.SET_MESSAGE(
3596: p_app_name => G_APP_NAME_OKS,
3597: p_msg_name => 'OKS_HEADER_CASCADE_SR_SUCCESS',
3598: p_token1 => 'SR#',
3599: p_token1_value => l_sr_number,

Line 3616: OKC_API.SET_MESSAGE(

3612:
3613: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3614: IF(l_disp_warning ='Y') THEN
3615:
3616: OKC_API.SET_MESSAGE(
3617: p_app_name => G_APP_NAME_OKS,
3618: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3619:
3620: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3623: OKC_API.SET_MESSAGE(

3619:
3620: x_msg_tbl(l_tot_msg_count).status := 'W';
3621: ELSE
3622:
3623: OKC_API.SET_MESSAGE(
3624: p_app_name => G_APP_NAME_OKS,
3625: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3626: p_token1 => 'ATTRIBUTE',
3627: p_token1_value => 'Date');

Line 3644: OKC_API.SET_MESSAGE(

3640:
3641: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3642: IF(l_disp_warning ='Y') THEN
3643:
3644: OKC_API.SET_MESSAGE(
3645: p_app_name => G_APP_NAME_OKS,
3646: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3647:
3648: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3650: OKC_API.SET_MESSAGE(

3646: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3647:
3648: x_msg_tbl(l_tot_msg_count).status := 'W';
3649: ELSE
3650: OKC_API.SET_MESSAGE(
3651: p_app_name => G_APP_NAME_OKS,
3652: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3653: p_token1 => 'ATTRIBUTE',
3654: p_token1_value => 'Date');

Line 3669: OKC_API.SET_MESSAGE

3665: END IF;
3666:
3667: Else --LineCov_cur% not Found Then
3668: fnd_msg_pub.initialize;
3669: OKC_API.SET_MESSAGE
3670: (
3671: p_app_name => G_APP_NAME_OKS,
3672: p_msg_name => 'OKS_CASCADE_COV_NOT_FOUND',
3673: p_token2 => 'Line No ',

Line 3716: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3712: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3713: l_tot_msg_count := l_tot_msg_count + 1;
3714: l_msg_data := NULL;
3715: End Loop;
3716: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3717: end if;
3718: -- Bug 5227077 --
3719:
3720: End If;

Line 3752: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3748: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3749: l_tot_msg_count := l_tot_msg_count + 1;
3750: l_msg_data := NULL;
3751: End Loop;
3752: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3753: end if;
3754:
3755: /*added for bug 10132468*/
3756:

Line 3759: OKC_API.SET_MESSAGE(

3755: /*added for bug 10132468*/
3756:
3757: If l_sr_number IS NOT NULL then
3758: fnd_msg_pub.initialize;
3759: OKC_API.SET_MESSAGE(
3760: p_app_name => G_APP_NAME_OKS,
3761: p_msg_name => 'OKS_HEADER_CASCADE_SR_SUCCESS',
3762: p_token1 => 'SR#',
3763: p_token1_value => l_sr_number,

Line 3779: OKC_API.SET_MESSAGE(

3775: fnd_msg_pub.initialize;
3776: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3777: IF(l_disp_warning ='Y') THEN
3778:
3779: OKC_API.SET_MESSAGE(
3780: p_app_name => G_APP_NAME_OKS,
3781: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3782:
3783: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3786: OKC_API.SET_MESSAGE(

3782:
3783: x_msg_tbl(l_tot_msg_count).status := 'W';
3784: ELSE
3785:
3786: OKC_API.SET_MESSAGE(
3787: p_app_name => G_APP_NAME_OKS,
3788: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3789: p_token1 => 'ATTRIBUTE',
3790: p_token1_value => 'Date');

Line 3807: OKC_API.SET_MESSAGE(

3803:
3804: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3805: IF(l_disp_warning ='Y') THEN
3806:
3807: OKC_API.SET_MESSAGE(
3808: p_app_name => G_APP_NAME_OKS,
3809: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3810:
3811: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3814: OKC_API.SET_MESSAGE(

3810:
3811: x_msg_tbl(l_tot_msg_count).status := 'W';
3812: ELSE
3813:
3814: OKC_API.SET_MESSAGE(
3815: p_app_name => G_APP_NAME_OKS,
3816: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3817: p_token1 => 'ATTRIBUTE',
3818: p_token1_value => 'Date');

Line 3837: OKC_API.SET_MESSAGE(

3833:
3834: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3835: IF(l_disp_warning ='Y') THEN
3836:
3837: OKC_API.SET_MESSAGE(
3838: p_app_name => G_APP_NAME_OKS,
3839: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3840:
3841: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3844: OKC_API.SET_MESSAGE(

3840:
3841: x_msg_tbl(l_tot_msg_count).status := 'W';
3842: ELSE
3843:
3844: OKC_API.SET_MESSAGE(
3845: p_app_name => G_APP_NAME_OKS,
3846: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3847: p_token1 => 'ATTRIBUTE',
3848: p_token1_value => 'Date');

Line 3878: p_init_msg_list => OKC_API.G_TRUE,

3874: G_RAIL_REC.amount := sub_line_rec.price_negotiated;
3875: OKS_TAX_UTIL_PVT.Get_Tax
3876: (
3877: p_api_version => 1.0,
3878: p_init_msg_list => OKC_API.G_TRUE,
3879: p_chr_id => l_chr_id,
3880: p_cle_id => sub_line_rec.id, --l_cle_id,
3881: px_rail_rec => G_RAIL_REC,
3882: x_msg_count => x_msg_count,

Line 3887: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

3883: x_msg_data => x_msg_data,
3884: x_return_status => l_return_status
3885: );
3886:
3887: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3888: FOR i in 1..fnd_msg_pub.count_msg
3889: Loop
3890: fnd_msg_pub.get
3891: (

Line 3902: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3898: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3899: l_tot_msg_count := l_tot_msg_count + 1;
3900: l_msg_data := NULL;
3901: End Loop;
3902: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3903: End If;
3904:
3905: l_UNIT_SELLING_PRICE := G_RAIL_REC.UNIT_SELLING_PRICE;
3906: l_QUANTITY := G_RAIL_REC.QUANTITY;

Line 3959: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

3955: p_validate_yn => 'N'
3956: );
3957:
3958:
3959: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3960: FOR i in 1..fnd_msg_pub.count_msg
3961: Loop
3962: fnd_msg_pub.get
3963: (

Line 3975: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3971: l_tot_msg_count := l_tot_msg_count + 1;
3972: l_msg_data := NULL;
3973: End Loop;
3974:
3975: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3976: End If;
3977: /*
3978: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3979: fnd_msg_pub.initialize;

Line 3978: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

3974:
3975: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3976: End If;
3977: /*
3978: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3979: fnd_msg_pub.initialize;
3980: OKC_API.SET_MESSAGE(
3981: p_app_name => G_APP_NAME_OKS,
3982: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 3980: OKC_API.SET_MESSAGE(

3976: End If;
3977: /*
3978: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3979: fnd_msg_pub.initialize;
3980: OKC_API.SET_MESSAGE(
3981: p_app_name => G_APP_NAME_OKS,
3982: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
3983: p_token1 => 'ATTRIBUTE',
3984: p_token1_value => 'Recalculate Tax');

Line 4026: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4022: x_klnv_tbl => l_klnv_tbl_out,
4023: p_validate_yn => 'N'
4024: );
4025: -- Bug 5227077 --
4026: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4027: FOR i in 1..fnd_msg_pub.count_msg
4028: Loop
4029: fnd_msg_pub.get
4030: (

Line 4041: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4037: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4038: l_tot_msg_count := l_tot_msg_count + 1;
4039: l_msg_data := NULL;
4040: End Loop;
4041: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4042: End If;
4043:
4044: ELSE -- this is to check for lse_id = 46
4045: OKS_TAX_UTIL_PVT.Get_Tax

Line 4048: p_init_msg_list => OKC_API.G_TRUE,

4044: ELSE -- this is to check for lse_id = 46
4045: OKS_TAX_UTIL_PVT.Get_Tax
4046: (
4047: p_api_version => 1.0,
4048: p_init_msg_list => OKC_API.G_TRUE,
4049: p_chr_id => l_chr_id,
4050: p_cle_id => l_cle_id,
4051: px_rail_rec => G_RAIL_REC,
4052: x_msg_count => x_msg_count,

Line 4057: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4053: x_msg_data => x_msg_data,
4054: x_return_status => l_return_status
4055: );
4056: -- Bug 5227077 --
4057: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4058: FOR i in 1..fnd_msg_pub.count_msg
4059: Loop
4060: fnd_msg_pub.get
4061: (

Line 4072: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4068: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4069: l_tot_msg_count := l_tot_msg_count + 1;
4070: l_msg_data := NULL;
4071: End Loop;
4072: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4073: End If;
4074: -- Bug 5227077 --
4075: l_UNIT_SELLING_PRICE := G_RAIL_REC.UNIT_SELLING_PRICE;
4076: l_QUANTITY := G_RAIL_REC.QUANTITY;

Line 4111: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4107: p_validate_yn => 'N'
4108: );
4109:
4110:
4111: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4112: FOR i in 1..fnd_msg_pub.count_msg
4113: Loop
4114: fnd_msg_pub.get
4115: (

Line 4126: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4122: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4123: l_tot_msg_count := l_tot_msg_count + 1;
4124: l_msg_data := NULL;
4125: End Loop;
4126: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4127: End If;
4128: /*
4129: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4130: fnd_msg_pub.initialize;

Line 4129: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4125: End Loop;
4126: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4127: End If;
4128: /*
4129: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4130: fnd_msg_pub.initialize;
4131: OKC_API.SET_MESSAGE(
4132: p_app_name => G_APP_NAME_OKS,
4133: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 4131: OKC_API.SET_MESSAGE(

4127: End If;
4128: /*
4129: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4130: fnd_msg_pub.initialize;
4131: OKC_API.SET_MESSAGE(
4132: p_app_name => G_APP_NAME_OKS,
4133: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4134: p_token1 => 'ATTRIBUTE',
4135: p_token1_value => 'Recalculate Tax');

Line 4168: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4164: x_msg_data => l_msg_data,
4165: p_khrv_tbl => l_khrv_tbl_type_in,
4166: x_khrv_tbl => l_khrv_tbl_type_out,
4167: p_validate_yn => 'N');
4168: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4169: FOR i in 1..fnd_msg_pub.count_msg
4170: Loop
4171: fnd_msg_pub.get
4172: (

Line 4183: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4179: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4180: l_tot_msg_count := l_tot_msg_count + 1;
4181: l_msg_data := NULL;
4182: End Loop;
4183: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4184: End If;
4185: -- Bug 5227077 --
4186:
4187:

Line 4188: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4184: End If;
4185: -- Bug 5227077 --
4186:
4187:
4188: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4189: fnd_msg_pub.initialize;
4190: OKC_API.SET_MESSAGE(
4191: p_app_name => G_APP_NAME_OKS,
4192: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 4190: OKC_API.SET_MESSAGE(

4186:
4187:
4188: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4189: fnd_msg_pub.initialize;
4190: OKC_API.SET_MESSAGE(
4191: p_app_name => G_APP_NAME_OKS,
4192: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4193: p_token1 => 'ATTRIBUTE',
4194: p_token1_value => 'Recalculate Tax');

Line 4215: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4211: p_top_line_id => l_cle_id,
4212: x_return_status => l_return_status,
4213: x_msg_count => l_msg_count,
4214: x_msg_data => l_msg_data);
4215: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4216:
4217: FOR i in 1..fnd_msg_pub.count_msg
4218: Loop
4219: fnd_msg_pub.get

Line 4232: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4228: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4229: l_tot_msg_count := l_tot_msg_count + 1;
4230: l_msg_data := NULL;
4231: End Loop;
4232: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4233:
4234: End If;
4235:
4236: --Fix for Bug#3635291;

Line 4271: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4267: When G_EXCEPTION_HALT_VALIDATION Then
4268: x_return_status := l_return_status;
4269: x_msg_data := l_msg_data;
4270: When Others Then
4271: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4272: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4273: x_msg_data := l_msg_data;
4274: END Default_header_to_lines;
4275:

Line 4272: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

4268: x_return_status := l_return_status;
4269: x_msg_data := l_msg_data;
4270: When Others Then
4271: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4272: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4273: x_msg_data := l_msg_data;
4274: END Default_header_to_lines;
4275:
4276: ----------------------------------------------------------------------------------------------

Line 4368: l_error_tbl OKC_API.ERROR_TBL_TYPE;

4364: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4365: l_cle_id NUMBER;
4366: p_cle_id NUMBER;
4367:
4368: l_error_tbl OKC_API.ERROR_TBL_TYPE;
4369: p_klnv_tbl oks_kln_pvt.klnv_tbl_type;
4370: l_klnv_tbl oks_kln_pvt.klnv_tbl_type := p_klnv_tbl;
4371: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
4372: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type;

Line 4429: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4425: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4426: l_klnv_tbl_in(1).invoice_text := l_oks_lines_rec.invoice_text;
4427: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4428:
4429: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4430: OKC_API.SET_MESSAGE(
4431: p_app_name => G_APP_NAME_OKS,
4432: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4433: p_token1 => 'ATTRIBUTE',

Line 4430: OKC_API.SET_MESSAGE(

4426: l_klnv_tbl_in(1).invoice_text := l_oks_lines_rec.invoice_text;
4427: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4428:
4429: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4430: OKC_API.SET_MESSAGE(
4431: p_app_name => G_APP_NAME_OKS,
4432: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4433: p_token1 => 'ATTRIBUTE',
4434: p_token1_value => 'Invoicing Text');

Line 4454: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4450:
4451: l_clev_tbl_in(1).id := l_subline_id;
4452: l_clev_tbl_in(1).line_renewal_type_code := l_okc_lines_rec.line_renewal_type_code;
4453:
4454: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4455: OKC_API.SET_MESSAGE(
4456: p_app_name => G_APP_NAME_OKS,
4457: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4458: p_token1 => 'ATTRIBUTE',

Line 4455: OKC_API.SET_MESSAGE(

4451: l_clev_tbl_in(1).id := l_subline_id;
4452: l_clev_tbl_in(1).line_renewal_type_code := l_okc_lines_rec.line_renewal_type_code;
4453:
4454: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4455: OKC_API.SET_MESSAGE(
4456: p_app_name => G_APP_NAME_OKS,
4457: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4458: p_token1 => 'ATTRIBUTE',
4459: p_token1_value => 'Renewal');

Line 4514: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4510: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4511: l_tot_msg_count := l_tot_msg_count + 1;
4512: l_msg_data := NULL;
4513: End Loop;
4514: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4515: Else
4516: If l_flag <> TRUE then
4517: fnd_msg_pub.initialize;
4518: OKC_API.SET_MESSAGE(

Line 4518: OKC_API.SET_MESSAGE(

4514: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4515: Else
4516: If l_flag <> TRUE then
4517: fnd_msg_pub.initialize;
4518: OKC_API.SET_MESSAGE(
4519: p_app_name => 'OKS', --G_APP_NAME_OKS,
4520: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
4521: p_token1 => 'Sub Line No ',
4522: p_token1_value => l_sub_line_seq_number);

Line 4560: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4556: l_clev_tbl_in(1).sts_code :='EXPIRED';
4557: End if;
4558: End if;
4559:
4560: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4561: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4562: IF(l_disp_warning ='Y') THEN
4563: OKC_API.SET_MESSAGE(
4564: p_app_name => G_APP_NAME_OKS,

Line 4563: OKC_API.SET_MESSAGE(

4559:
4560: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4561: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4562: IF(l_disp_warning ='Y') THEN
4563: OKC_API.SET_MESSAGE(
4564: p_app_name => G_APP_NAME_OKS,
4565: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4566: x_msg_tbl(l_tot_msg_count).status := 'W';
4567:

Line 4570: OKC_API.SET_MESSAGE(

4566: x_msg_tbl(l_tot_msg_count).status := 'W';
4567:
4568: ELSE
4569:
4570: OKC_API.SET_MESSAGE(
4571: p_app_name => G_APP_NAME_OKS,
4572: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4573: p_token1 => 'ATTRIBUTE',
4574: p_token1_value => 'Date');

Line 4598: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4594:
4595: l_line_irt := 'X';
4596: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4597:
4598: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4599: OKC_API.SET_MESSAGE(
4600: p_app_name => G_APP_NAME_OKS,
4601: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4602: p_token1 => 'ATTRIBUTE',

Line 4599: OKC_API.SET_MESSAGE(

4595: l_line_irt := 'X';
4596: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4597:
4598: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4599: OKC_API.SET_MESSAGE(
4600: p_app_name => G_APP_NAME_OKS,
4601: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4602: p_token1 => 'ATTRIBUTE',
4603: p_token1_value => 'Subline Invoicing Text');

Line 4624: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4620: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4621: l_klnv_tbl_in(1).inv_print_flag := l_oks_lines_rec.inv_print_flag;
4622: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4623:
4624: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4625: OKC_API.SET_MESSAGE(
4626: p_app_name => G_APP_NAME_OKS,
4627: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4628: p_token1 => 'ATTRIBUTE',

Line 4625: OKC_API.SET_MESSAGE(

4621: l_klnv_tbl_in(1).inv_print_flag := l_oks_lines_rec.inv_print_flag;
4622: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4623:
4624: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4625: OKC_API.SET_MESSAGE(
4626: p_app_name => G_APP_NAME_OKS,
4627: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4628: p_token1 => 'ATTRIBUTE',
4629: p_token1_value => 'Invoicing Print Flag');

Line 4664: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4660: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4661: l_klnv_tbl_in(1).price_uom := l_oks_lines_rec.price_uom;
4662: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4663:
4664: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4665: OKC_API.SET_MESSAGE(
4666: p_app_name => G_APP_NAME_OKS,
4667: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4668: p_token1 => 'ATTRIBUTE',

Line 4665: OKC_API.SET_MESSAGE(

4661: l_klnv_tbl_in(1).price_uom := l_oks_lines_rec.price_uom;
4662: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4663:
4664: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4665: OKC_API.SET_MESSAGE(
4666: p_app_name => G_APP_NAME_OKS,
4667: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4668: p_token1 => 'ATTRIBUTE',
4669: p_token1_value => 'Price UOM');

Line 4680: /* OKC_API.SET_MESSAGE(

4676: l_msg_data := NULL;
4677: fnd_msg_pub.initialize;
4678: END IF;
4679: Else
4680: /* OKC_API.SET_MESSAGE(
4681: p_app_name => G_APP_NAME_OKS,
4682: p_msg_name => 'OKS_LINE_CASCADE_ERROR',
4683: p_token1 => 'ATTRIBUTE',
4684: p_token1_value => 'Price UOM');

Line 4703: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4699: When G_EXCEPTION_HALT_VALIDATION Then
4700: x_return_status := 'E';
4701: x_msg_data := l_msg_data;
4702: When Others Then
4703: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4704: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4705: x_msg_data := l_msg_data;
4706:
4707: --new

Line 4704: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

4700: x_return_status := 'E';
4701: x_msg_data := l_msg_data;
4702: When Others Then
4703: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4704: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4705: x_msg_data := l_msg_data;
4706:
4707: --new
4708:

Line 4791: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4787: p_service_Line_Id => l_cle_id,
4788: p_New_Start_Date => line_dates_rec.start_date,
4789: p_New_End_Date => line_dates_rec.end_date );
4790:
4791: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4792: FOR i in 1..fnd_msg_pub.count_msg
4793: Loop
4794: fnd_msg_pub.get
4795: (

Line 4806: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4802: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4803: l_tot_msg_count := l_tot_msg_count + 1;
4804: l_msg_data := NULL;
4805: End Loop;
4806: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4807: End If;
4808:
4809: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4810:

Line 4809: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

4805: End Loop;
4806: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4807: End If;
4808:
4809: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4810:
4811: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4812: IF(l_disp_warning ='Y') THEN
4813:

Line 4814: OKC_API.SET_MESSAGE(

4810:
4811: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4812: IF(l_disp_warning ='Y') THEN
4813:
4814: OKC_API.SET_MESSAGE(
4815: p_app_name => G_APP_NAME_OKS,
4816: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4817:
4818: ELSE

Line 4820: OKC_API.SET_MESSAGE(

4816: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4817:
4818: ELSE
4819:
4820: OKC_API.SET_MESSAGE(
4821: p_app_name => G_APP_NAME_OKS,
4822: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4823: p_token1 => 'ATTRIBUTE',
4824: p_token1_value => 'Date');

Line 4848: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4844: );
4845: -- Bug 5227077 --
4846: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4847:
4848: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4849: end if;
4850: -- Bug 5227077 --
4851:
4852:

Line 4876: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4872:
4873: -- errorout_vg('After oks_contract_line_pub.update_line status '||l_return_status);
4874: --errorout_gsi('After oks_contract_line_pub.update_line Message '||l_msg_data);
4875:
4876: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4877:
4878: FOR i in 1..fnd_msg_pub.count_msg
4879: Loop
4880: fnd_msg_pub.get

Line 4893: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4889: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4890: l_tot_msg_count := l_tot_msg_count + 1;
4891: l_msg_data := NULL;
4892: End Loop;
4893: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: End If;
4895:
4896: END IF;
4897:

Line 4911: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4907: x_msg_count => l_msg_count,
4908: x_msg_data => l_msg_data
4909: );
4910:
4911: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4912: FOR i in 1..fnd_msg_pub.count_msg
4913: Loop
4914: fnd_msg_pub.get
4915: (

Line 4927: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4923: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4924: l_tot_msg_count := l_tot_msg_count + 1;
4925: l_msg_data := NULL;
4926: End Loop;
4927: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4928:
4929: End If;
4930:
4931: END IF;

Line 4986: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

4982: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4983: l_tot_msg_count := l_tot_msg_count + 1;
4984: l_msg_data := NULL;
4985: End Loop;
4986: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4987: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4988: End If;
4989: END IF ;
4990: ELSE

Line 4987: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4983: l_tot_msg_count := l_tot_msg_count + 1;
4984: l_msg_data := NULL;
4985: End Loop;
4986: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4987: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4988: End If;
4989: END IF ;
4990: ELSE
4991: -- errorout_vg('Calling subline_common_attributes Third');

Line 5017: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5013: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5014: l_tot_msg_count := l_tot_msg_count + 1;
5015: l_msg_data := NULL;
5016: End Loop;
5017: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5018: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5019: End If;
5020: END IF;
5021:

Line 5018: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5014: l_tot_msg_count := l_tot_msg_count + 1;
5015: l_msg_data := NULL;
5016: End Loop;
5017: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5018: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5019: End If;
5020: END IF;
5021:
5022: -- END GCAHDHA --

Line 5042: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5038: x_klnv_tbl => l_klnv_tbl_out,
5039: p_validate_yn => 'N'
5040: );
5041:
5042: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5043: FOR i in 1..fnd_msg_pub.count_msg
5044: Loop
5045: fnd_msg_pub.get
5046: (

Line 5058: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5054: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5055: l_tot_msg_count := l_tot_msg_count + 1;
5056: l_msg_data := NULL;
5057: End Loop;
5058: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5059:
5060: End If;
5061:
5062: END IF;

Line 5077: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5073: x_return_status => l_return_status,
5074: x_msg_count => l_msg_count,
5075: x_msg_data => l_msg_data
5076: );
5077: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5078: FOR i in 1..fnd_msg_pub.count_msg
5079: Loop
5080: fnd_msg_pub.get
5081: (

Line 5093: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5089: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5090: l_tot_msg_count := l_tot_msg_count + 1;
5091: l_msg_data := NULL;
5092: End Loop;
5093: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5094: End If;
5095:
5096: END IF;
5097: -- errorout_vg('I -- Before Calling oks_qp_int_pvt.compute_Price lse_id ' || l_sub_line_rec.lse_id );

Line 5138: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5134: l_count := l_status_tbl.NEXT(l_count);
5135: End Loop;
5136: END IF;
5137: -- Bug 5381082 --
5138: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5139: FOR i in 1..fnd_msg_pub.count_msg
5140: Loop
5141: fnd_msg_pub.get
5142: (

Line 5153: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5149: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5150: l_tot_msg_count := l_tot_msg_count + 1;
5151: l_msg_data := NULL;
5152: End Loop;
5153: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5154: End If;
5155: -- Bug 5381082 --
5156: End if;
5157:

Line 5208: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5204: l_count := l_status_tbl.NEXT(l_count);
5205: End Loop;
5206: END IF;
5207: -- Bug 5381082 --
5208: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5209: FOR i in 1..fnd_msg_pub.count_msg
5210: Loop
5211: fnd_msg_pub.get
5212: (

Line 5223: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5219: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5220: l_tot_msg_count := l_tot_msg_count + 1;
5221: l_msg_data := NULL;
5222: End Loop;
5223: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5224: End If;
5225: -- Bug 5381082 --
5226: End if;
5227:

Line 5244: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then

5240: x_return_status => l_return_status,
5241: x_msg_count => l_msg_count,
5242: x_msg_data => l_msg_data);
5243: --errorout_gsi('After OKS_BILL_SCH.Cascade_Dates_SLL status '||l_return_status);
5244: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5245: FOR i in 1..fnd_msg_pub.count_msg
5246: Loop
5247: fnd_msg_pub.get
5248: (

Line 5260: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5256: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5257: l_tot_msg_count := l_tot_msg_count + 1;
5258: l_msg_data := NULL;
5259: End Loop;
5260: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5261:
5262: End If;
5263: END LOOP;
5264: END IF;

Line 5294: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5290: When G_EXCEPTION_HALT_VALIDATION Then
5291: x_return_status := 'E';
5292: x_msg_data := l_msg_data;
5293: When Others Then
5294: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5295: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5296: x_msg_data := l_msg_data;
5297:
5298: --new

Line 5295: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

5291: x_return_status := 'E';
5292: x_msg_data := l_msg_data;
5293: When Others Then
5294: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5295: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5296: x_msg_data := l_msg_data;
5297:
5298: --new
5299:

Line 5376: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5372:
5373:
5374: Exception
5375: When Others Then
5376: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5377: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5378: x_msg_data := l_msg_data;
5379:
5380: End Delete_Credit_Card;

Line 5377: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

5373:
5374: Exception
5375: When Others Then
5376: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5377: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5378: x_msg_data := l_msg_data;
5379:
5380: End Delete_Credit_Card;
5381:

Line 5492: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5488:
5489: return(l_entity_id);
5490: Exception
5491: When Others Then
5492: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5493: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5494: x_msg_data := l_msg_data;
5495: End Create_Credit_Card;
5496:

Line 5493: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

5489: return(l_entity_id);
5490: Exception
5491: When Others Then
5492: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5493: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5494: x_msg_data := l_msg_data;
5495: End Create_Credit_Card;
5496:
5497: /*Added for CASCADE_ER*/

Line 5513: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5509: X_return_status OUT NOCOPY Varchar2) IS
5510: l_id NUMBER;
5511: i NUMBER;
5512: BEGIN
5513: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5514:
5515: IF NOT header_lines_tbl.COUNT=0 THEN
5516:
5517: i:=header_lines_tbl.FIRST;

Line 5587: x_return_status := OKC_API.G_RET_STS_SUCCESS;

5583: X_return_status OUT NOCOPY Varchar2) IS
5584: l_id NUMBER;
5585: i NUMBER :=0;
5586: BEGIN
5587: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5588:
5589: IF NOT lines_sublines_tbl.COUNT=0 THEN
5590:
5591: i:=lines_sublines_tbl.FIRST;

Line 5731: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

5727: x_msg_tbl => l_msg_tbl );
5728: END IF;
5729:
5730:
5731: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5732: THEN
5733: idx := l_msg_tbl.COUNT;
5734: IF idx <> 0 Then
5735: idx := l_msg_tbl.FIRST;

Line 5778: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS

5774:
5775: END IF;
5776:
5777:
5778: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5779: THEN
5780: idx := l_line_msg_tbl.COUNT;
5781: IF idx <> 0 Then
5782: idx := l_line_msg_tbl.FIRST;