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 1147: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1143: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1144: l_tot_msg_count := l_tot_msg_count + 1;
1145: l_msg_data := NULL;
1146: End Loop;
1147: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: Else
1149: If l_flag <> TRUE then
1150: fnd_msg_pub.initialize;
1151:

Line 1152: OKC_API.SET_MESSAGE(

1148: Else
1149: If l_flag <> TRUE then
1150: fnd_msg_pub.initialize;
1151:
1152: OKC_API.SET_MESSAGE(
1153: p_app_name => 'OKS', --G_APP_NAME_OKS,
1154: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
1155: p_token1 => 'Line No ',
1156: p_token1_value => l_line_number);

Line 1164: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1160: x_msg_tbl(l_tot_msg_count).status := 'E';
1161: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1162: l_tot_msg_count := l_tot_msg_count + 1;
1163: l_msg_data := NULL;
1164: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1165: End If;
1166: End If;
1167:
1168: End If;

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

1202: l_clev_tbl_in(1).id := l_cle_id;
1203: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
1204: l_clev_tbl_in(1).cust_acct_id := l_head_cust_acct;
1205:
1206: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1207: fnd_msg_pub.initialize;
1208: OKC_API.SET_MESSAGE(
1209: p_app_name => G_APP_NAME_OKS,
1210: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 1208: OKC_API.SET_MESSAGE(

1204: l_clev_tbl_in(1).cust_acct_id := l_head_cust_acct;
1205:
1206: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1207: fnd_msg_pub.initialize;
1208: OKC_API.SET_MESSAGE(
1209: p_app_name => G_APP_NAME_OKS,
1210: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1211: p_token1 => 'ATTRIBUTE',
1212: p_token1_value => 'Bill To Address');

Line 1228: OKC_API.SET_MESSAGE(

1224: /* ElsIf l_head_cust_acct <> l_line_cust_acct and
1225: l_line_cust_acct is not NULL and l_head_cust_acct is not NULL Then
1226: fnd_msg_pub.initialize;
1227:
1228: OKC_API.SET_MESSAGE(
1229: p_app_name => G_APP_NAME_OKS,
1230: p_msg_name => 'OKS_CASCADE_ACCOUNT_MISMATCH',
1231: p_token1 => 'Line No ',
1232: p_token1_value => l_line_number);

Line 1242: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1238: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1239: l_tot_msg_count := l_tot_msg_count + 1;
1240: l_msg_data := NULL;
1241: If header_lines_tbl.FIRST = header_lines_tbl.LAST Then
1242: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: End If; */
1244:
1245:
1246: END IF; --l_head_cust_acct check

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

1266:
1267: l_clev_tbl_in(1).id := l_cle_id;
1268: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1271: fnd_msg_pub.initialize;
1272: OKC_API.SET_MESSAGE(
1273: p_app_name => G_APP_NAME_OKS,
1274: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 1272: OKC_API.SET_MESSAGE(

1268: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1271: fnd_msg_pub.initialize;
1272: OKC_API.SET_MESSAGE(
1273: p_app_name => G_APP_NAME_OKS,
1274: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1275: p_token1 => 'ATTRIBUTE',
1276: p_token1_value => 'Ship To Address');

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

1324: l_clev_tbl_in(1).cust_acct_id := l_header_cust_acct;
1325: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
1326: l_oks_header_id := 1;
1327:
1328: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1329: IF l_line_cust_acct IS NULL THEN
1330: fnd_msg_pub.initialize;
1331: OKC_API.SET_MESSAGE(
1332: p_app_name => G_APP_NAME_OKS,

Line 1331: OKC_API.SET_MESSAGE(

1327:
1328: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1329: IF l_line_cust_acct IS NULL THEN
1330: fnd_msg_pub.initialize;
1331: OKC_API.SET_MESSAGE(
1332: p_app_name => G_APP_NAME_OKS,
1333: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1334: p_token1 => 'ATTRIBUTE',
1335: p_token1_value => 'Bill To Address');

Line 1349: OKC_API.SET_MESSAGE(

1345:
1346:
1347:
1348: fnd_msg_pub.initialize;
1349: OKC_API.SET_MESSAGE(
1350: p_app_name => G_APP_NAME_OKS, -- bug 5468539 G_APP_NAME,
1351: p_msg_name =>'OKS_DEFAULT_ATTR_SUCCESS_NEW',
1352: p_token1 => 'TOKEN1' , -- bug 5468539 'RULE',
1353: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'));

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

1381: l_klnv_tbl_in(1).EXEMPT_CERTIFICATE_NUMBER:= NULL;
1382: l_klnv_tbl_in(1).CLE_ID := l_cle_id;
1383: l_oks_header_id := 1;
1384: -- Display a message --
1385: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1386: fnd_msg_pub.initialize;
1387: OKC_API.SET_MESSAGE(
1388: p_app_name => G_APP_NAME,
1389: p_msg_name =>'OKS_CASCADE_DELETE_EXEMPTION',

Line 1387: OKC_API.SET_MESSAGE(

1383: l_oks_header_id := 1;
1384: -- Display a message --
1385: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1386: fnd_msg_pub.initialize;
1387: OKC_API.SET_MESSAGE(
1388: p_app_name => G_APP_NAME,
1389: p_msg_name =>'OKS_CASCADE_DELETE_EXEMPTION',
1390: p_token1 =>'TOKEN1' ,
1391: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

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

1411: l_klnv_tbl_in(1).CLE_ID := l_cle_id;
1412: l_klnv_tbl_in(1).commitment_id := NULL ;
1413: l_klnv_tbl_in(1).payment_type := NULL ;
1414: -- Display a message --
1415: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1416: fnd_msg_pub.initialize;
1417: OKC_API.SET_MESSAGE(
1418: p_app_name => G_APP_NAME,
1419: p_msg_name =>'OKS_CASCADE_DELETE_COMMITMENT',

Line 1417: OKC_API.SET_MESSAGE(

1413: l_klnv_tbl_in(1).payment_type := NULL ;
1414: -- Display a message --
1415: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1416: fnd_msg_pub.initialize;
1417: OKC_API.SET_MESSAGE(
1418: p_app_name => G_APP_NAME,
1419: p_msg_name =>'OKS_CASCADE_DELETE_COMMITMENT',
1420: p_token1 =>'TOKEN1' ,
1421: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

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

1502: p_ctcv_tbl => l_ctcv_tbl_in
1503: );
1504:
1505: -- Delete Party Role --
1506: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1507: -- Check if there is any contaact Present belonging to the party role ---
1508: l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
1509: IF nvl(l_temp_contact_id,0) = 0 THEN
1510:

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

1520: x_msg_data => l_msg_data,
1521: p_cplv_tbl => l_cplv_tbl_in);
1522:
1523:
1524: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1525: Open cur_get_line_number(l_cle_id, l_chr_id);
1526: fetch cur_get_line_number into l_temp_line_number;
1527: close cur_get_line_number;
1528: fnd_msg_pub.initialize;

Line 1529: OKC_API.SET_MESSAGE(

1525: Open cur_get_line_number(l_cle_id, l_chr_id);
1526: fetch cur_get_line_number into l_temp_line_number;
1527: close cur_get_line_number;
1528: fnd_msg_pub.initialize;
1529: OKC_API.SET_MESSAGE(
1530: p_app_name => G_APP_NAME,
1531: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1532: p_token1 =>'TOKEN1' ,
1533: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

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

1543: l_tot_msg_count := l_tot_msg_count + 1;
1544: l_msg_data := NULL;
1545: END IF;
1546: ELSE
1547: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1548: Open cur_get_line_number(l_cle_id, l_chr_id);
1549: fetch cur_get_line_number into l_temp_line_number;
1550: close cur_get_line_number;
1551: fnd_msg_pub.initialize;

Line 1552: OKC_API.SET_MESSAGE(

1548: Open cur_get_line_number(l_cle_id, l_chr_id);
1549: fetch cur_get_line_number into l_temp_line_number;
1550: close cur_get_line_number;
1551: fnd_msg_pub.initialize;
1552: OKC_API.SET_MESSAGE(
1553: p_app_name => G_APP_NAME,
1554: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1555: p_token1 =>'TOKEN1' ,
1556: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

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

1568: END IF;
1569:
1570: END IF; -- IF nvl(l_temp_contact_id,0) = 0 THEN
1571: -- Bug 5227077 --
1572: ELSIF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1573: FOR i in 1..fnd_msg_pub.count_msg
1574: Loop
1575: fnd_msg_pub.get
1576: (

Line 1587: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1583: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1584: l_tot_msg_count := l_tot_msg_count + 1;
1585: l_msg_data := NULL;
1586: End Loop;
1587: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1588: END IF;
1589: -- Bug 5227077 --
1590: END IF;
1591: END IF; -- IF l_contact_id is NOT NULL THEN

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

1624: IF l_header_cust_acct <> nvl(l_line_cust_acct, -1) THEN
1625: -- Create/UPDATE a CAN RULE and Create/UPDATE the BTO Rule --
1626: l_clev_tbl_in(1).id := l_cle_id;
1627: l_clev_tbl_in(1).ship_to_site_use_id := l_okc_headers_rec.ship_to_site_use_id;
1628: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1629:
1630: IF l_line_cust_acct IS NULL THEN
1631: fnd_msg_pub.initialize;
1632: OKC_API.SET_MESSAGE(

Line 1632: OKC_API.SET_MESSAGE(

1628: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1629:
1630: IF l_line_cust_acct IS NULL THEN
1631: fnd_msg_pub.initialize;
1632: OKC_API.SET_MESSAGE(
1633: p_app_name => G_APP_NAME_OKS,
1634: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1635: p_token1 => 'ATTRIBUTE',
1636: p_token1_value => 'Ship To Address');

Line 1648: OKC_API.SET_MESSAGE(

1644: l_msg_data := NULL;
1645: END IF;
1646:
1647: fnd_msg_pub.initialize;
1648: OKC_API.SET_MESSAGE(
1649: p_app_name => G_APP_NAME_OKS, -- bug 5468539 G_APP_NAME,
1650: p_msg_name =>'OKS_DEFAULT_ATTR_SUCCESS_NEW',
1651: p_token1 => 'TOKEN1', -- bug 5468539 'RULE',
1652: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'));

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

1733: p_ctcv_tbl => l_ctcv_tbl_in
1734: );
1735:
1736: -- Delete Party Role --
1737: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1738: -- Check if there is any contaact Present belonging to the party role ---
1739: l_temp_contact_id := CHECK_LINE_CONTACT(l_chr_id,l_cpl_id);-- 5485054
1740: IF nvl(l_temp_contact_id,0) = 0 THEN
1741: -- Open Party_role_csr(l_chr_id,l_cle_id);

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

1753: x_msg_data => l_msg_data,
1754: p_cplv_tbl => l_cplv_tbl_in);
1755:
1756:
1757: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1758: Open cur_get_line_number(l_cle_id, l_chr_id);
1759: fetch cur_get_line_number into l_temp_line_number;
1760: close cur_get_line_number;
1761: fnd_msg_pub.initialize;

Line 1762: OKC_API.SET_MESSAGE(

1758: Open cur_get_line_number(l_cle_id, l_chr_id);
1759: fetch cur_get_line_number into l_temp_line_number;
1760: close cur_get_line_number;
1761: fnd_msg_pub.initialize;
1762: OKC_API.SET_MESSAGE(
1763: p_app_name => G_APP_NAME,
1764: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1765: p_token1 =>'TOKEN1' ,
1766: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'),

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

1776: l_tot_msg_count := l_tot_msg_count + 1;
1777: l_msg_data := NULL;
1778: END IF;
1779: ELSE
1780: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1781: Open cur_get_line_number(l_cle_id, l_chr_id);
1782: fetch cur_get_line_number into l_temp_line_number;
1783: close cur_get_line_number;
1784: fnd_msg_pub.initialize;

Line 1785: OKC_API.SET_MESSAGE(

1781: Open cur_get_line_number(l_cle_id, l_chr_id);
1782: fetch cur_get_line_number into l_temp_line_number;
1783: close cur_get_line_number;
1784: fnd_msg_pub.initialize;
1785: OKC_API.SET_MESSAGE(
1786: p_app_name => G_APP_NAME,
1787: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1788: p_token1 =>'TOKEN1' ,
1789: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'),

Line 1805: ELSIF l_return_status <> OKC_API.G_RET_STS_SUCCESS

1801: END IF;
1802:
1803: END IF; -- IF nvl(l_temp_contact_id,0) = 0 THEN
1804: -- Bug 5227077 --
1805: ELSIF l_return_status <> OKC_API.G_RET_STS_SUCCESS
1806: THEN
1807: FOR i in 1..fnd_msg_pub.count_msg
1808: Loop
1809: fnd_msg_pub.get

Line 1821: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1817: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1818: l_tot_msg_count := l_tot_msg_count + 1;
1819: l_msg_data := NULL;
1820: End Loop;
1821: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822:
1823: END IF;
1824: -- Bug 5227077 --
1825: END IF;

Line 1891: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1887: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1888: l_tot_msg_count := l_tot_msg_count + 1;
1889: l_msg_data := NULL;
1890: End Loop;
1891: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1892: END IF;
1893:
1894: -- Bug 5219132 --
1895: l_contact_id := CHECK_LINE_BILL_CONTACT(l_chr_id,l_cpl_id, 'OKX_CONTBILL', 'CUST_BILLING');-- Bug 5485054

Line 1937: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1933: l_tot_msg_count := l_tot_msg_count + 1;
1934: l_msg_data := NULL;
1935: End Loop;
1936: -- Bug 5227077 --
1937: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1938: ELSE
1939: fnd_msg_pub.initialize;
1940: OKC_API.SET_MESSAGE(
1941: p_app_name => G_APP_NAME_OKS,

Line 1940: OKC_API.SET_MESSAGE(

1936: -- Bug 5227077 --
1937: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1938: ELSE
1939: fnd_msg_pub.initialize;
1940: OKC_API.SET_MESSAGE(
1941: p_app_name => G_APP_NAME_OKS,
1942: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1943: p_token1 => 'ATTRIBUTE',
1944: p_token1_value => 'Bill To Contact');

Line 1982: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1978: l_tot_msg_count := l_tot_msg_count + 1;
1979: l_msg_data := NULL;
1980: End Loop;
1981: -- Bug 5227077 --
1982: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSE
1984: fnd_msg_pub.initialize;
1985: OKC_API.SET_MESSAGE(
1986: p_app_name => G_APP_NAME_OKS,

Line 1985: OKC_API.SET_MESSAGE(

1981: -- Bug 5227077 --
1982: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983: ELSE
1984: fnd_msg_pub.initialize;
1985: OKC_API.SET_MESSAGE(
1986: p_app_name => G_APP_NAME_OKS,
1987: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1988: p_token1 => 'ATTRIBUTE',
1989: p_token1_value => 'Bill To Contact');

Line 2005: OKC_API.SET_MESSAGE(

2001:
2002: ELSIF(l_header_cust_acct <> l_line_cust_acct)
2003: THEN
2004: fnd_msg_pub.initialize;
2005: OKC_API.SET_MESSAGE(
2006: p_app_name => G_APP_NAME,
2007: p_msg_name => 'OKS_CASCADE_BTOACCT_MISMATCH',
2008: p_token1 => 'Line No ',
2009: p_token1_value => l_line_number);

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

2177: --Fixed Tax exemption is cascading to line along with bug#4026268 --gbgupta
2178: --assigning tax exemption id
2179: l_klnv_tbl_in(1).tax_exemption_id := l_oks_headers_rec.tax_exemption_id;
2180: */
2181: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2182: fnd_msg_pub.initialize;
2183: OKC_API.SET_MESSAGE(
2184: p_app_name => G_APP_NAME_OKS,
2185: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2183: OKC_API.SET_MESSAGE(

2179: l_klnv_tbl_in(1).tax_exemption_id := l_oks_headers_rec.tax_exemption_id;
2180: */
2181: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2182: fnd_msg_pub.initialize;
2183: OKC_API.SET_MESSAGE(
2184: p_app_name => G_APP_NAME_OKS,
2185: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2186: p_token1 => 'ATTRIBUTE',
2187: p_token1_value => 'Tax');

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

2233: -- Ebtax --
2234: l_klnv_tbl_in(1).tax_classification_code := l_header_tax_cls_code;
2235: -- Ebtax --
2236:
2237: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2238: fnd_msg_pub.initialize;
2239: OKC_API.SET_MESSAGE(
2240: p_app_name => G_APP_NAME_OKS,
2241: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2239: OKC_API.SET_MESSAGE(

2235: -- Ebtax --
2236:
2237: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2238: fnd_msg_pub.initialize;
2239: OKC_API.SET_MESSAGE(
2240: p_app_name => G_APP_NAME_OKS,
2241: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2242: p_token1 => 'ATTRIBUTE',
2243: p_token1_value => 'Tax Code');

Line 2279: OKC_API.SET_MESSAGE

2275: IF l_bpf_invoice_rule_id = -2 THEN
2276: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2277:
2278: fnd_msg_pub.initialize;
2279: OKC_API.SET_MESSAGE
2280: (
2281: p_app_name => G_APP_NAME_OKS,
2282: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2283: p_token1 => 'TOKEN1',

Line 2295: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2291: x_msg_tbl(l_tot_msg_count).status := 'E';
2292: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2293: l_tot_msg_count := l_tot_msg_count + 1;
2294: l_msg_data := NULL;
2295: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2296: End If;
2297: End If;
2298: End If;
2299: --Fix for Bug# 3542273

Line 2348: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2344: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2345: l_tot_msg_count := l_tot_msg_count + 1;
2346: l_msg_data := NULL;
2347: End Loop;
2348: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: END IF;
2350: -- Bug 5227077 --
2351:
2352:

Line 2380: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 2429: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2425: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2426: l_tot_msg_count := l_tot_msg_count + 1;
2427: l_msg_data := NULL;
2428: End Loop;
2429: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSE
2431: fnd_msg_pub.initialize;
2432: OKC_API.SET_MESSAGE(
2433: p_app_name => G_APP_NAME_OKS,

Line 2432: OKC_API.SET_MESSAGE(

2428: End Loop;
2429: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSE
2431: fnd_msg_pub.initialize;
2432: OKC_API.SET_MESSAGE(
2433: p_app_name => G_APP_NAME_OKS,
2434: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2435: p_token1 => 'ATTRIBUTE',
2436: p_token1_value => 'Billing Schedule');

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

2464:
2465: l_clev_tbl_in(1).id := l_cle_id;
2466: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
2467:
2468: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2469: fnd_msg_pub.initialize;
2470: OKC_API.SET_MESSAGE(
2471: p_app_name => G_APP_NAME_OKS,
2472: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2470: OKC_API.SET_MESSAGE(

2466: l_clev_tbl_in(1).bill_to_site_use_id := l_okc_headers_rec.bill_to_site_use_id;
2467:
2468: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2469: fnd_msg_pub.initialize;
2470: OKC_API.SET_MESSAGE(
2471: p_app_name => G_APP_NAME_OKS,
2472: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2473: p_token1 => 'ATTRIBUTE',
2474: p_token1_value => 'Bill To Address');

Line 2489: OKC_API.SET_MESSAGE(

2485: END IF;
2486: Elsif l_billing_profile_id is NULL then
2487: --Display error message, saying required value missing.
2488: fnd_msg_pub.initialize;
2489: OKC_API.SET_MESSAGE(
2490: p_app_name => G_APP_NAME_OKS,
2491: p_msg_name => 'OKS_CASCADE_MISSING_REQD_ATTR',
2492: p_token1 => 'ATTRIBUTE',
2493: p_token1_value => 'Billing Profile');

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

2512: l_klnv_tbl_in(1).acct_rule_id := l_oks_headers_rec.acct_rule_id;
2513: END IF;
2514: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2515:
2516: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2517: fnd_msg_pub.initialize;
2518: OKC_API.SET_MESSAGE(
2519: p_app_name => G_APP_NAME_OKS,
2520: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2518: OKC_API.SET_MESSAGE(

2514: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2515:
2516: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2517: fnd_msg_pub.initialize;
2518: OKC_API.SET_MESSAGE(
2519: p_app_name => G_APP_NAME_OKS,
2520: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2521: p_token1 => 'ATTRIBUTE',
2522: p_token1_value => 'Accounting Rule');

Line 2548: OKC_API.SET_MESSAGE

2544: IF l_bpf_invoice_rule_id = -2 THEN
2545: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2546:
2547: fnd_msg_pub.initialize;
2548: OKC_API.SET_MESSAGE
2549: (
2550: p_app_name => G_APP_NAME_OKS,
2551: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2552: p_token1 => 'TOKEN1',

Line 2564: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2560: x_msg_tbl(l_tot_msg_count).status := 'E';
2561: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2562: l_tot_msg_count := l_tot_msg_count + 1;
2563: l_msg_data := NULL;
2564: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2565: End If;
2566: End If;
2567: End If;
2568: --Fix for Bug# 3542273

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

2569:
2570: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
2571: l_klnv_tbl_in(1).acct_rule_id := l_bpf_acct_rule_id;
2572:
2573: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2574: fnd_msg_pub.initialize;
2575: OKC_API.SET_MESSAGE(
2576: p_app_name => G_APP_NAME_OKS,
2577: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2575: OKC_API.SET_MESSAGE(

2571: l_klnv_tbl_in(1).acct_rule_id := l_bpf_acct_rule_id;
2572:
2573: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2574: fnd_msg_pub.initialize;
2575: OKC_API.SET_MESSAGE(
2576: p_app_name => G_APP_NAME_OKS,
2577: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2578: p_token1 => 'ATTRIBUTE',
2579: p_token1_value => 'Accounting Rule');

Line 2612: OKC_API.SET_MESSAGE

2608: If l_clev_tbl_in(1).inv_rule_id = -2 then
2609: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2610:
2611: fnd_msg_pub.initialize;
2612: OKC_API.SET_MESSAGE
2613: (
2614: p_app_name => G_APP_NAME_OKS,
2615: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2616: p_token1 => 'TOKEN1',

Line 2628: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2624: x_msg_tbl(l_tot_msg_count).status := 'E';
2625: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2626: l_tot_msg_count := l_tot_msg_count + 1;
2627: l_msg_data := NULL;
2628: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2629: End If;
2630: End If;
2631: End If;
2632: --Fix for Bug# 3542273

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

2641: x_msg_count => l_msg_count,
2642: x_msg_data => l_msg_data
2643: );
2644:
2645: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2646: fnd_msg_pub.initialize;
2647: OKC_API.SET_MESSAGE(
2648: p_app_name => G_APP_NAME_OKS,
2649: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2647: OKC_API.SET_MESSAGE(

2643: );
2644:
2645: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2646: fnd_msg_pub.initialize;
2647: OKC_API.SET_MESSAGE(
2648: p_app_name => G_APP_NAME_OKS,
2649: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2650: p_token1 => 'ATTRIBUTE',
2651: p_token1_value => 'Invoicing Rule');

Line 2676: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2672: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2673: l_tot_msg_count := l_tot_msg_count + 1;
2674: l_msg_data := NULL;
2675: End Loop;
2676: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2677: END IF;
2678: -- Bug 5227077 --
2679:
2680: ELSIF l_header_ire is NULL AND l_billing_profile IS NOT NULL and

Line 2692: OKC_API.SET_MESSAGE

2688: If l_usage_type in ('VRT','QTY') then
2689: IF l_bpf_invoice_rule_id = -2 THEN
2690: l_token1_value := fnd_meaning(l_usage_type,'OKS_USAGE_TYPE');
2691: fnd_msg_pub.initialize;
2692: OKC_API.SET_MESSAGE
2693: (
2694: p_app_name => G_APP_NAME_OKS,
2695: p_msg_name => 'OKS_USAGE_ATTR_CHECK',
2696: p_token1 => 'TOKEN1',

Line 2707: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2703: x_msg_tbl(l_tot_msg_count).status := 'E';
2704: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2705: l_tot_msg_count := l_tot_msg_count + 1;
2706: l_msg_data := NULL;
2707: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2708: End If;
2709: End If;
2710: End If;
2711: --Fix for Bug# 3542273

Line 2742: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: End Loop;
2742: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2743:
2744: ELSE
2745: fnd_msg_pub.initialize;
2746: OKC_API.SET_MESSAGE(

Line 2746: OKC_API.SET_MESSAGE(

2742: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2743:
2744: ELSE
2745: fnd_msg_pub.initialize;
2746: OKC_API.SET_MESSAGE(
2747: p_app_name => G_APP_NAME_OKS,
2748: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2749: p_token1 => 'ATTRIBUTE',
2750: p_token1_value => 'Invoicing Rule');

Line 2803: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2799: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2800: l_tot_msg_count := l_tot_msg_count + 1;
2801: l_msg_data := NULL;
2802: End Loop;
2803: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2804: End if;
2805: -- Bug 5227077 --
2806:
2807: END IF; -- End if for plsql table count.

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

2813: ,X_return_status => l_return_status
2814: );
2815:
2816:
2817: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2818: fnd_msg_pub.initialize;
2819: OKC_API.SET_MESSAGE(
2820: p_app_name => G_APP_NAME_OKS,
2821: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',

Line 2819: OKC_API.SET_MESSAGE(

2815:
2816:
2817: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2818: fnd_msg_pub.initialize;
2819: OKC_API.SET_MESSAGE(
2820: p_app_name => G_APP_NAME_OKS,
2821: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2822: p_token1 => 'ATTRIBUTE',
2823: p_token1_value => 'Sales Credit');

Line 2847: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2843: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2844: l_tot_msg_count := l_tot_msg_count + 1;
2845: l_msg_data := NULL;
2846: End Loop;
2847: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2848: End if;
2849: -- Bug 5227077 --
2850:
2851: END IF;

Line 2929: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2925: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2926: l_tot_msg_count := l_tot_msg_count + 1;
2927: l_msg_data := NULL;
2928: End Loop;
2929: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2930: end if;
2931: -- Bug 5227077 --
2932:
2933: END IF;

Line 2972: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2968: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2969: l_tot_msg_count := l_tot_msg_count + 1;
2970: l_msg_data := NULL;
2971: End Loop;
2972: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2973: End if;
2974: -- Bug 5227077 --
2975:
2976: END IF;

Line 3028: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3024: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3025: l_tot_msg_count := l_tot_msg_count + 1;
3026: l_msg_data := NULL;
3027: End Loop;
3028: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3029: End if;
3030: -- Bug 5227077 --
3031:
3032: END IF;

Line 3074: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3070: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3071: l_tot_msg_count := l_tot_msg_count + 1;
3072: l_msg_data := NULL;
3073: End Loop;
3074: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3075: End if;
3076: -- Bug 5227077 --
3077:
3078: END IF;

Line 3106: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 3166: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3162: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3163: l_tot_msg_count := l_tot_msg_count + 1;
3164: l_msg_data := NULL;
3165: End Loop;
3166: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3167: End if;
3168: -- Bug 5227077 --
3169:
3170: END IF;

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

3175:
3176: END IF;
3177:
3178: IF l_payment_method_com = 1 OR l_cust_po_flag = 0 OR l_payment_method_ccr = 1 THEN
3179: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3180:
3181: fnd_msg_pub.initialize;
3182: OKC_API.SET_MESSAGE(
3183: p_app_name => G_APP_NAME_OKS,

Line 3182: OKC_API.SET_MESSAGE(

3178: IF l_payment_method_com = 1 OR l_cust_po_flag = 0 OR l_payment_method_ccr = 1 THEN
3179: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3180:
3181: fnd_msg_pub.initialize;
3182: OKC_API.SET_MESSAGE(
3183: p_app_name => G_APP_NAME_OKS,
3184: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3185: p_token1 => 'ATTRIBUTE',
3186: p_token1_value => 'Payment Method');

Line 3208: OKC_API.SET_MESSAGE(

3204: l_klnv_tbl_in(1).ID := l_oks_lines_rec.ID;
3205: l_klnv_tbl_in(1).price_uom := l_oks_headers_rec.price_uom;
3206: ----errorout('UOM-'||l_klnv_tbl_in(1).price_uom);
3207: fnd_msg_pub.initialize;
3208: OKC_API.SET_MESSAGE(
3209: p_app_name => G_APP_NAME_OKS,
3210: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3211: p_token1 => 'ATTRIBUTE',
3212: p_token1_value => 'Price UOM');

Line 3239: OKC_API.SET_MESSAGE(

3235:
3236: IF NVL(l_validate_result,'N') IN ('U' ,'N') then -- Unexpected Error
3237: fnd_msg_pub.initialize;
3238: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,p_encoded => fnd_api.g_false);
3239: OKC_API.SET_MESSAGE(
3240: p_app_name => 'OKS', --G_APP_NAME_OKS,
3241: p_msg_name => 'OKS_INVALID_PRICE_LIST');
3242: x_msg_tbl(l_tot_msg_count).status := 'E';
3243: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 3246: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3242: x_msg_tbl(l_tot_msg_count).status := 'E';
3243: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3244: l_tot_msg_count := l_tot_msg_count + 1;
3245: l_msg_data := NULL;
3246: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3247: END IF;
3248:
3249: l_clev_tbl_in(1).ID := l_okc_lines_rec.ID;
3250: l_clev_tbl_in(1).price_list_id := l_okc_headers_rec.price_list_id;

Line 3283: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3279: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3280: l_tot_msg_count := l_tot_msg_count + 1;
3281: l_msg_data := NULL;
3282: End Loop;
3283: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3284: End if;
3285: -- Bug 5227077 --
3286:
3287: l_locked_prl_cnt := l_locked_prl_cnt + 1;

Line 3295: OKC_API.SET_MESSAGE(

3291: l_klnv_tbl_in(1).locked_price_list_line_id := null;
3292:
3293:
3294: fnd_msg_pub.initialize;
3295: OKC_API.SET_MESSAGE(
3296: p_app_name => G_APP_NAME_OKS,
3297: p_msg_name => 'OKS_HEADER_CASCADE_WARNING',
3298: p_token1 => 'ATTRIBUTE',
3299: p_token1_value => 'Price List');

Line 3311: OKC_API.SET_MESSAGE(

3307: ELSE
3308: -- To display the Cascade Message when
3309: -- Usage lines is not locked and the cascade take place --
3310: fnd_msg_pub.initialize;
3311: OKC_API.SET_MESSAGE(
3312: p_app_name => G_APP_NAME_OKS,
3313: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3314: p_token1 => 'ATTRIBUTE',
3315: p_token1_value => 'Price List');

Line 3327: OKC_API.SET_MESSAGE(

3323:
3324: END IF;
3325: Else
3326: fnd_msg_pub.initialize;
3327: OKC_API.SET_MESSAGE(
3328: p_app_name => G_APP_NAME_OKS,
3329: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3330: p_token1 => 'ATTRIBUTE',
3331: p_token1_value => 'Price List');

Line 3398: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3394: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3395: l_tot_msg_count := l_tot_msg_count + 1;
3396: l_msg_data := NULL;
3397: End Loop;
3398: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3399: End If;
3400:
3401:
3402: END IF;

Line 3447: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3443: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3444: l_tot_msg_count := l_tot_msg_count + 1;
3445: l_msg_data := NULL;
3446: End Loop;
3447: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3448: End If;
3449:
3450: END IF;
3451:

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

3489:
3490: End Loop;
3491: end if;
3492: -- Bug 5381082 --
3493: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3494: FOR i in 1..fnd_msg_pub.count_msg
3495: Loop
3496: fnd_msg_pub.get
3497: (

Line 3508: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3504: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3505: l_tot_msg_count := l_tot_msg_count + 1;
3506: l_msg_data := NULL;
3507: End Loop;
3508: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3509: End If;
3510: -- BUg 5381082 --
3511: END IF;
3512: -- End 8/23/2005 hkamdar R12 Partial Period

Line 3552: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3548: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3549: l_tot_msg_count := l_tot_msg_count + 1;
3550: l_msg_data := NULL;
3551: End Loop;
3552: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3553:
3554: ELSE
3555: -- Bug 5191587 --
3556: If l_okc_lines_rec.lse_id in ('1','14', '19') and l_sr_number IS NOT NULL

Line 3560: OKC_API.SET_MESSAGE(

3556: If l_okc_lines_rec.lse_id in ('1','14', '19') and l_sr_number IS NOT NULL
3557: then
3558: fnd_msg_pub.initialize;
3559:
3560: OKC_API.SET_MESSAGE(
3561: p_app_name => G_APP_NAME_OKS,
3562: p_msg_name => 'OKS_HEADER_CASCADE_SR_SUCCESS',
3563: p_token1 => 'SR#',
3564: p_token1_value => l_sr_number,

Line 3581: OKC_API.SET_MESSAGE(

3577:
3578: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3579: IF(l_disp_warning ='Y') THEN
3580:
3581: OKC_API.SET_MESSAGE(
3582: p_app_name => G_APP_NAME_OKS,
3583: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3584:
3585: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3588: OKC_API.SET_MESSAGE(

3584:
3585: x_msg_tbl(l_tot_msg_count).status := 'W';
3586: ELSE
3587:
3588: OKC_API.SET_MESSAGE(
3589: p_app_name => G_APP_NAME_OKS,
3590: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3591: p_token1 => 'ATTRIBUTE',
3592: p_token1_value => 'Date');

Line 3609: OKC_API.SET_MESSAGE(

3605:
3606: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3607: IF(l_disp_warning ='Y') THEN
3608:
3609: OKC_API.SET_MESSAGE(
3610: p_app_name => G_APP_NAME_OKS,
3611: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3612:
3613: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3615: OKC_API.SET_MESSAGE(

3611: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3612:
3613: x_msg_tbl(l_tot_msg_count).status := 'W';
3614: ELSE
3615: OKC_API.SET_MESSAGE(
3616: p_app_name => G_APP_NAME_OKS,
3617: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3618: p_token1 => 'ATTRIBUTE',
3619: p_token1_value => 'Date');

Line 3634: OKC_API.SET_MESSAGE

3630: END IF;
3631:
3632: Else --LineCov_cur% not Found Then
3633: fnd_msg_pub.initialize;
3634: OKC_API.SET_MESSAGE
3635: (
3636: p_app_name => G_APP_NAME_OKS,
3637: p_msg_name => 'OKS_CASCADE_COV_NOT_FOUND',
3638: p_token2 => 'Line No ',

Line 3681: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3677: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3678: l_tot_msg_count := l_tot_msg_count + 1;
3679: l_msg_data := NULL;
3680: End Loop;
3681: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3682: end if;
3683: -- Bug 5227077 --
3684:
3685: End If;

Line 3690: OKC_API.SET_MESSAGE(

3686: -- Bug 5191587 --
3687: ELSIf l_okc_lines_rec.lse_id in ('1','14','19') AND nvl(l_oks_lines_rec.standard_cov_yn, 'N') = 'Y' then
3688: If l_sr_number IS NOT NULL then
3689: fnd_msg_pub.initialize;
3690: OKC_API.SET_MESSAGE(
3691: p_app_name => G_APP_NAME_OKS,
3692: p_msg_name => 'OKS_HEADER_CASCADE_SR_SUCCESS',
3693: p_token1 => 'SR#',
3694: p_token1_value => l_sr_number,

Line 3710: OKC_API.SET_MESSAGE(

3706: fnd_msg_pub.initialize;
3707: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3708: IF(l_disp_warning ='Y') THEN
3709:
3710: OKC_API.SET_MESSAGE(
3711: p_app_name => G_APP_NAME_OKS,
3712: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3713:
3714: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3717: OKC_API.SET_MESSAGE(

3713:
3714: x_msg_tbl(l_tot_msg_count).status := 'W';
3715: ELSE
3716:
3717: OKC_API.SET_MESSAGE(
3718: p_app_name => G_APP_NAME_OKS,
3719: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3720: p_token1 => 'ATTRIBUTE',
3721: p_token1_value => 'Date');

Line 3738: OKC_API.SET_MESSAGE(

3734:
3735: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3736: IF(l_disp_warning ='Y') THEN
3737:
3738: OKC_API.SET_MESSAGE(
3739: p_app_name => G_APP_NAME_OKS,
3740: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3741:
3742: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3745: OKC_API.SET_MESSAGE(

3741:
3742: x_msg_tbl(l_tot_msg_count).status := 'W';
3743: ELSE
3744:
3745: OKC_API.SET_MESSAGE(
3746: p_app_name => G_APP_NAME_OKS,
3747: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3748: p_token1 => 'ATTRIBUTE',
3749: p_token1_value => 'Date');

Line 3768: OKC_API.SET_MESSAGE(

3764:
3765: -- Issue a warning message if dates are cascaded from header to lines for a fully billed contract.
3766: IF(l_disp_warning ='Y') THEN
3767:
3768: OKC_API.SET_MESSAGE(
3769: p_app_name => G_APP_NAME_OKS,
3770: p_msg_name => 'OKS_HEADER_CASCADE_DATES_WARN');
3771:
3772: x_msg_tbl(l_tot_msg_count).status := 'W';

Line 3775: OKC_API.SET_MESSAGE(

3771:
3772: x_msg_tbl(l_tot_msg_count).status := 'W';
3773: ELSE
3774:
3775: OKC_API.SET_MESSAGE(
3776: p_app_name => G_APP_NAME_OKS,
3777: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3778: p_token1 => 'ATTRIBUTE',
3779: p_token1_value => 'Date');

Line 3809: p_init_msg_list => OKC_API.G_TRUE,

3805: G_RAIL_REC.amount := sub_line_rec.price_negotiated;
3806: OKS_TAX_UTIL_PVT.Get_Tax
3807: (
3808: p_api_version => 1.0,
3809: p_init_msg_list => OKC_API.G_TRUE,
3810: p_chr_id => l_chr_id,
3811: p_cle_id => sub_line_rec.id, --l_cle_id,
3812: px_rail_rec => G_RAIL_REC,
3813: x_msg_count => x_msg_count,

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

3814: x_msg_data => x_msg_data,
3815: x_return_status => l_return_status
3816: );
3817:
3818: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3819: FOR i in 1..fnd_msg_pub.count_msg
3820: Loop
3821: fnd_msg_pub.get
3822: (

Line 3833: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3829: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3830: l_tot_msg_count := l_tot_msg_count + 1;
3831: l_msg_data := NULL;
3832: End Loop;
3833: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3834: End If;
3835:
3836: l_UNIT_SELLING_PRICE := G_RAIL_REC.UNIT_SELLING_PRICE;
3837: l_QUANTITY := G_RAIL_REC.QUANTITY;

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

3883: p_validate_yn => 'N'
3884: );
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 3903: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3899: l_tot_msg_count := l_tot_msg_count + 1;
3900: l_msg_data := NULL;
3901: End Loop;
3902:
3903: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3904: End If;
3905: /*
3906: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3907: fnd_msg_pub.initialize;

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

3902:
3903: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3904: End If;
3905: /*
3906: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3907: fnd_msg_pub.initialize;
3908: OKC_API.SET_MESSAGE(
3909: p_app_name => G_APP_NAME_OKS,
3910: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 3908: OKC_API.SET_MESSAGE(

3904: End If;
3905: /*
3906: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
3907: fnd_msg_pub.initialize;
3908: OKC_API.SET_MESSAGE(
3909: p_app_name => G_APP_NAME_OKS,
3910: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
3911: p_token1 => 'ATTRIBUTE',
3912: p_token1_value => 'Recalculate Tax');

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

3950: x_klnv_tbl => l_klnv_tbl_out,
3951: p_validate_yn => 'N'
3952: );
3953: -- Bug 5227077 --
3954: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3955: FOR i in 1..fnd_msg_pub.count_msg
3956: Loop
3957: fnd_msg_pub.get
3958: (

Line 3969: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3965: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3966: l_tot_msg_count := l_tot_msg_count + 1;
3967: l_msg_data := NULL;
3968: End Loop;
3969: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3970: End If;
3971:
3972: ELSE -- this is to check for lse_id = 46
3973: OKS_TAX_UTIL_PVT.Get_Tax

Line 3976: p_init_msg_list => OKC_API.G_TRUE,

3972: ELSE -- this is to check for lse_id = 46
3973: OKS_TAX_UTIL_PVT.Get_Tax
3974: (
3975: p_api_version => 1.0,
3976: p_init_msg_list => OKC_API.G_TRUE,
3977: p_chr_id => l_chr_id,
3978: p_cle_id => l_cle_id,
3979: px_rail_rec => G_RAIL_REC,
3980: x_msg_count => x_msg_count,

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

3981: x_msg_data => x_msg_data,
3982: x_return_status => l_return_status
3983: );
3984: -- Bug 5227077 --
3985: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3986: FOR i in 1..fnd_msg_pub.count_msg
3987: Loop
3988: fnd_msg_pub.get
3989: (

Line 4000: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3996: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3997: l_tot_msg_count := l_tot_msg_count + 1;
3998: l_msg_data := NULL;
3999: End Loop;
4000: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4001: End If;
4002: -- Bug 5227077 --
4003: l_UNIT_SELLING_PRICE := G_RAIL_REC.UNIT_SELLING_PRICE;
4004: l_QUANTITY := G_RAIL_REC.QUANTITY;

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

4035: p_validate_yn => 'N'
4036: );
4037:
4038:
4039: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4040: FOR i in 1..fnd_msg_pub.count_msg
4041: Loop
4042: fnd_msg_pub.get
4043: (

Line 4054: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4050: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4051: l_tot_msg_count := l_tot_msg_count + 1;
4052: l_msg_data := NULL;
4053: End Loop;
4054: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4055: End If;
4056: /*
4057: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4058: fnd_msg_pub.initialize;

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

4053: End Loop;
4054: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4055: End If;
4056: /*
4057: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4058: fnd_msg_pub.initialize;
4059: OKC_API.SET_MESSAGE(
4060: p_app_name => G_APP_NAME_OKS,
4061: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 4059: OKC_API.SET_MESSAGE(

4055: End If;
4056: /*
4057: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4058: fnd_msg_pub.initialize;
4059: OKC_API.SET_MESSAGE(
4060: p_app_name => G_APP_NAME_OKS,
4061: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4062: p_token1 => 'ATTRIBUTE',
4063: p_token1_value => 'Recalculate Tax');

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

4092: x_msg_data => l_msg_data,
4093: p_khrv_tbl => l_khrv_tbl_type_in,
4094: x_khrv_tbl => l_khrv_tbl_type_out,
4095: p_validate_yn => 'N');
4096: If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4097: FOR i in 1..fnd_msg_pub.count_msg
4098: Loop
4099: fnd_msg_pub.get
4100: (

Line 4111: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4107: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4108: l_tot_msg_count := l_tot_msg_count + 1;
4109: l_msg_data := NULL;
4110: End Loop;
4111: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4112: End If;
4113: -- Bug 5227077 --
4114:
4115:

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

4112: End If;
4113: -- Bug 5227077 --
4114:
4115:
4116: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4117: fnd_msg_pub.initialize;
4118: OKC_API.SET_MESSAGE(
4119: p_app_name => G_APP_NAME_OKS,
4120: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',

Line 4118: OKC_API.SET_MESSAGE(

4114:
4115:
4116: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4117: fnd_msg_pub.initialize;
4118: OKC_API.SET_MESSAGE(
4119: p_app_name => G_APP_NAME_OKS,
4120: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4121: p_token1 => 'ATTRIBUTE',
4122: p_token1_value => 'Recalculate Tax');

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

4139: p_top_line_id => l_cle_id,
4140: x_return_status => l_return_status,
4141: x_msg_count => l_msg_count,
4142: x_msg_data => l_msg_data);
4143: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4144:
4145: FOR i in 1..fnd_msg_pub.count_msg
4146: Loop
4147: fnd_msg_pub.get

Line 4160: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4156: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4157: l_tot_msg_count := l_tot_msg_count + 1;
4158: l_msg_data := NULL;
4159: End Loop;
4160: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4161:
4162: End If;
4163:
4164: --Fix for Bug#3635291;

Line 4199: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4195: When G_EXCEPTION_HALT_VALIDATION Then
4196: x_return_status := l_return_status;
4197: x_msg_data := l_msg_data;
4198: When Others Then
4199: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4200: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4201: x_msg_data := l_msg_data;
4202: END Default_header_to_lines;
4203:

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

4196: x_return_status := l_return_status;
4197: x_msg_data := l_msg_data;
4198: When Others Then
4199: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4200: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4201: x_msg_data := l_msg_data;
4202: END Default_header_to_lines;
4203:
4204: ----------------------------------------------------------------------------------------------

Line 4296: l_error_tbl OKC_API.ERROR_TBL_TYPE;

4292: l_clev_tbl_out okc_contract_pub.clev_tbl_type;
4293: l_cle_id NUMBER;
4294: p_cle_id NUMBER;
4295:
4296: l_error_tbl OKC_API.ERROR_TBL_TYPE;
4297: p_klnv_tbl oks_kln_pvt.klnv_tbl_type;
4298: l_klnv_tbl oks_kln_pvt.klnv_tbl_type := p_klnv_tbl;
4299: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
4300: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type;

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

4353: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4354: l_klnv_tbl_in(1).invoice_text := l_oks_lines_rec.invoice_text;
4355: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4356:
4357: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4358: OKC_API.SET_MESSAGE(
4359: p_app_name => G_APP_NAME_OKS,
4360: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4361: p_token1 => 'ATTRIBUTE',

Line 4358: OKC_API.SET_MESSAGE(

4354: l_klnv_tbl_in(1).invoice_text := l_oks_lines_rec.invoice_text;
4355: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4356:
4357: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4358: OKC_API.SET_MESSAGE(
4359: p_app_name => G_APP_NAME_OKS,
4360: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4361: p_token1 => 'ATTRIBUTE',
4362: p_token1_value => 'Invoicing Text');

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

4378:
4379: l_clev_tbl_in(1).id := l_subline_id;
4380: l_clev_tbl_in(1).line_renewal_type_code := l_okc_lines_rec.line_renewal_type_code;
4381:
4382: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4383: OKC_API.SET_MESSAGE(
4384: p_app_name => G_APP_NAME_OKS,
4385: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4386: p_token1 => 'ATTRIBUTE',

Line 4383: OKC_API.SET_MESSAGE(

4379: l_clev_tbl_in(1).id := l_subline_id;
4380: l_clev_tbl_in(1).line_renewal_type_code := l_okc_lines_rec.line_renewal_type_code;
4381:
4382: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4383: OKC_API.SET_MESSAGE(
4384: p_app_name => G_APP_NAME_OKS,
4385: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4386: p_token1 => 'ATTRIBUTE',
4387: p_token1_value => 'Renewal');

Line 4442: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4438: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4439: l_tot_msg_count := l_tot_msg_count + 1;
4440: l_msg_data := NULL;
4441: End Loop;
4442: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4443: Else
4444: If l_flag <> TRUE then
4445: fnd_msg_pub.initialize;
4446: OKC_API.SET_MESSAGE(

Line 4446: OKC_API.SET_MESSAGE(

4442: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4443: Else
4444: If l_flag <> TRUE then
4445: fnd_msg_pub.initialize;
4446: OKC_API.SET_MESSAGE(
4447: p_app_name => 'OKS', --G_APP_NAME_OKS,
4448: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
4449: p_token1 => 'Sub Line No ',
4450: p_token1_value => l_sub_line_seq_number);

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

4484: l_clev_tbl_in(1).sts_code :='EXPIRED';
4485: End if;
4486: End if;
4487:
4488: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4489: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4490: IF(l_disp_warning ='Y') THEN
4491: OKC_API.SET_MESSAGE(
4492: p_app_name => G_APP_NAME_OKS,

Line 4491: OKC_API.SET_MESSAGE(

4487:
4488: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4489: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4490: IF(l_disp_warning ='Y') THEN
4491: OKC_API.SET_MESSAGE(
4492: p_app_name => G_APP_NAME_OKS,
4493: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4494: x_msg_tbl(l_tot_msg_count).status := 'W';
4495:

Line 4498: OKC_API.SET_MESSAGE(

4494: x_msg_tbl(l_tot_msg_count).status := 'W';
4495:
4496: ELSE
4497:
4498: OKC_API.SET_MESSAGE(
4499: p_app_name => G_APP_NAME_OKS,
4500: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4501: p_token1 => 'ATTRIBUTE',
4502: p_token1_value => 'Date');

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

4521: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4522: l_klnv_tbl_in(1).inv_print_flag := l_oks_lines_rec.inv_print_flag;
4523: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4524:
4525: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4526: OKC_API.SET_MESSAGE(
4527: p_app_name => G_APP_NAME_OKS,
4528: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4529: p_token1 => 'ATTRIBUTE',

Line 4526: OKC_API.SET_MESSAGE(

4522: l_klnv_tbl_in(1).inv_print_flag := l_oks_lines_rec.inv_print_flag;
4523: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4524:
4525: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4526: OKC_API.SET_MESSAGE(
4527: p_app_name => G_APP_NAME_OKS,
4528: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4529: p_token1 => 'ATTRIBUTE',
4530: p_token1_value => 'Invoicing Print Flag');

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

4561: l_klnv_tbl_in(1).ID := l_oks_sub_lines_rec.id;--l_subline_id;
4562: l_klnv_tbl_in(1).price_uom := l_oks_lines_rec.price_uom;
4563: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4564:
4565: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4566: OKC_API.SET_MESSAGE(
4567: p_app_name => G_APP_NAME_OKS,
4568: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4569: p_token1 => 'ATTRIBUTE',

Line 4566: OKC_API.SET_MESSAGE(

4562: l_klnv_tbl_in(1).price_uom := l_oks_lines_rec.price_uom;
4563: l_klnv_tbl_in(1).object_version_number := l_oks_sub_lines_rec.object_version_number;
4564:
4565: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4566: OKC_API.SET_MESSAGE(
4567: p_app_name => G_APP_NAME_OKS,
4568: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4569: p_token1 => 'ATTRIBUTE',
4570: p_token1_value => 'Price UOM');

Line 4581: /* OKC_API.SET_MESSAGE(

4577: l_msg_data := NULL;
4578: fnd_msg_pub.initialize;
4579: END IF;
4580: Else
4581: /* OKC_API.SET_MESSAGE(
4582: p_app_name => G_APP_NAME_OKS,
4583: p_msg_name => 'OKS_LINE_CASCADE_ERROR',
4584: p_token1 => 'ATTRIBUTE',
4585: p_token1_value => 'Price UOM');

Line 4604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4600: When G_EXCEPTION_HALT_VALIDATION Then
4601: x_return_status := 'E';
4602: x_msg_data := l_msg_data;
4603: When Others Then
4604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4605: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4606: x_msg_data := l_msg_data;
4607:
4608: --new

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

4601: x_return_status := 'E';
4602: x_msg_data := l_msg_data;
4603: When Others Then
4604: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4605: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
4606: x_msg_data := l_msg_data;
4607:
4608: --new
4609:

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

4688: p_service_Line_Id => l_cle_id,
4689: p_New_Start_Date => line_dates_rec.start_date,
4690: p_New_End_Date => line_dates_rec.end_date );
4691:
4692: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4693: FOR i in 1..fnd_msg_pub.count_msg
4694: Loop
4695: fnd_msg_pub.get
4696: (

Line 4707: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4703: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4704: l_tot_msg_count := l_tot_msg_count + 1;
4705: l_msg_data := NULL;
4706: End Loop;
4707: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4708: End If;
4709:
4710: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4711:

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

4706: End Loop;
4707: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4708: End If;
4709:
4710: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
4711:
4712: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4713: IF(l_disp_warning ='Y') THEN
4714:

Line 4715: OKC_API.SET_MESSAGE(

4711:
4712: -- Issue a warning message if dates are cascaded from lines to sublines for a fully billed contract.
4713: IF(l_disp_warning ='Y') THEN
4714:
4715: OKC_API.SET_MESSAGE(
4716: p_app_name => G_APP_NAME_OKS,
4717: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4718:
4719: ELSE

Line 4721: OKC_API.SET_MESSAGE(

4717: p_msg_name => 'OKS_LINES_CASCADE_DATES_WARN');
4718:
4719: ELSE
4720:
4721: OKC_API.SET_MESSAGE(
4722: p_app_name => G_APP_NAME_OKS,
4723: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4724: p_token1 => 'ATTRIBUTE',
4725: p_token1_value => 'Date');

Line 4749: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4745: );
4746: -- Bug 5227077 --
4747: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4748:
4749: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: end if;
4751: -- Bug 5227077 --
4752:
4753:

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

4773:
4774: -- errorout_vg('After oks_contract_line_pub.update_line status '||l_return_status);
4775: --errorout_gsi('After oks_contract_line_pub.update_line Message '||l_msg_data);
4776:
4777: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4778:
4779: FOR i in 1..fnd_msg_pub.count_msg
4780: Loop
4781: fnd_msg_pub.get

Line 4794: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4790: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4791: l_tot_msg_count := l_tot_msg_count + 1;
4792: l_msg_data := NULL;
4793: End Loop;
4794: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4795: End If;
4796:
4797: END IF;
4798:

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

4808: x_msg_count => l_msg_count,
4809: x_msg_data => l_msg_data
4810: );
4811:
4812: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4813: FOR i in 1..fnd_msg_pub.count_msg
4814: Loop
4815: fnd_msg_pub.get
4816: (

Line 4828: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4824: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4825: l_tot_msg_count := l_tot_msg_count + 1;
4826: l_msg_data := NULL;
4827: End Loop;
4828: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4829:
4830: End If;
4831:
4832: END IF;

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

4883: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4884: l_tot_msg_count := l_tot_msg_count + 1;
4885: l_msg_data := NULL;
4886: End Loop;
4887: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4888: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4889: End If;
4890: END IF ;
4891: ELSE

Line 4888: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4884: l_tot_msg_count := l_tot_msg_count + 1;
4885: l_msg_data := NULL;
4886: End Loop;
4887: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4888: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4889: End If;
4890: END IF ;
4891: ELSE
4892: -- errorout_vg('Calling subline_common_attributes Third');

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

4914: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4915: l_tot_msg_count := l_tot_msg_count + 1;
4916: l_msg_data := NULL;
4917: End Loop;
4918: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4919: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920: End If;
4921: END IF;
4922:

Line 4919: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4915: l_tot_msg_count := l_tot_msg_count + 1;
4916: l_msg_data := NULL;
4917: End Loop;
4918: IF ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4919: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920: End If;
4921: END IF;
4922:
4923: -- END GCAHDHA --

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

4939: x_klnv_tbl => l_klnv_tbl_out,
4940: p_validate_yn => 'N'
4941: );
4942:
4943: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4944: FOR i in 1..fnd_msg_pub.count_msg
4945: Loop
4946: fnd_msg_pub.get
4947: (

Line 4959: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4955: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4956: l_tot_msg_count := l_tot_msg_count + 1;
4957: l_msg_data := NULL;
4958: End Loop;
4959: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4960:
4961: End If;
4962:
4963: END IF;

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

4974: x_return_status => l_return_status,
4975: x_msg_count => l_msg_count,
4976: x_msg_data => l_msg_data
4977: );
4978: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
4979: FOR i in 1..fnd_msg_pub.count_msg
4980: Loop
4981: fnd_msg_pub.get
4982: (

Line 4994: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4990: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4991: l_tot_msg_count := l_tot_msg_count + 1;
4992: l_msg_data := NULL;
4993: End Loop;
4994: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4995: End If;
4996:
4997: END IF;
4998: -- errorout_vg('I -- Before Calling oks_qp_int_pvt.compute_Price lse_id ' || l_sub_line_rec.lse_id );

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

5035: l_count := l_status_tbl.NEXT(l_count);
5036: End Loop;
5037: END IF;
5038: -- Bug 5381082 --
5039: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5040: FOR i in 1..fnd_msg_pub.count_msg
5041: Loop
5042: fnd_msg_pub.get
5043: (

Line 5054: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5050: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5051: l_tot_msg_count := l_tot_msg_count + 1;
5052: l_msg_data := NULL;
5053: End Loop;
5054: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5055: End If;
5056: -- Bug 5381082 --
5057: End if;
5058:

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

5105: l_count := l_status_tbl.NEXT(l_count);
5106: End Loop;
5107: END IF;
5108: -- Bug 5381082 --
5109: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5110: FOR i in 1..fnd_msg_pub.count_msg
5111: Loop
5112: fnd_msg_pub.get
5113: (

Line 5124: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5120: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5121: l_tot_msg_count := l_tot_msg_count + 1;
5122: l_msg_data := NULL;
5123: End Loop;
5124: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5125: End If;
5126: -- Bug 5381082 --
5127: End if;
5128:

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

5141: x_return_status => l_return_status,
5142: x_msg_count => l_msg_count,
5143: x_msg_data => l_msg_data);
5144: --errorout_gsi('After OKS_BILL_SCH.Cascade_Dates_SLL status '||l_return_status);
5145: If ( l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5146: FOR i in 1..fnd_msg_pub.count_msg
5147: Loop
5148: fnd_msg_pub.get
5149: (

Line 5161: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5157: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5158: l_tot_msg_count := l_tot_msg_count + 1;
5159: l_msg_data := NULL;
5160: End Loop;
5161: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162:
5163: End If;
5164: END LOOP;
5165: END IF;

Line 5195: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5191: When G_EXCEPTION_HALT_VALIDATION Then
5192: x_return_status := 'E';
5193: x_msg_data := l_msg_data;
5194: When Others Then
5195: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5196: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5197: x_msg_data := l_msg_data;
5198:
5199: --new

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

5192: x_return_status := 'E';
5193: x_msg_data := l_msg_data;
5194: When Others Then
5195: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5196: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5197: x_msg_data := l_msg_data;
5198:
5199: --new
5200:

Line 5277: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5273:
5274:
5275: Exception
5276: When Others Then
5277: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5278: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5279: x_msg_data := l_msg_data;
5280:
5281: End Delete_Credit_Card;

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

5274:
5275: Exception
5276: When Others Then
5277: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5278: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5279: x_msg_data := l_msg_data;
5280:
5281: End Delete_Credit_Card;
5282:

Line 5393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

5389:
5390: return(l_entity_id);
5391: Exception
5392: When Others Then
5393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5394: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5395: x_msg_data := l_msg_data;
5396: End Create_Credit_Card;
5397:

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

5390: return(l_entity_id);
5391: Exception
5392: When Others Then
5393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5394: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
5395: x_msg_data := l_msg_data;
5396: End Create_Credit_Card;
5397:
5398: