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 FND_MSG_PUB

Line 963: fnd_msg_pub.initialize;

959: l_disp_warning VARCHAR2(1) ;
960:
961: Begin
962:
963: fnd_msg_pub.initialize;
964: IF NOT header_lines_tbl.COUNT=0 THEN
965:
966:
967: i:=header_lines_tbl.FIRST;

Line 1133: FOR i in 1..fnd_msg_pub.count_msg

1129: ,x_flag => l_flag);
1130:
1131: -- Bug 5227077 --
1132: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1133: FOR i in 1..fnd_msg_pub.count_msg
1134: Loop
1135: fnd_msg_pub.get
1136: (
1137: p_msg_index => i,

Line 1135: fnd_msg_pub.get

1131: -- Bug 5227077 --
1132: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1133: FOR i in 1..fnd_msg_pub.count_msg
1134: Loop
1135: fnd_msg_pub.get
1136: (
1137: p_msg_index => i,
1138: p_encoded => 'F',
1139: p_data => l_msg_data,

Line 1150: fnd_msg_pub.initialize;

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:
1152: OKC_API.SET_MESSAGE(
1153: p_app_name => 'OKS', --G_APP_NAME_OKS,
1154: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',

Line 1158: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1154: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
1155: p_token1 => 'Line No ',
1156: p_token1_value => l_line_number);
1157:
1158: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1159: p_encoded => fnd_api.g_false);
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;

Line 1207: fnd_msg_pub.initialize;

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',
1211: p_token1 => 'ATTRIBUTE',

Line 1214: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1210: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1211: p_token1 => 'ATTRIBUTE',
1212: p_token1_value => 'Bill To Address');
1213:
1214: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1215: p_encoded => fnd_api.g_false);
1216:
1217: x_msg_tbl(l_tot_msg_count).status := 'S';
1218: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1226: fnd_msg_pub.initialize;

1222: END IF;
1223: -- IKON ENHANCEMENT
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',

Line 1234: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1230: p_msg_name => 'OKS_CASCADE_ACCOUNT_MISMATCH',
1231: p_token1 => 'Line No ',
1232: p_token1_value => l_line_number);
1233:
1234: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1235: p_encoded => fnd_api.g_false);
1236:
1237: x_msg_tbl(l_tot_msg_count).status := 'E';
1238: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1271: fnd_msg_pub.initialize;

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',
1275: p_token1 => 'ATTRIBUTE',

Line 1278: -- fnd_msg_pub.initialize;

1274: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1275: p_token1 => 'ATTRIBUTE',
1276: p_token1_value => 'Ship To Address');
1277:
1278: -- fnd_msg_pub.initialize;
1279: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1280: p_encoded => fnd_api.g_false);
1281: x_msg_tbl(l_tot_msg_count).status := 'S';
1282: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1279: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1275: p_token1 => 'ATTRIBUTE',
1276: p_token1_value => 'Ship To Address');
1277:
1278: -- fnd_msg_pub.initialize;
1279: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1280: p_encoded => fnd_api.g_false);
1281: x_msg_tbl(l_tot_msg_count).status := 'S';
1282: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1283: l_tot_msg_count := l_tot_msg_count + 1;

Line 1330: fnd_msg_pub.initialize;

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,
1333: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1334: p_token1 => 'ATTRIBUTE',

Line 1337: -- fnd_msg_pub.initialize;

1333: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1334: p_token1 => 'ATTRIBUTE',
1335: p_token1_value => 'Bill To Address');
1336:
1337: -- fnd_msg_pub.initialize;
1338: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1339: p_encoded => fnd_api.g_false);
1340: x_msg_tbl(l_tot_msg_count).status := 'S';
1341: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1338: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1334: p_token1 => 'ATTRIBUTE',
1335: p_token1_value => 'Bill To Address');
1336:
1337: -- fnd_msg_pub.initialize;
1338: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1339: p_encoded => fnd_api.g_false);
1340: x_msg_tbl(l_tot_msg_count).status := 'S';
1341: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1342: l_tot_msg_count := l_tot_msg_count + 1;

Line 1348: fnd_msg_pub.initialize;

1344: END IF;
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',

Line 1355: -- fnd_msg_pub.initialize;

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'));
1354:
1355: -- fnd_msg_pub.initialize;
1356: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1357: p_encoded => fnd_api.g_false);
1358: x_msg_tbl(l_tot_msg_count).status := 'S';
1359: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1356: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1352: p_token1 => 'TOKEN1' , -- bug 5468539 'RULE',
1353: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_BILL_TO_CUSTOMER_ACCOUNT'));
1354:
1355: -- fnd_msg_pub.initialize;
1356: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1357: p_encoded => fnd_api.g_false);
1358: x_msg_tbl(l_tot_msg_count).status := 'S';
1359: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1360: l_tot_msg_count := l_tot_msg_count + 1;

Line 1386: fnd_msg_pub.initialize;

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',
1390: p_token1 =>'TOKEN1' ,

Line 1396: -- fnd_msg_pub.initialize;

1392: p_token2 => 'TOKEN2',
1393: p_token2_value => l_temp_party_name,
1394: p_token3 => 'TOKEN3',
1395: p_token3_value => l_temp_line_number);
1396: -- fnd_msg_pub.initialize;
1397: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1398: p_encoded => fnd_api.g_false);
1399: x_msg_tbl(l_tot_msg_count).status := 'S';
1400: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1397: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1393: p_token2_value => l_temp_party_name,
1394: p_token3 => 'TOKEN3',
1395: p_token3_value => l_temp_line_number);
1396: -- fnd_msg_pub.initialize;
1397: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1398: p_encoded => fnd_api.g_false);
1399: x_msg_tbl(l_tot_msg_count).status := 'S';
1400: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1401: l_tot_msg_count := l_tot_msg_count + 1;

Line 1416: fnd_msg_pub.initialize;

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',
1420: p_token1 =>'TOKEN1' ,

Line 1426: -- fnd_msg_pub.initialize;

1422: p_token2 => 'TOKEN2',
1423: p_token2_value => l_temp_party_name,
1424: p_token3 => 'TOKEN3',
1425: p_token3_value => l_temp_line_number);
1426: -- fnd_msg_pub.initialize;
1427: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1428: p_encoded => fnd_api.g_false);
1429: x_msg_tbl(l_tot_msg_count).status := 'S';
1430: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1427: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1423: p_token2_value => l_temp_party_name,
1424: p_token3 => 'TOKEN3',
1425: p_token3_value => l_temp_line_number);
1426: -- fnd_msg_pub.initialize;
1427: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1428: p_encoded => fnd_api.g_false);
1429: x_msg_tbl(l_tot_msg_count).status := 'S';
1430: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1431: l_tot_msg_count := l_tot_msg_count + 1;

Line 1528: fnd_msg_pub.initialize;

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;
1529: OKC_API.SET_MESSAGE(
1530: p_app_name => G_APP_NAME,
1531: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1532: p_token1 =>'TOKEN1' ,

Line 1538: -- fnd_msg_pub.initialize;

1534: p_token2 => 'TOKEN2',
1535: p_token2_value => l_temp_party_name,
1536: p_token3 => 'TOKEN3',
1537: p_token3_value => l_temp_line_number);
1538: -- fnd_msg_pub.initialize;
1539: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1540: p_encoded => fnd_api.g_false);
1541: x_msg_tbl(l_tot_msg_count).status := 'S';
1542: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1539: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1535: p_token2_value => l_temp_party_name,
1536: p_token3 => 'TOKEN3',
1537: p_token3_value => l_temp_line_number);
1538: -- fnd_msg_pub.initialize;
1539: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1540: p_encoded => fnd_api.g_false);
1541: x_msg_tbl(l_tot_msg_count).status := 'S';
1542: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1543: l_tot_msg_count := l_tot_msg_count + 1;

Line 1551: fnd_msg_pub.initialize;

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;
1552: OKC_API.SET_MESSAGE(
1553: p_app_name => G_APP_NAME,
1554: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1555: p_token1 =>'TOKEN1' ,

Line 1561: -- fnd_msg_pub.initialize;

1557: p_token2 => 'TOKEN2',
1558: p_token2_value => l_temp_party_name,
1559: p_token3 => 'TOKEN3',
1560: p_token3_value => l_temp_line_number);
1561: -- fnd_msg_pub.initialize;
1562: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1563: p_encoded => fnd_api.g_false);
1564: x_msg_tbl(l_tot_msg_count).status := 'S';
1565: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1562: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1558: p_token2_value => l_temp_party_name,
1559: p_token3 => 'TOKEN3',
1560: p_token3_value => l_temp_line_number);
1561: -- fnd_msg_pub.initialize;
1562: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1563: p_encoded => fnd_api.g_false);
1564: x_msg_tbl(l_tot_msg_count).status := 'S';
1565: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1566: l_tot_msg_count := l_tot_msg_count + 1;

Line 1573: FOR i in 1..fnd_msg_pub.count_msg

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: (
1577: p_msg_index => i,

Line 1575: fnd_msg_pub.get

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: (
1577: p_msg_index => i,
1578: p_encoded => 'F',
1579: p_data => l_msg_data,

Line 1631: fnd_msg_pub.initialize;

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(
1633: p_app_name => G_APP_NAME_OKS,
1634: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1635: p_token1 => 'ATTRIBUTE',

Line 1638: -- fnd_msg_pub.initialize;

1634: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1635: p_token1 => 'ATTRIBUTE',
1636: p_token1_value => 'Ship To Address');
1637:
1638: -- fnd_msg_pub.initialize;
1639: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1640: p_encoded => fnd_api.g_false);
1641: x_msg_tbl(l_tot_msg_count).status := 'S';
1642: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1639: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1635: p_token1 => 'ATTRIBUTE',
1636: p_token1_value => 'Ship To Address');
1637:
1638: -- fnd_msg_pub.initialize;
1639: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1640: p_encoded => fnd_api.g_false);
1641: x_msg_tbl(l_tot_msg_count).status := 'S';
1642: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1643: l_tot_msg_count := l_tot_msg_count + 1;

Line 1647: fnd_msg_pub.initialize;

1643: l_tot_msg_count := l_tot_msg_count + 1;
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',

Line 1654: -- fnd_msg_pub.initialize;

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'));
1653:
1654: -- fnd_msg_pub.initialize;
1655: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1656: p_encoded => fnd_api.g_false);
1657: x_msg_tbl(l_tot_msg_count).status := 'S';
1658: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1655: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1651: p_token1 => 'TOKEN1', -- bug 5468539 'RULE',
1652: p_token1_value => FND_MESSAGE.GET_STRING('OKS','OKS_SHIP_TO_CUSTOMER_ACCOUNT'));
1653:
1654: -- fnd_msg_pub.initialize;
1655: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1656: p_encoded => fnd_api.g_false);
1657: x_msg_tbl(l_tot_msg_count).status := 'S';
1658: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1659: l_tot_msg_count := l_tot_msg_count + 1;

Line 1761: fnd_msg_pub.initialize;

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;
1762: OKC_API.SET_MESSAGE(
1763: p_app_name => G_APP_NAME,
1764: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1765: p_token1 =>'TOKEN1' ,

Line 1771: -- fnd_msg_pub.initialize;

1767: p_token2 => 'TOKEN2',
1768: p_token2_value => l_temp_party_name,
1769: p_token3 => 'TOKEN3',
1770: p_token3_value => l_temp_line_number);
1771: -- fnd_msg_pub.initialize;
1772: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1773: p_encoded => fnd_api.g_false);
1774: x_msg_tbl(l_tot_msg_count).status := 'S';
1775: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1772: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1768: p_token2_value => l_temp_party_name,
1769: p_token3 => 'TOKEN3',
1770: p_token3_value => l_temp_line_number);
1771: -- fnd_msg_pub.initialize;
1772: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1773: p_encoded => fnd_api.g_false);
1774: x_msg_tbl(l_tot_msg_count).status := 'S';
1775: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1776: l_tot_msg_count := l_tot_msg_count + 1;

Line 1784: fnd_msg_pub.initialize;

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;
1785: OKC_API.SET_MESSAGE(
1786: p_app_name => G_APP_NAME,
1787: p_msg_name =>'OKS_CASCADE_CHANGE_ACCOUNT',
1788: p_token1 =>'TOKEN1' ,

Line 1794: -- fnd_msg_pub.initialize;

1790: p_token2 => 'TOKEN2',
1791: p_token2_value => l_temp_party_name,
1792: p_token3 => 'TOKEN3',
1793: p_token3_value => l_temp_line_number);
1794: -- fnd_msg_pub.initialize;
1795: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1796: p_encoded => fnd_api.g_false);
1797: x_msg_tbl(l_tot_msg_count).status := 'S';
1798: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 1795: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

1791: p_token2_value => l_temp_party_name,
1792: p_token3 => 'TOKEN3',
1793: p_token3_value => l_temp_line_number);
1794: -- fnd_msg_pub.initialize;
1795: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1796: p_encoded => fnd_api.g_false);
1797: x_msg_tbl(l_tot_msg_count).status := 'S';
1798: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1799: l_tot_msg_count := l_tot_msg_count + 1;

Line 1807: FOR i in 1..fnd_msg_pub.count_msg

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
1810: (
1811: p_msg_index => i,

Line 1809: fnd_msg_pub.get

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
1810: (
1811: p_msg_index => i,
1812: p_encoded => 'F',
1813: p_data => l_msg_data,

Line 1877: FOR i in 1..fnd_msg_pub.count_msg

1873: -- Bug 5219132 --
1874:
1875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS)
1876: THEN
1877: FOR i in 1..fnd_msg_pub.count_msg
1878: Loop
1879: fnd_msg_pub.get
1880: (
1881: p_msg_index => i,

Line 1879: fnd_msg_pub.get

1875: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS)
1876: THEN
1877: FOR i in 1..fnd_msg_pub.count_msg
1878: Loop
1879: fnd_msg_pub.get
1880: (
1881: p_msg_index => i,
1882: p_encoded => 'F',
1883: p_data => l_msg_data,

Line 1922: FOR i in 1..fnd_msg_pub.count_msg

1918:
1919:
1920: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1921: -- Bug 5227077 --
1922: FOR i in 1..fnd_msg_pub.count_msg
1923: Loop
1924: fnd_msg_pub.get
1925: (
1926: p_msg_index => i,

Line 1924: fnd_msg_pub.get

1920: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1921: -- Bug 5227077 --
1922: FOR i in 1..fnd_msg_pub.count_msg
1923: Loop
1924: fnd_msg_pub.get
1925: (
1926: p_msg_index => i,
1927: p_encoded => 'F',
1928: p_data => l_msg_data,

Line 1939: fnd_msg_pub.initialize;

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,
1942: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1943: p_token1 => 'ATTRIBUTE',

Line 1945: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

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');
1945: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1946: p_encoded => fnd_api.g_false);
1947: x_msg_tbl(l_tot_msg_count).status := 'S';
1948: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1949: l_tot_msg_count := l_tot_msg_count + 1;

Line 1967: FOR i in 1..fnd_msg_pub.count_msg

1963: x_ctcv_tbl => l_ctcv_tbl_out);
1964:
1965: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1966: -- Bug 5227077 --
1967: FOR i in 1..fnd_msg_pub.count_msg
1968: Loop
1969: fnd_msg_pub.get
1970: (
1971: p_msg_index => i,

Line 1969: fnd_msg_pub.get

1965: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1966: -- Bug 5227077 --
1967: FOR i in 1..fnd_msg_pub.count_msg
1968: Loop
1969: fnd_msg_pub.get
1970: (
1971: p_msg_index => i,
1972: p_encoded => 'F',
1973: p_data => l_msg_data,

Line 1984: fnd_msg_pub.initialize;

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,
1987: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
1988: p_token1 => 'ATTRIBUTE',

Line 1990: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

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');
1990: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
1991: p_encoded => fnd_api.g_false);
1992: x_msg_tbl(l_tot_msg_count).status := 'S';
1993: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
1994: l_tot_msg_count := l_tot_msg_count + 1;

Line 2004: fnd_msg_pub.initialize;

2000: END IF; --End GC-01
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 ',

Line 2011: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2007: p_msg_name => 'OKS_CASCADE_BTOACCT_MISMATCH',
2008: p_token1 => 'Line No ',
2009: p_token1_value => l_line_number);
2010:
2011: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2012: p_encoded => fnd_api.g_false);
2013:
2014: x_msg_tbl(l_tot_msg_count).status := 'W'; -- Bug 5219132
2015: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2182: fnd_msg_pub.initialize;

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',
2186: p_token1 => 'ATTRIBUTE',

Line 2188: --fnd_msg_pub.initialize;

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');
2188: --fnd_msg_pub.initialize;
2189: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2190: p_encoded => fnd_api.g_false);
2191: x_msg_tbl(l_tot_msg_count).status := 'S';
2192: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2189: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2185: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2186: p_token1 => 'ATTRIBUTE',
2187: p_token1_value => 'Tax');
2188: --fnd_msg_pub.initialize;
2189: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2190: p_encoded => fnd_api.g_false);
2191: x_msg_tbl(l_tot_msg_count).status := 'S';
2192: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2193: l_tot_msg_count := l_tot_msg_count + 1;

Line 2238: fnd_msg_pub.initialize;

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',
2242: p_token1 => 'ATTRIBUTE',

Line 2244: --fnd_msg_pub.initialize;

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');
2244: --fnd_msg_pub.initialize;
2245: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2246: p_encoded => fnd_api.g_false);
2247: x_msg_tbl(l_tot_msg_count).status := 'S';
2248: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2245: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2241: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2242: p_token1 => 'ATTRIBUTE',
2243: p_token1_value => 'Tax Code');
2244: --fnd_msg_pub.initialize;
2245: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2246: p_encoded => fnd_api.g_false);
2247: x_msg_tbl(l_tot_msg_count).status := 'S';
2248: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2249: l_tot_msg_count := l_tot_msg_count + 1;

Line 2278: fnd_msg_pub.initialize;

2274: If l_usage_type in ('VRT','QTY') then
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',

Line 2289: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2285: p_token2 => 'Line No ',
2286: p_token2_value => l_line_number
2287: );
2288:
2289: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2290: p_encoded => fnd_api.g_false);
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;

Line 2334: FOR i in 1..fnd_msg_pub.count_msg

2330: x_msg_data => l_msg_data);
2331:
2332: -- Bug 5227077 --
2333: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2334: FOR i in 1..fnd_msg_pub.count_msg
2335: Loop
2336: fnd_msg_pub.get
2337: (
2338: p_msg_index => i,

Line 2336: fnd_msg_pub.get

2332: -- Bug 5227077 --
2333: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2334: FOR i in 1..fnd_msg_pub.count_msg
2335: Loop
2336: fnd_msg_pub.get
2337: (
2338: p_msg_index => i,
2339: p_encoded => 'F',
2340: p_data => l_msg_data,

Line 2366: FOR i in 1..fnd_msg_pub.count_msg

2362: );
2363:
2364: -- Bug 5227077 --
2365: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2366: FOR i in 1..fnd_msg_pub.count_msg
2367: Loop
2368: fnd_msg_pub.get
2369: (
2370: p_msg_index => i,

Line 2368: fnd_msg_pub.get

2364: -- Bug 5227077 --
2365: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2366: FOR i in 1..fnd_msg_pub.count_msg
2367: Loop
2368: fnd_msg_pub.get
2369: (
2370: p_msg_index => i,
2371: p_encoded => 'F',
2372: p_data => l_msg_data,

Line 2415: FOR i in 1..fnd_msg_pub.count_msg

2411: ,x_return_status => l_return_status
2412: );
2413:
2414: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2415: FOR i in 1..fnd_msg_pub.count_msg
2416: Loop
2417: fnd_msg_pub.get
2418: (
2419: p_msg_index => i,

Line 2417: fnd_msg_pub.get

2413:
2414: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2415: FOR i in 1..fnd_msg_pub.count_msg
2416: Loop
2417: fnd_msg_pub.get
2418: (
2419: p_msg_index => i,
2420: p_encoded => 'F',
2421: p_data => l_msg_data,

Line 2431: fnd_msg_pub.initialize;

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,
2434: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2435: p_token1 => 'ATTRIBUTE',

Line 2437: --fnd_msg_pub.initialize;

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');
2437: --fnd_msg_pub.initialize;
2438: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2439: p_encoded => fnd_api.g_false);
2440: x_msg_tbl(l_tot_msg_count).status := 'S';
2441: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2438: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2434: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2435: p_token1 => 'ATTRIBUTE',
2436: p_token1_value => 'Billing Schedule');
2437: --fnd_msg_pub.initialize;
2438: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2439: p_encoded => fnd_api.g_false);
2440: x_msg_tbl(l_tot_msg_count).status := 'S';
2441: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2442: l_tot_msg_count := l_tot_msg_count + 1;

Line 2469: fnd_msg_pub.initialize;

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',
2473: p_token1 => 'ATTRIBUTE',

Line 2475: --fnd_msg_pub.initialize;

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');
2475: --fnd_msg_pub.initialize;
2476: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2477: p_encoded => fnd_api.g_false);
2478: x_msg_tbl(l_tot_msg_count).status := 'S';
2479: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2476: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2472: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2473: p_token1 => 'ATTRIBUTE',
2474: p_token1_value => 'Bill To Address');
2475: --fnd_msg_pub.initialize;
2476: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2477: p_encoded => fnd_api.g_false);
2478: x_msg_tbl(l_tot_msg_count).status := 'S';
2479: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2480: l_tot_msg_count := l_tot_msg_count + 1;

Line 2488: fnd_msg_pub.initialize;

2484: END IF;
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',

Line 2495: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2491: p_msg_name => 'OKS_CASCADE_MISSING_REQD_ATTR',
2492: p_token1 => 'ATTRIBUTE',
2493: p_token1_value => 'Billing Profile');
2494:
2495: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2496: p_encoded => fnd_api.g_false);
2497: x_msg_tbl(l_tot_msg_count).status := 'E';
2498: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2499: l_tot_msg_count := l_tot_msg_count + 1;

Line 2517: fnd_msg_pub.initialize;

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',
2521: p_token1 => 'ATTRIBUTE',

Line 2524: --fnd_msg_pub.initialize;

2520: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2521: p_token1 => 'ATTRIBUTE',
2522: p_token1_value => 'Accounting Rule');
2523:
2524: --fnd_msg_pub.initialize;
2525: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2526: p_encoded => fnd_api.g_false);
2527: x_msg_tbl(l_tot_msg_count).status := 'S';
2528: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2525: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2521: p_token1 => 'ATTRIBUTE',
2522: p_token1_value => 'Accounting Rule');
2523:
2524: --fnd_msg_pub.initialize;
2525: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2526: p_encoded => fnd_api.g_false);
2527: x_msg_tbl(l_tot_msg_count).status := 'S';
2528: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2529: l_tot_msg_count := l_tot_msg_count + 1;

Line 2547: fnd_msg_pub.initialize;

2543: If l_usage_type in ('VRT','QTY') then
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',

Line 2558: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2554: p_token2 => 'Line No ',
2555: p_token2_value => l_line_number
2556: );
2557:
2558: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2559: p_encoded => fnd_api.g_false);
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;

Line 2574: fnd_msg_pub.initialize;

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',
2578: p_token1 => 'ATTRIBUTE',

Line 2581: --fnd_msg_pub.initialize;

2577: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2578: p_token1 => 'ATTRIBUTE',
2579: p_token1_value => 'Accounting Rule');
2580:
2581: --fnd_msg_pub.initialize;
2582: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2583: p_encoded => fnd_api.g_false);
2584: x_msg_tbl(l_tot_msg_count).status := 'S';
2585: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2582: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2578: p_token1 => 'ATTRIBUTE',
2579: p_token1_value => 'Accounting Rule');
2580:
2581: --fnd_msg_pub.initialize;
2582: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2583: p_encoded => fnd_api.g_false);
2584: x_msg_tbl(l_tot_msg_count).status := 'S';
2585: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2586: l_tot_msg_count := l_tot_msg_count + 1;

Line 2611: fnd_msg_pub.initialize;

2607: If l_usage_type in ('VRT','QTY') then
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',

Line 2622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2618: p_token2 => 'Line No ',
2619: p_token2_value => l_line_number
2620: );
2621:
2622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2623: p_encoded => fnd_api.g_false);
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;

Line 2646: fnd_msg_pub.initialize;

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',
2650: p_token1 => 'ATTRIBUTE',

Line 2653: --fnd_msg_pub.initialize;

2649: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2650: p_token1 => 'ATTRIBUTE',
2651: p_token1_value => 'Invoicing Rule');
2652:
2653: --fnd_msg_pub.initialize;
2654: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2655: p_encoded => fnd_api.g_false);
2656: x_msg_tbl(l_tot_msg_count).status := 'S';
2657: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 2654: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2650: p_token1 => 'ATTRIBUTE',
2651: p_token1_value => 'Invoicing Rule');
2652:
2653: --fnd_msg_pub.initialize;
2654: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2655: p_encoded => fnd_api.g_false);
2656: x_msg_tbl(l_tot_msg_count).status := 'S';
2657: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2658: l_tot_msg_count := l_tot_msg_count + 1;

Line 2662: FOR i in 1..fnd_msg_pub.count_msg

2658: l_tot_msg_count := l_tot_msg_count + 1;
2659: l_msg_data := NULL;
2660: -- Bug 5227077 --
2661: Elsif NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2662: FOR i in 1..fnd_msg_pub.count_msg
2663: Loop
2664: fnd_msg_pub.get
2665: (
2666: p_msg_index => i,

Line 2664: fnd_msg_pub.get

2660: -- Bug 5227077 --
2661: Elsif NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2662: FOR i in 1..fnd_msg_pub.count_msg
2663: Loop
2664: fnd_msg_pub.get
2665: (
2666: p_msg_index => i,
2667: p_encoded => 'F',
2668: p_data => l_msg_data,

Line 2691: fnd_msg_pub.initialize;

2687:
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',

Line 2701: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2697: p_token1_value => l_token1_value,
2698: p_token2 => 'Line No ',
2699: p_token2_value => l_line_number
2700: );
2701: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2702: p_encoded => fnd_api.g_false);
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;

Line 2728: FOR i in 1..fnd_msg_pub.count_msg

2724: x_msg_count => l_msg_count,
2725: x_msg_data => l_msg_data
2726: );
2727: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2728: FOR i in 1..fnd_msg_pub.count_msg
2729: Loop
2730: fnd_msg_pub.get
2731: (
2732: p_msg_index => i,

Line 2730: fnd_msg_pub.get

2726: );
2727: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2728: FOR i in 1..fnd_msg_pub.count_msg
2729: Loop
2730: fnd_msg_pub.get
2731: (
2732: p_msg_index => i,
2733: p_encoded => 'F',
2734: p_data => l_msg_data,

Line 2745: fnd_msg_pub.initialize;

2741: End Loop;
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',

Line 2752: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2748: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2749: p_token1 => 'ATTRIBUTE',
2750: p_token1_value => 'Invoicing Rule');
2751:
2752: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2753: p_encoded => fnd_api.g_false);
2754: x_msg_tbl(l_tot_msg_count).status := 'S';
2755: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2756: l_tot_msg_count := l_tot_msg_count + 1;

Line 2789: FOR i in 1..fnd_msg_pub.count_msg

2785: x_msg_data => l_msg_data,
2786: p_scrv_tbl => l_scrv_tbl_in);
2787: -- Bug 527077 --
2788: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2789: FOR i in 1..fnd_msg_pub.count_msg
2790: Loop
2791: fnd_msg_pub.get
2792: (
2793: p_msg_index => i,

Line 2791: fnd_msg_pub.get

2787: -- Bug 527077 --
2788: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2789: FOR i in 1..fnd_msg_pub.count_msg
2790: Loop
2791: fnd_msg_pub.get
2792: (
2793: p_msg_index => i,
2794: p_encoded => 'F',
2795: p_data => l_msg_data,

Line 2818: fnd_msg_pub.initialize;

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',
2822: p_token1 => 'ATTRIBUTE',

Line 2825: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2821: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
2822: p_token1 => 'ATTRIBUTE',
2823: p_token1_value => 'Sales Credit');
2824:
2825: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2826: p_encoded => fnd_api.g_false);
2827: x_msg_tbl(l_tot_msg_count).status := 'S';
2828: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2829: l_tot_msg_count := l_tot_msg_count + 1;

Line 2833: FOR i in 1..fnd_msg_pub.count_msg

2829: l_tot_msg_count := l_tot_msg_count + 1;
2830: l_msg_data := NULL;
2831: -- Bug 5227077 --
2832: Elsif not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2833: FOR i in 1..fnd_msg_pub.count_msg
2834: Loop
2835: fnd_msg_pub.get
2836: (
2837: p_msg_index => i,

Line 2835: fnd_msg_pub.get

2831: -- Bug 5227077 --
2832: Elsif not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2833: FOR i in 1..fnd_msg_pub.count_msg
2834: Loop
2835: fnd_msg_pub.get
2836: (
2837: p_msg_index => i,
2838: p_encoded => 'F',
2839: p_data => l_msg_data,

Line 2915: FOR i in 1..fnd_msg_pub.count_msg

2911: x_return_status => l_return_status,
2912: x_msg_data => l_msg_data );
2913: -- Bug 5227077 --
2914: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2915: FOR i in 1..fnd_msg_pub.count_msg
2916: Loop
2917: fnd_msg_pub.get
2918: (
2919: p_msg_index => i,

Line 2917: fnd_msg_pub.get

2913: -- Bug 5227077 --
2914: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2915: FOR i in 1..fnd_msg_pub.count_msg
2916: Loop
2917: fnd_msg_pub.get
2918: (
2919: p_msg_index => i,
2920: p_encoded => 'F',
2921: p_data => l_msg_data,

Line 2958: FOR i in 1..fnd_msg_pub.count_msg

2954: x_msg_data => l_msg_data );
2955:
2956: -- Bug 5227077 --
2957: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2958: FOR i in 1..fnd_msg_pub.count_msg
2959: Loop
2960: fnd_msg_pub.get
2961: (
2962: p_msg_index => i,

Line 2960: fnd_msg_pub.get

2956: -- Bug 5227077 --
2957: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2958: FOR i in 1..fnd_msg_pub.count_msg
2959: Loop
2960: fnd_msg_pub.get
2961: (
2962: p_msg_index => i,
2963: p_encoded => 'F',
2964: p_data => l_msg_data,

Line 3014: FOR i in 1..fnd_msg_pub.count_msg

3010: x_msg_data => l_msg_data );
3011:
3012: -- Bug 5227077 --
3013: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3014: FOR i in 1..fnd_msg_pub.count_msg
3015: Loop
3016: fnd_msg_pub.get
3017: (
3018: p_msg_index => i,

Line 3016: fnd_msg_pub.get

3012: -- Bug 5227077 --
3013: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3014: FOR i in 1..fnd_msg_pub.count_msg
3015: Loop
3016: fnd_msg_pub.get
3017: (
3018: p_msg_index => i,
3019: p_encoded => 'F',
3020: p_data => l_msg_data,

Line 3060: FOR i in 1..fnd_msg_pub.count_msg

3056: x_return_status => l_return_status,
3057: x_msg_data => l_msg_data );
3058: -- Bug 5227077 --
3059: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3060: FOR i in 1..fnd_msg_pub.count_msg
3061: Loop
3062: fnd_msg_pub.get
3063: (
3064: p_msg_index => i,

Line 3062: fnd_msg_pub.get

3058: -- Bug 5227077 --
3059: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3060: FOR i in 1..fnd_msg_pub.count_msg
3061: Loop
3062: fnd_msg_pub.get
3063: (
3064: p_msg_index => i,
3065: p_encoded => 'F',
3066: p_data => l_msg_data,

Line 3092: FOR i in 1..fnd_msg_pub.count_msg

3088: x_msg_data => l_msg_data);
3089:
3090: -- Bug 5227077 --
3091: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3092: FOR i in 1..fnd_msg_pub.count_msg
3093: Loop
3094: fnd_msg_pub.get
3095: (
3096: p_msg_index => i,

Line 3094: fnd_msg_pub.get

3090: -- Bug 5227077 --
3091: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3092: FOR i in 1..fnd_msg_pub.count_msg
3093: Loop
3094: fnd_msg_pub.get
3095: (
3096: p_msg_index => i,
3097: p_encoded => 'F',
3098: p_data => l_msg_data,

Line 3152: FOR i in 1..fnd_msg_pub.count_msg

3148: x_msg_data => l_msg_data );
3149:
3150: -- Bug 5227077 --
3151: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3152: FOR i in 1..fnd_msg_pub.count_msg
3153: Loop
3154: fnd_msg_pub.get
3155: (
3156: p_msg_index => i,

Line 3154: fnd_msg_pub.get

3150: -- Bug 5227077 --
3151: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3152: FOR i in 1..fnd_msg_pub.count_msg
3153: Loop
3154: fnd_msg_pub.get
3155: (
3156: p_msg_index => i,
3157: p_encoded => 'F',
3158: p_data => l_msg_data,

Line 3181: fnd_msg_pub.initialize;

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,
3184: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3185: p_token1 => 'ATTRIBUTE',

Line 3188: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3184: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3185: p_token1 => 'ATTRIBUTE',
3186: p_token1_value => 'Payment Method');
3187:
3188: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3189: p_encoded => fnd_api.g_false);
3190: x_msg_tbl(l_tot_msg_count).status := 'S';
3191: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3192: l_tot_msg_count := l_tot_msg_count + 1;

Line 3207: fnd_msg_pub.initialize;

3203:
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',

Line 3214: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,

3210: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3211: p_token1 => 'ATTRIBUTE',
3212: p_token1_value => 'Price UOM');
3213:
3214: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3215: p_encoded => fnd_api.g_false);
3216:
3217: x_msg_tbl(l_tot_msg_count).status := 'S';
3218: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 3237: fnd_msg_pub.initialize;

3233: ,l_pricing_effective_date => l_pricing_effective_date
3234: ,l_validate_result => l_validate_result);
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');

Line 3238: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,p_encoded => fnd_api.g_false);

3234: ,l_validate_result => l_validate_result);
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';

Line 3269: FOR i in 1..fnd_msg_pub.count_msg

3265: l_msg_count,
3266: l_msg_data);
3267: -- Bug 5227077 --
3268: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3269: FOR i in 1..fnd_msg_pub.count_msg
3270: Loop
3271: fnd_msg_pub.get
3272: (
3273: p_msg_index => i,

Line 3271: fnd_msg_pub.get

3267: -- Bug 5227077 --
3268: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3269: FOR i in 1..fnd_msg_pub.count_msg
3270: Loop
3271: fnd_msg_pub.get
3272: (
3273: p_msg_index => i,
3274: p_encoded => 'F',
3275: p_data => l_msg_data,

Line 3294: fnd_msg_pub.initialize;

3290: l_klnv_tbl_in(1).locked_price_list_id := null;
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',

Line 3301: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,

3297: p_msg_name => 'OKS_HEADER_CASCADE_WARNING',
3298: p_token1 => 'ATTRIBUTE',
3299: p_token1_value => 'Price List');
3300:
3301: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3302: p_encoded => fnd_api.g_false);
3303: x_msg_tbl(l_tot_msg_count).status := 'S';
3304: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3305: l_tot_msg_count := l_tot_msg_count + 1;

Line 3310: fnd_msg_pub.initialize;

3306: l_msg_data := NULL;
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',

Line 3317: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,

3313: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3314: p_token1 => 'ATTRIBUTE',
3315: p_token1_value => 'Price List');
3316:
3317: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3318: p_encoded => fnd_api.g_false);
3319: x_msg_tbl(l_tot_msg_count).status := 'S';
3320: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3321: l_tot_msg_count := l_tot_msg_count + 1;

Line 3326: fnd_msg_pub.initialize;

3322: l_msg_data := NULL;
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',

Line 3333: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,

3329: p_msg_name => 'OKS_HEADER_CASCADE_SUCCESS',
3330: p_token1 => 'ATTRIBUTE',
3331: p_token1_value => 'Price List');
3332:
3333: l_msg_data := fnd_msg_pub.get( p_msg_index => fnd_msg_pub.g_first,
3334: p_encoded => fnd_api.g_false);
3335: x_msg_tbl(l_tot_msg_count).status := 'S';
3336: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3337: l_tot_msg_count := l_tot_msg_count + 1;

Line 3383: FOR i in 1..fnd_msg_pub.count_msg

3379: );
3380: --errorout('Return status -'||l_return_status);
3381: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3382:
3383: FOR i in 1..fnd_msg_pub.count_msg
3384: Loop
3385: fnd_msg_pub.get
3386: (
3387: p_msg_index => i,

Line 3385: fnd_msg_pub.get

3381: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3382:
3383: FOR i in 1..fnd_msg_pub.count_msg
3384: Loop
3385: fnd_msg_pub.get
3386: (
3387: p_msg_index => i,
3388: p_encoded => 'F',
3389: p_data => l_msg_data,

Line 3432: FOR i in 1..fnd_msg_pub.count_msg

3428:
3429:
3430: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3431:
3432: FOR i in 1..fnd_msg_pub.count_msg
3433: Loop
3434: fnd_msg_pub.get
3435: (
3436: p_msg_index => i,

Line 3434: fnd_msg_pub.get

3430: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3431:
3432: FOR i in 1..fnd_msg_pub.count_msg
3433: Loop
3434: fnd_msg_pub.get
3435: (
3436: p_msg_index => i,
3437: p_encoded => 'F',
3438: p_data => l_msg_data,

Line 3494: FOR i in 1..fnd_msg_pub.count_msg

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: (
3498: p_msg_index => i,

Line 3496: fnd_msg_pub.get

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: (
3498: p_msg_index => i,
3499: p_encoded => 'F',
3500: p_data => l_msg_data,

Line 3537: FOR i in 1..fnd_msg_pub.count_msg

3533: p_New_End_Date => header_dates_rec.end_date );
3534:
3535: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3536:
3537: FOR i in 1..fnd_msg_pub.count_msg
3538: Loop
3539: fnd_msg_pub.get
3540: (
3541: p_msg_index => i,

Line 3539: fnd_msg_pub.get

3535: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3536:
3537: FOR i in 1..fnd_msg_pub.count_msg
3538: Loop
3539: fnd_msg_pub.get
3540: (
3541: p_msg_index => i,
3542: p_encoded => 'F',
3543: p_data => l_msg_data,

Line 3558: fnd_msg_pub.initialize;

3554: ELSE
3555: -- Bug 5191587 --
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',

Line 3569: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3565: p_token2 => 'Line No ',
3566: p_token2_value => l_line_number
3567: );
3568:
3569: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3570: p_encoded => fnd_api.g_false);
3571: x_msg_tbl(l_tot_msg_count).status := 'W';
3572: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3573: l_tot_msg_count := l_tot_msg_count + 1;

Line 3576: fnd_msg_pub.initialize;

3572: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3573: l_tot_msg_count := l_tot_msg_count + 1;
3574: l_msg_data := NULL;
3575:
3576: fnd_msg_pub.initialize;
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:

Line 3596: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3592: p_token1_value => 'Date');
3593: x_msg_tbl(l_tot_msg_count).status := 'S';
3594: END IF;
3595:
3596: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3597: p_encoded => fnd_api.g_false);
3598: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3599: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3600: l_tot_msg_count := l_tot_msg_count + 1;

Line 3604: fnd_msg_pub.initialize;

3600: l_tot_msg_count := l_tot_msg_count + 1;
3601: l_msg_data := NULL;
3602:
3603: Else
3604: fnd_msg_pub.initialize;
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:

Line 3622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3618: p_token1 => 'ATTRIBUTE',
3619: p_token1_value => 'Date');
3620: x_msg_tbl(l_tot_msg_count).status := 'S';
3621: END IF;
3622: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3623: p_encoded => fnd_api.g_false);
3624: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3625: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3626: l_tot_msg_count := l_tot_msg_count + 1;

Line 3633: fnd_msg_pub.initialize;

3629: End If;
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',

Line 3642: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3638: p_token2 => 'Line No ',
3639: p_token2_value => l_line_number
3640: );
3641:
3642: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3643: p_encoded => fnd_api.g_false);
3644: x_msg_tbl(l_tot_msg_count).status := 'E';
3645: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3646: l_tot_msg_count := l_tot_msg_count + 1;

Line 3667: FOR i in 1..fnd_msg_pub.count_msg

3663: x_msg_data => l_msg_data
3664: );
3665: -- Bug 5227077 --
3666: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3667: FOR i in 1..fnd_msg_pub.count_msg
3668: Loop
3669: fnd_msg_pub.get
3670: (
3671: p_msg_index => i,

Line 3669: fnd_msg_pub.get

3665: -- Bug 5227077 --
3666: if not(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3667: FOR i in 1..fnd_msg_pub.count_msg
3668: Loop
3669: fnd_msg_pub.get
3670: (
3671: p_msg_index => i,
3672: p_encoded => 'F',
3673: p_data => l_msg_data,

Line 3689: fnd_msg_pub.initialize;

3685: End If;
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#',

Line 3699: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3695: p_token2 => 'Line No ',
3696: p_token2_value => l_line_number
3697: );
3698:
3699: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3700: p_encoded => fnd_api.g_false);
3701: x_msg_tbl(l_tot_msg_count).status := 'W';
3702: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3703: l_tot_msg_count := l_tot_msg_count + 1;

Line 3706: fnd_msg_pub.initialize;

3702: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3703: l_tot_msg_count := l_tot_msg_count + 1;
3704: l_msg_data := NULL;
3705:
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(

Line 3725: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3721: p_token1_value => 'Date');
3722: x_msg_tbl(l_tot_msg_count).status := 'S';
3723: END IF;
3724:
3725: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3726: p_encoded => fnd_api.g_false);
3727: -- x_msg_tbl(l_tot_msg_count).status := 'S';
3728: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3729: l_tot_msg_count := l_tot_msg_count + 1;

Line 3733: fnd_msg_pub.initialize;

3729: l_tot_msg_count := l_tot_msg_count + 1;
3730: l_msg_data := NULL;
3731:
3732: Else
3733: fnd_msg_pub.initialize;
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:

Line 3753: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3749: p_token1_value => 'Date');
3750: x_msg_tbl(l_tot_msg_count).status := 'S';
3751:
3752: END IF;
3753: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3754: p_encoded => fnd_api.g_false);
3755: --x_msg_tbl(l_tot_msg_count).status := 'S';
3756: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3757: l_tot_msg_count := l_tot_msg_count + 1;

Line 3763: fnd_msg_pub.initialize;

3759:
3760: End If;
3761: -- Bug 5191587 --
3762: Else --lse_id = 46
3763: fnd_msg_pub.initialize;
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:

Line 3782: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3778: p_token1 => 'ATTRIBUTE',
3779: p_token1_value => 'Date');
3780: x_msg_tbl(l_tot_msg_count).status := 'S';
3781: END IF;
3782: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3783: p_encoded => fnd_api.g_false);
3784: --x_msg_tbl(l_tot_msg_count).status := 'S';
3785: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3786: l_tot_msg_count := l_tot_msg_count + 1;

Line 3819: FOR i in 1..fnd_msg_pub.count_msg

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: (
3823: p_msg_index => i,

Line 3821: fnd_msg_pub.get

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: (
3823: p_msg_index => i,
3824: p_encoded => 'F',
3825: p_data => l_msg_data,

Line 3888: FOR i in 1..fnd_msg_pub.count_msg

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: (
3892: p_msg_index => i,

Line 3890: fnd_msg_pub.get

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: (
3892: p_msg_index => i,
3893: p_encoded => 'F',
3894: p_data => l_msg_data,

Line 3907: fnd_msg_pub.initialize;

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',
3911: p_token1 => 'ATTRIBUTE',

Line 3914: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

3910: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
3911: p_token1 => 'ATTRIBUTE',
3912: p_token1_value => 'Recalculate Tax');
3913:
3914: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
3915: p_encoded => fnd_api.g_false);
3916: x_msg_tbl(l_tot_msg_count).status := 'S';
3917: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
3918: l_tot_msg_count := l_tot_msg_count + 1;

Line 3955: FOR i in 1..fnd_msg_pub.count_msg

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: (
3959: p_msg_index => i,

Line 3957: fnd_msg_pub.get

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: (
3959: p_msg_index => i,
3960: p_encoded => 'F',
3961: p_data => l_msg_data,

Line 3986: FOR i in 1..fnd_msg_pub.count_msg

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: (
3990: p_msg_index => i,

Line 3988: fnd_msg_pub.get

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: (
3990: p_msg_index => i,
3991: p_encoded => 'F',
3992: p_data => l_msg_data,

Line 4040: FOR i in 1..fnd_msg_pub.count_msg

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: (
4044: p_msg_index => i,

Line 4042: fnd_msg_pub.get

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: (
4044: p_msg_index => i,
4045: p_encoded => 'F',
4046: p_data => l_msg_data,

Line 4058: fnd_msg_pub.initialize;

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',
4062: p_token1 => 'ATTRIBUTE',

Line 4065: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4061: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4062: p_token1 => 'ATTRIBUTE',
4063: p_token1_value => 'Recalculate Tax');
4064:
4065: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4066: p_encoded => fnd_api.g_false);
4067: x_msg_tbl(l_tot_msg_count).status := 'S';
4068: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4069: l_tot_msg_count := l_tot_msg_count + 1;

Line 4097: FOR i in 1..fnd_msg_pub.count_msg

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: (
4101: p_msg_index => i,

Line 4099: fnd_msg_pub.get

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: (
4101: p_msg_index => i,
4102: p_encoded => 'F',
4103: p_data => l_msg_data,

Line 4117: fnd_msg_pub.initialize;

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',
4121: p_token1 => 'ATTRIBUTE',

Line 4124: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4120: p_msg_name => 'OKS_RECALCULATE_TAX_SUCCESS',
4121: p_token1 => 'ATTRIBUTE',
4122: p_token1_value => 'Recalculate Tax');
4123:
4124: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4125: p_encoded => fnd_api.g_false);
4126: x_msg_tbl(l_tot_msg_count).status := 'S';
4127: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4128: l_tot_msg_count := l_tot_msg_count + 1;

Line 4145: FOR i in 1..fnd_msg_pub.count_msg

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
4148: (
4149: p_msg_index => i,

Line 4147: fnd_msg_pub.get

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
4148: (
4149: p_msg_index => i,
4150: p_encoded => 'F',
4151: p_data => l_msg_data,

Line 4170: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4166: exit when i=header_lines_tbl.last;
4167: i:=header_lines_tbl.next(i);
4168: END LOOP;
4169:
4170: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4171: p_encoded => fnd_api.g_false);
4172:
4173: /*
4174: If l_okc_lines_rec.lse_id <> '14' then

Line 4186: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,

4182: END IF;
4183: x_msg_tbl(l_tot_msg_count).status := l_return_status;
4184: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4185:
4186: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,
4187: p_encoded => fnd_api.g_false
4188: );
4189: END LOOP;
4190: End If;

Line 4364: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4360: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4361: p_token1 => 'ATTRIBUTE',
4362: p_token1_value => 'Invoicing Text');
4363:
4364: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4365: p_encoded => fnd_api.g_false);
4366: x_msg_tbl(l_tot_msg_count).status := 'S';
4367: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4368: l_tot_msg_count := l_tot_msg_count + 1;

Line 4370: fnd_msg_pub.initialize;

4366: x_msg_tbl(l_tot_msg_count).status := 'S';
4367: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4368: l_tot_msg_count := l_tot_msg_count + 1;
4369: l_msg_data := NULL;
4370: fnd_msg_pub.initialize;
4371:
4372: END IF;
4373:
4374: END IF;

Line 4389: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4385: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4386: p_token1 => 'ATTRIBUTE',
4387: p_token1_value => 'Renewal');
4388:
4389: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4390: p_encoded => fnd_api.g_false);
4391: x_msg_tbl(l_tot_msg_count).status := 'S';
4392: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4393: l_tot_msg_count := l_tot_msg_count + 1;

Line 4395: fnd_msg_pub.initialize;

4391: x_msg_tbl(l_tot_msg_count).status := 'S';
4392: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4393: l_tot_msg_count := l_tot_msg_count + 1;
4394: l_msg_data := NULL;
4395: fnd_msg_pub.initialize;
4396:
4397:
4398:
4399: END IF;

Line 4413: fnd_msg_pub.initialize;

4409: p_chr_id => null,
4410: p_cle_id => l_cle_id,
4411: p_lse_id => line_dates_rec.lse_id,
4412: p_end_date => null) Then
4413: fnd_msg_pub.initialize;
4414: validate_date
4415:
4416: (p_api_version => l_api_version
4417: ,p_init_msg_list => l_init_msg_list

Line 4428: FOR i in 1..fnd_msg_pub.count_msg

4424: ,x_flag => l_flag);
4425:
4426:
4427: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4428: FOR i in 1..fnd_msg_pub.count_msg
4429: Loop
4430: fnd_msg_pub.get
4431: (
4432: p_msg_index => i,

Line 4430: fnd_msg_pub.get

4426:
4427: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4428: FOR i in 1..fnd_msg_pub.count_msg
4429: Loop
4430: fnd_msg_pub.get
4431: (
4432: p_msg_index => i,
4433: p_encoded => 'F',
4434: p_data => l_msg_data,

Line 4445: fnd_msg_pub.initialize;

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(
4447: p_app_name => 'OKS', --G_APP_NAME_OKS,
4448: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
4449: p_token1 => 'Sub Line No ',

Line 4453: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4449: p_token1 => 'Sub Line No ',
4450: p_token1_value => l_sub_line_seq_number);
4451:
4452:
4453: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4454: p_encoded => fnd_api.g_false);
4455: x_msg_tbl(l_tot_msg_count).status := 'E';
4456: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4457: l_tot_msg_count := l_tot_msg_count + 1;

Line 4459: fnd_msg_pub.initialize;

4455: x_msg_tbl(l_tot_msg_count).status := 'E';
4456: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4457: l_tot_msg_count := l_tot_msg_count + 1;
4458: l_msg_data := NULL;
4459: fnd_msg_pub.initialize;
4460: Raise G_EXCEPTION_HALT_VALIDATION;
4461:
4462: End If;
4463: End If;

Line 4508: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4504:
4505: END IF;
4506: END IF;
4507: ----new
4508: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4509: p_encoded => fnd_api.g_false);
4510: -- x_msg_tbl(l_tot_msg_count).status := 'S';
4511: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4512: l_tot_msg_count := l_tot_msg_count + 1;

Line 4514: fnd_msg_pub.initialize;

4510: -- x_msg_tbl(l_tot_msg_count).status := 'S';
4511: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4512: l_tot_msg_count := l_tot_msg_count + 1;
4513: l_msg_data := NULL;
4514: fnd_msg_pub.initialize;
4515: ----new
4516:
4517: END IF;
4518: -------------------------------------------------------------------

Line 4534: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4530: p_token1_value => 'Invoicing Print Flag');
4531: END IF;
4532:
4533: ----new
4534: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4535: p_encoded => fnd_api.g_false);
4536: x_msg_tbl(l_tot_msg_count).status := 'S';
4537: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4538: l_tot_msg_count := l_tot_msg_count + 1;

Line 4540: fnd_msg_pub.initialize;

4536: x_msg_tbl(l_tot_msg_count).status := 'S';
4537: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4538: l_tot_msg_count := l_tot_msg_count + 1;
4539: l_msg_data := NULL;
4540: fnd_msg_pub.initialize;
4541: ----new
4542:
4543:
4544:

Line 4572: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4568: p_msg_name => 'OKS_LINE_CASCADE_SUCCESS',
4569: p_token1 => 'ATTRIBUTE',
4570: p_token1_value => 'Price UOM');
4571:
4572: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4573: p_encoded => fnd_api.g_false);
4574: x_msg_tbl(l_tot_msg_count).status := 'S';
4575: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4576: l_tot_msg_count := l_tot_msg_count + 1;

Line 4578: fnd_msg_pub.initialize;

4574: x_msg_tbl(l_tot_msg_count).status := 'S';
4575: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4576: l_tot_msg_count := l_tot_msg_count + 1;
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,

Line 4587: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

4583: p_msg_name => 'OKS_LINE_CASCADE_ERROR',
4584: p_token1 => 'ATTRIBUTE',
4585: p_token1_value => 'Price UOM');
4586:
4587: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
4588: p_encoded => fnd_api.g_false);
4589: ----errorout_gsi('Subline_common_attribute UOM msg '||l_msg_data);
4590: x_msg_tbl(l_tot_msg_count).status := 'E';
4591: x_msg_tbl(l_tot_msg_count).description := l_msg_data;

Line 4594: fnd_msg_pub.initialize; */

4590: x_msg_tbl(l_tot_msg_count).status := 'E';
4591: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
4592: l_tot_msg_count := l_tot_msg_count + 1;
4593: l_msg_data := NULL;
4594: fnd_msg_pub.initialize; */
4595: null;
4596: End If;
4597: END IF;
4598: --new

Line 4613: fnd_msg_pub.initialize;

4609:
4610: END sublines_common_attributes;
4611:
4612: Begin
4613: fnd_msg_pub.initialize;
4614:
4615: IF NOT lines_sublines_tbl.COUNT=0 THEN
4616: i:=lines_sublines_tbl.FIRST;
4617: -- GCHADHA --

Line 4693: FOR i in 1..fnd_msg_pub.count_msg

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: (
4697: p_msg_index => i,

Line 4695: fnd_msg_pub.get

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: (
4697: p_msg_index => i,
4698: p_encoded => 'F',
4699: p_data => l_msg_data,

Line 4779: FOR i in 1..fnd_msg_pub.count_msg

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
4782: (
4783: p_msg_index => i,

Line 4781: fnd_msg_pub.get

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
4782: (
4783: p_msg_index => i,
4784: p_encoded => 'F',
4785: p_data => l_msg_data,

Line 4813: FOR i in 1..fnd_msg_pub.count_msg

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: (
4817: p_msg_index => i,

Line 4815: fnd_msg_pub.get

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: (
4817: p_msg_index => i,
4818: p_encoded => 'F',
4819: p_data => l_msg_data,

Line 4872: FOR i in 1..fnd_msg_pub.count_msg

4868: ,p_price_uom => l_line_price_uom -- 8/23/05 hkamdar R12 Partial Period
4869: ,x_return_status => l_return_status
4870: );
4871: --- errorout_vg('After sublines_common_attributes second status '||l_return_status);
4872: FOR i in 1..fnd_msg_pub.count_msg
4873: Loop
4874: fnd_msg_pub.get
4875: (
4876: p_msg_index => i,

Line 4874: fnd_msg_pub.get

4870: );
4871: --- errorout_vg('After sublines_common_attributes second status '||l_return_status);
4872: FOR i in 1..fnd_msg_pub.count_msg
4873: Loop
4874: fnd_msg_pub.get
4875: (
4876: p_msg_index => i,
4877: p_encoded => 'F',
4878: p_data => l_msg_data,

Line 4903: FOR i in 1..fnd_msg_pub.count_msg

4899: ,p_price_uom => l_line_price_uom -- 8/23/05 hkamdar R12 Partial Period
4900: ,x_return_status => l_return_status
4901: );
4902: -- errorout_vg('After sublines_common_attributes Third status '||l_return_status);
4903: FOR i in 1..fnd_msg_pub.count_msg
4904: Loop
4905: fnd_msg_pub.get
4906: (
4907: p_msg_index => i,

Line 4905: fnd_msg_pub.get

4901: );
4902: -- errorout_vg('After sublines_common_attributes Third status '||l_return_status);
4903: FOR i in 1..fnd_msg_pub.count_msg
4904: Loop
4905: fnd_msg_pub.get
4906: (
4907: p_msg_index => i,
4908: p_encoded => 'F',
4909: p_data => l_msg_data,

Line 4944: FOR i in 1..fnd_msg_pub.count_msg

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: (
4948: p_msg_index => i,

Line 4946: fnd_msg_pub.get

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: (
4948: p_msg_index => i,
4949: p_encoded => 'F',
4950: p_data => l_msg_data,

Line 4979: FOR i in 1..fnd_msg_pub.count_msg

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: (
4983: p_msg_index => i,

Line 4981: fnd_msg_pub.get

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: (
4983: p_msg_index => i,
4984: p_encoded => 'F',
4985: p_data => l_msg_data,

Line 5040: FOR i in 1..fnd_msg_pub.count_msg

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: (
5044: p_msg_index => i,

Line 5042: fnd_msg_pub.get

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: (
5044: p_msg_index => i,
5045: p_encoded => 'F',
5046: p_data => l_msg_data,

Line 5110: FOR i in 1..fnd_msg_pub.count_msg

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: (
5114: p_msg_index => i,

Line 5112: fnd_msg_pub.get

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: (
5114: p_msg_index => i,
5115: p_encoded => 'F',
5116: p_data => l_msg_data,

Line 5146: FOR i in 1..fnd_msg_pub.count_msg

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: (
5150: p_msg_index => i,

Line 5148: fnd_msg_pub.get

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: (
5150: p_msg_index => i,
5151: p_encoded => 'F',
5152: p_data => l_msg_data,

Line 5169: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

5165: END IF;
5166:
5167: -- END GCHADHA --
5168:
5169: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
5170: p_encoded => fnd_api.g_false);
5171: WHILE l_msg_data IS NOT NULL
5172: LOOP
5173: IF x_msg_tbl.count=0 THEN

Line 5184: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,

5180:
5181: x_msg_tbl(l_tot_msg_count).status := l_return_status;
5182: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
5183:
5184: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_next,
5185: p_encoded => fnd_api.g_false);
5186: END LOOP;
5187:
5188: END IF;