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

Line 246: OKC_API.SET_MESSAGE (

242: OR l_contract_id = G_MISS_NUM) THEN
243:
244: l_return_status := OKL_API.G_RET_STS_ERROR;
245:
246: OKC_API.SET_MESSAGE (
247: p_app_name => G_OKC_APP_NAME,
248: p_msg_name => 'OKC_NO_PARAMS',
249: p_token1 => 'PARAM',
250: p_token1_value => 'Contract Party Id or Contract Id',

Line 280: OKC_API.SET_MESSAGE (

276: l_bill_to_site_use_id := l_k_party_rg_rec.bill_to_site_use_id ;
277:
278: IF l_k_party_rg_rec.cpl_id IS NULL THEN
279: l_return_status := OKL_API.G_RET_STS_ERROR;
280: OKC_API.SET_MESSAGE (
281: p_app_name => G_OKC_APP_NAME,
282: p_msg_name => G_INVALID_VALUE,
283: p_token1 => G_COL_NAME_TOKEN,
284: p_token1_value => 'Contract Party Id');

Line 292: OKC_API.SET_MESSAGE (

288: l_party_name := okl_am_util_pvt.get_jtf_object_name (
289: l_k_party_rg_rec.object1_code,
290: l_k_party_rg_rec.object1_id1,
291: l_k_party_rg_rec.object1_id2);
292: OKC_API.SET_MESSAGE (
293: p_app_name => G_APP_NAME,
294: p_msg_name => 'OKL_AM_NO_BILLING_INFO',
295: p_token1 => 'PARTY',
296: p_token1_value => l_party_name);

Line 306: OKC_API.SET_MESSAGE (

302: l_k_party_rg_rec.object1_code,
303: l_k_party_rg_rec.object1_id1,
304: l_k_party_rg_rec.object1_id2);
305: -- Billing information is not found for party PARTY having role PARTY_ROLE.
306: OKC_API.SET_MESSAGE (
307: p_app_name => G_APP_NAME,
308: p_msg_name => 'OKL_AM_NO_BILLING_INFO_NEW',
309: p_token1 => 'PARTY',
310: p_token1_value => l_party_name,

Line 325: OKC_API.SET_MESSAGE (

321: CLOSE l_partner_rg_csr;
322:
323: IF l_khr_id IS NULL THEN
324: l_return_status := OKL_API.G_RET_STS_ERROR;
325: OKC_API.SET_MESSAGE (
326: p_app_name => G_OKC_APP_NAME,
327: p_msg_name => G_INVALID_VALUE,
328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'Contract Id');

Line 341: OKC_API.SET_MESSAGE (

337: /* -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
338: ELSIF l_rgd_id IS NULL THEN
339: l_return_status := OKL_API.G_RET_STS_ERROR;
340: l_party_name := okl_am_util_pvt.get_program_partner (l_khr_id);
341: OKC_API.SET_MESSAGE (
342: p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_AM_NO_BILLING_INFO',
344: p_token1 => 'PARTY',
345: p_token1_value => l_party_name);

Line 356: OKC_API.SET_MESSAGE (

352: IF (is_debug_statement_on) THEN
353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_program_partner and got l_party_name : ' || l_party_name);
354: END IF;
355: -- Billing information is not found for party PARTY having role PARTY_ROLE.
356: OKC_API.SET_MESSAGE (
357: p_app_name => G_APP_NAME,
358: p_msg_name => 'OKL_AM_NO_BILLING_INFO_NEW',
359: p_token1 => 'PARTY',
360: p_token1_value => l_party_name,

Line 506: OKC_API.SET_MESSAGE (

502:
503: IF px_taiv_rec.ixx_id IS NULL
504: OR px_taiv_rec.ixx_id = G_MISS_NUM THEN
505: l_return_status := OKL_API.G_RET_STS_ERROR;
506: OKC_API.SET_MESSAGE (
507: p_app_name => G_OKC_APP_NAME,
508: p_msg_name => G_REQUIRED_VALUE,
509: p_token1 => G_COL_NAME_TOKEN,
510: p_token1_value => 'Customer Account Id');

Line 516: OKC_API.SET_MESSAGE (

512:
513: IF px_taiv_rec.ibt_id IS NULL
514: OR px_taiv_rec.ibt_id = G_MISS_NUM THEN
515: l_return_status := OKL_API.G_RET_STS_ERROR;
516: OKC_API.SET_MESSAGE (
517: p_app_name => G_OKC_APP_NAME,
518: p_msg_name => G_REQUIRED_VALUE,
519: p_token1 => G_COL_NAME_TOKEN,
520: p_token1_value => 'Bill To Address Id');

Line 526: OKC_API.SET_MESSAGE (

522:
523: IF px_taiv_rec.irt_id IS NULL
524: OR px_taiv_rec.irt_id = G_MISS_NUM THEN
525: l_return_status := OKL_API.G_RET_STS_ERROR;
526: OKC_API.SET_MESSAGE (
527: p_app_name => G_OKC_APP_NAME,
528: p_msg_name => G_REQUIRED_VALUE,
529: p_token1 => G_COL_NAME_TOKEN,
530: p_token1_value => 'Payment Term Id');

Line 537: -- OKC_API.SET_MESSAGE (

533: -- Rule is optional - bug 2533080
534: -- IF px_taiv_rec.irm_id IS NULL
535: -- OR px_taiv_rec.irm_id = G_MISS_NUM THEN
536: -- l_return_status := OKL_API.G_RET_STS_ERROR;
537: -- OKC_API.SET_MESSAGE (
538: -- p_app_name => G_OKC_APP_NAME,
539: -- p_msg_name => G_REQUIRED_VALUE,
540: -- p_token1 => G_COL_NAME_TOKEN,
541: -- p_token1_value => 'Payment Method Id');

Line 750: OKC_API.SET_MESSAGE (

746:
747: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
748: OR NVL (l_pos_try_id, G_MISS_NUM) = G_MISS_NUM THEN
749: l_return_status := OKL_API.G_RET_STS_ERROR;
750: OKC_API.SET_MESSAGE (
751: P_APP_NAME => G_OKC_APP_NAME,
752: P_MSG_NAME => G_INVALID_VALUE,
753: P_TOKEN1 => G_COL_NAME_TOKEN,
754: P_TOKEN1_VALUE => 'TRANSACTION TYPE');

Line 772: OKC_API.SET_MESSAGE (

768:
769: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
770: OR NVL (l_neg_try_id, G_MISS_NUM) = G_MISS_NUM THEN
771: l_return_status := OKL_API.G_RET_STS_ERROR;
772: OKC_API.SET_MESSAGE (
773: p_app_name => G_OKC_APP_NAME,
774: p_msg_name => G_INVALID_VALUE,
775: p_token1 => G_COL_NAME_TOKEN,
776: p_token1_value => 'Transaction Type');

Line 801: OKC_API.SET_MESSAGE (

797:
798: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
799: OR NVL (l_roll_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
800: l_return_status := OKL_API.G_RET_STS_ERROR;
801: OKC_API.SET_MESSAGE (
802: p_app_name => G_OKC_APP_NAME,
803: p_msg_name => G_INVALID_VALUE,
804: p_token1 => G_COL_NAME_TOKEN,
805: p_token1_value => 'Transaction Type');

Line 823: OKC_API.SET_MESSAGE (

819:
820: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
821: OR NVL (l_roll_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
822: l_return_status := OKL_API.G_RET_STS_ERROR;
823: OKC_API.SET_MESSAGE (
824: p_app_name => G_OKC_APP_NAME,
825: p_msg_name => G_INVALID_VALUE,
826: p_token1 => G_COL_NAME_TOKEN,
827: p_token1_value => 'Transaction Type');

Line 854: OKC_API.SET_MESSAGE (

850: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
851: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
852: OR NVL (l_release_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
853: l_return_status := OKL_API.G_RET_STS_ERROR;
854: OKC_API.SET_MESSAGE (
855: p_app_name => G_OKC_APP_NAME,
856: p_msg_name => G_INVALID_VALUE,
857: p_token1 => G_COL_NAME_TOKEN,
858: p_token1_value => 'Transaction Type');

Line 877: okc_api.set_message (

873: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
874: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
875: OR NVL (l_release_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
876: l_return_status := okl_api.g_ret_sts_error;
877: okc_api.set_message (
878: p_app_name => g_okc_app_name,
879: p_msg_name => g_invalid_value,
880: p_token1 => g_col_name_token,
881: p_token1_value => 'transaction type');

Line 889: OKC_API.SET_MESSAGE (

885:
886: IF NVL (p_pos_amount, 0) IN (G_MISS_NUM, 0)
887: AND NVL (p_neg_amount, 0) IN (G_MISS_NUM, 0)THEN
888: l_return_status := OKL_API.G_RET_STS_ERROR;
889: OKC_API.SET_MESSAGE (
890: p_app_name => G_OKC_APP_NAME,
891: p_msg_name => G_REQUIRED_VALUE,
892: p_token1 => G_COL_NAME_TOKEN,
893: p_token1_value => 'Amount');

Line 898: OKC_API.SET_MESSAGE (

894: END IF;
895:
896: IF NVL (p_taiv_rec.khr_id, G_MISS_NUM) = G_MISS_NUM THEN
897: l_return_status := OKL_API.G_RET_STS_ERROR;
898: OKC_API.SET_MESSAGE (
899: p_app_name => G_OKC_APP_NAME,
900: p_msg_name => G_REQUIRED_VALUE,
901: p_token1 => G_COL_NAME_TOKEN,
902: p_token1_value => 'Contract_Id');

Line 907: OKC_API.SET_MESSAGE (

903: END IF;
904:
905: IF NVL (p_taiv_rec.currency_code, G_MISS_CHAR) = G_MISS_CHAR THEN
906: l_return_status := OKL_API.G_RET_STS_ERROR;
907: OKC_API.SET_MESSAGE (
908: p_app_name => G_OKC_APP_NAME,
909: p_msg_name => G_REQUIRED_VALUE,
910: p_token1 => G_COL_NAME_TOKEN,
911: p_token1_value => 'Currency_Code');

Line 916: OKC_API.SET_MESSAGE (

912: END IF;
913:
914: IF NVL (p_taiv_rec.description, G_MISS_CHAR) = G_MISS_CHAR THEN
915: l_return_status := OKL_API.G_RET_STS_ERROR;
916: OKC_API.SET_MESSAGE (
917: p_app_name => G_OKC_APP_NAME,
918: p_msg_name => G_REQUIRED_VALUE,
919: p_token1 => G_COL_NAME_TOKEN,
920: p_token1_value => 'Description');

Line 947: OKC_API.SET_MESSAGE (

943: --akrangan bug 6494341 fix end
944:
945: IF NVL (p_tilv_tbl(i).amount, G_MISS_NUM) = G_MISS_NUM THEN
946: l_return_status := OKL_API.G_RET_STS_ERROR;
947: OKC_API.SET_MESSAGE (
948: p_app_name => G_OKC_APP_NAME,
949: p_msg_name => G_REQUIRED_VALUE,
950: p_token1 => G_COL_NAME_TOKEN,
951: p_token1_value => 'Amount');

Line 962: OKC_API.SET_MESSAGE (

958: -- End - Bug#5874824 - Asset Remarketing Fix */
959:
960: IF NVL (p_tilv_tbl(i).sty_id, G_MISS_NUM) = G_MISS_NUM THEN
961: l_return_status := OKL_API.G_RET_STS_ERROR;
962: OKC_API.SET_MESSAGE (
963: p_app_name => G_OKC_APP_NAME,
964: p_msg_name => G_REQUIRED_VALUE,
965: p_token1 => G_COL_NAME_TOKEN,
966: p_token1_value => 'Stream_Type_Id');

Line 971: OKC_API.SET_MESSAGE (

967: END IF;
968:
969: IF NVL (p_tilv_tbl(i).description, G_MISS_CHAR) = G_MISS_CHAR THEN
970: l_return_status := OKL_API.G_RET_STS_ERROR;
971: OKC_API.SET_MESSAGE (
972: p_app_name => G_OKC_APP_NAME,
973: p_msg_name => G_REQUIRED_VALUE,
974: p_token1 => G_COL_NAME_TOKEN,
975: p_token1_value => 'Description');

Line 1225: OKC_API.SET_MESSAGE (

1221:
1222: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1223: OR NVL (l_pos_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1224: l_return_status := OKL_API.G_RET_STS_ERROR;
1225: OKC_API.SET_MESSAGE (
1226: p_app_name => G_OKC_APP_NAME,
1227: p_msg_name => G_INVALID_VALUE,
1228: p_token1 => G_COL_NAME_TOKEN,
1229: p_token1_value => 'Transaction Type');

Line 1240: OKC_API.SET_MESSAGE (

1236:
1237: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1238: OR NVL (l_neg_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1239: l_return_status := OKL_API.G_RET_STS_ERROR;
1240: OKC_API.SET_MESSAGE (
1241: p_app_name => G_OKC_APP_NAME,
1242: p_msg_name => G_INVALID_VALUE,
1243: p_token1 => G_COL_NAME_TOKEN,
1244: p_token1_value => 'Transaction Type');

Line 1263: OKC_API.SET_MESSAGE (

1259:
1260: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1261: OR NVL (l_roll_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1262: l_return_status := OKL_API.G_RET_STS_ERROR;
1263: OKC_API.SET_MESSAGE (
1264: p_app_name => G_OKC_APP_NAME,
1265: p_msg_name => G_INVALID_VALUE,
1266: p_token1 => G_COL_NAME_TOKEN,
1267: p_token1_value => 'Transaction Type');

Line 1278: OKC_API.SET_MESSAGE (

1274:
1275: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1276: OR NVL (l_roll_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1277: l_return_status := OKL_API.G_RET_STS_ERROR;
1278: OKC_API.SET_MESSAGE (
1279: p_app_name => G_OKC_APP_NAME,
1280: p_msg_name => G_INVALID_VALUE,
1281: p_token1 => G_COL_NAME_TOKEN,
1282: p_token1_value => 'Transaction Type');

Line 1304: OKC_API.SET_MESSAGE (

1300: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
1301: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1302: OR NVL (l_release_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1303: l_return_status := OKL_API.G_RET_STS_ERROR;
1304: OKC_API.SET_MESSAGE (
1305: p_app_name => G_OKC_APP_NAME,
1306: p_msg_name => G_INVALID_VALUE,
1307: p_token1 => G_COL_NAME_TOKEN,
1308: p_token1_value => 'Transaction Type');

Line 1320: OKC_API.SET_MESSAGE (

1316: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
1317: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1318: OR NVL (l_release_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1319: l_return_status := OKL_API.G_RET_STS_ERROR;
1320: OKC_API.SET_MESSAGE (
1321: p_app_name => G_OKC_APP_NAME,
1322: p_msg_name => G_INVALID_VALUE,
1323: p_token1 => G_COL_NAME_TOKEN,
1324: p_token1_value => 'Transaction Type');

Line 1332: OKC_API.SET_MESSAGE (

1328:
1329: IF NVL (p_pos_amount, 0) IN (G_MISS_NUM, 0)
1330: AND NVL (p_neg_amount, 0) IN (G_MISS_NUM, 0)THEN
1331: l_return_status := OKL_API.G_RET_STS_ERROR;
1332: OKC_API.SET_MESSAGE (
1333: p_app_name => G_OKC_APP_NAME,
1334: p_msg_name => G_REQUIRED_VALUE,
1335: p_token1 => G_COL_NAME_TOKEN,
1336: p_token1_value => 'Amount');

Line 1341: OKC_API.SET_MESSAGE (

1337: END IF;
1338:
1339: IF NVL (p_taiv_rec.khr_id, G_MISS_NUM) = G_MISS_NUM THEN
1340: l_return_status := OKL_API.G_RET_STS_ERROR;
1341: OKC_API.SET_MESSAGE (
1342: p_app_name => G_OKC_APP_NAME,
1343: p_msg_name => G_REQUIRED_VALUE,
1344: p_token1 => G_COL_NAME_TOKEN,
1345: p_token1_value => 'Contract_Id');

Line 1350: OKC_API.SET_MESSAGE (

1346: END IF;
1347:
1348: IF NVL (p_taiv_rec.currency_code, G_MISS_CHAR) = G_MISS_CHAR THEN
1349: l_return_status := OKL_API.G_RET_STS_ERROR;
1350: OKC_API.SET_MESSAGE (
1351: p_app_name => G_OKC_APP_NAME,
1352: p_msg_name => G_REQUIRED_VALUE,
1353: p_token1 => G_COL_NAME_TOKEN,
1354: p_token1_value => 'Currency_Code');

Line 1359: OKC_API.SET_MESSAGE (

1355: END IF;
1356:
1357: IF NVL (p_taiv_rec.description, G_MISS_CHAR) = G_MISS_CHAR THEN
1358: l_return_status := OKL_API.G_RET_STS_ERROR;
1359: OKC_API.SET_MESSAGE (
1360: p_app_name => G_OKC_APP_NAME,
1361: p_msg_name => G_REQUIRED_VALUE,
1362: p_token1 => G_COL_NAME_TOKEN,
1363: p_token1_value => 'Description');

Line 1497: OKC_API.SET_MESSAGE (

1493: -- *******************
1494:
1495: IF NVL (p_tilv_rec.amount, G_MISS_NUM) = G_MISS_NUM THEN
1496: l_return_status := OKL_API.G_RET_STS_ERROR;
1497: OKC_API.SET_MESSAGE (
1498: p_app_name => G_OKC_APP_NAME,
1499: p_msg_name => G_REQUIRED_VALUE,
1500: p_token1 => G_COL_NAME_TOKEN,
1501: p_token1_value => 'Amount');

Line 1506: OKC_API.SET_MESSAGE (

1502: END IF;
1503:
1504: IF NVL (p_tilv_rec.tai_id, G_MISS_NUM) = G_MISS_NUM THEN
1505: l_return_status := OKL_API.G_RET_STS_ERROR;
1506: OKC_API.SET_MESSAGE (
1507: p_app_name => G_OKC_APP_NAME,
1508: p_msg_name => G_REQUIRED_VALUE,
1509: p_token1 => G_COL_NAME_TOKEN,
1510: p_token1_value => 'Invoice_Header_Id');

Line 1515: OKC_API.SET_MESSAGE (

1511: END IF;
1512:
1513: IF NVL (p_tilv_rec.sty_id, G_MISS_NUM) = G_MISS_NUM THEN
1514: l_return_status := OKL_API.G_RET_STS_ERROR;
1515: OKC_API.SET_MESSAGE (
1516: p_app_name => G_OKC_APP_NAME,
1517: p_msg_name => G_REQUIRED_VALUE,
1518: p_token1 => G_COL_NAME_TOKEN,
1519: p_token1_value => 'Stream_Type_Id');

Line 1524: OKC_API.SET_MESSAGE (

1520: END IF;
1521:
1522: IF NVL (p_tilv_rec.description, G_MISS_CHAR) = G_MISS_CHAR THEN
1523: l_return_status := OKL_API.G_RET_STS_ERROR;
1524: OKC_API.SET_MESSAGE (
1525: p_app_name => G_OKC_APP_NAME,
1526: p_msg_name => G_REQUIRED_VALUE,
1527: p_token1 => G_COL_NAME_TOKEN,
1528: p_token1_value => 'Description');

Line 1796: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN

1792: OPEN l_assetreturns_csr(cp_kle_id => l_cle_rec.cle_id);
1793: FETCH l_assetreturns_csr INTO l_legal_entity_id;
1794: CLOSE l_assetreturns_csr;
1795:
1796: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
1797: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1798: p_msg_name => g_required_value,
1799: p_token1 => g_col_name_token,
1800: p_token1_value => 'legal_entity_id');

Line 1801: RAISE OKC_API.G_EXCEPTION_ERROR;

1797: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1798: p_msg_name => g_required_value,
1799: p_token1 => g_col_name_token,
1800: p_token1_value => 'legal_entity_id');
1801: RAISE OKC_API.G_EXCEPTION_ERROR;
1802: END IF;
1803:
1804: -- Legal Entity Changes End
1805:

Line 1867: OKC_API.SET_MESSAGE (

1863:
1864: IF l_stream_status <> OKL_API.G_RET_STS_SUCCESS
1865: OR NVL (l_sty_id, G_MISS_NUM) = G_MISS_NUM THEN
1866: l_return_status := OKL_API.G_RET_STS_ERROR;
1867: OKC_API.SET_MESSAGE (
1868: p_app_name => G_OKC_APP_NAME,
1869: p_msg_name => G_INVALID_VALUE,
1870: p_token1 => G_COL_NAME_TOKEN,
1871: p_token1_value => 'Stream_Type');

Line 2032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2028: -- End of comments
2029:
2030: PROCEDURE Create_Repair_Invoice (
2031: p_api_version IN NUMBER,
2032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2033: x_msg_count OUT NOCOPY NUMBER,
2034: x_msg_data OUT NOCOPY VARCHAR2,
2035: x_return_status OUT NOCOPY VARCHAR2,
2036: p_ariv_tbl IN ariv_tbl_type,

Line 2109: OKC_API.SET_MESSAGE (

2105: -- **********************************************
2106:
2107: IF p_ariv_tbl.COUNT = 0 THEN
2108:
2109: OKC_API.SET_MESSAGE (
2110: p_app_name => G_OKC_APP_NAME,
2111: p_msg_name => 'OKC_NO_PARAMS',
2112: p_token1 => 'PARAM',
2113: p_token1_value => 'ARIV_TBL',

Line 2466: OKC_API.SET_MESSAGE (

2462: FETCH l_art_csr INTO l_art_rec;
2463:
2464: IF l_art_csr%NOTFOUND THEN
2465: l_return_status := OKL_API.G_RET_STS_ERROR;
2466: OKC_API.SET_MESSAGE (
2467: p_app_name => G_OKC_APP_NAME,
2468: p_msg_name => G_INVALID_VALUE,
2469: p_token1 => G_COL_NAME_TOKEN,
2470: p_token1_value => 'Order_Line_Id');

Line 2475: IF (l_art_rec.legal_entity_id is null or l_art_rec.legal_entity_id = OKC_API.G_MISS_NUM) THEN

2471:
2472: ELSE
2473:
2474: -- RRAVIKIR Legal Entity Changes
2475: IF (l_art_rec.legal_entity_id is null or l_art_rec.legal_entity_id = OKC_API.G_MISS_NUM) THEN
2476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2477: p_msg_name => g_required_value,
2478: p_token1 => g_col_name_token,
2479: p_token1_value => 'legal_entity_id');

Line 2480: RAISE OKC_API.G_EXCEPTION_ERROR;

2476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2477: p_msg_name => g_required_value,
2478: p_token1 => g_col_name_token,
2479: p_token1_value => 'legal_entity_id');
2480: RAISE OKC_API.G_EXCEPTION_ERROR;
2481: END IF;
2482: -- Legal Entity Changes End
2483:
2484: l_taiv_rec.khr_id := l_art_rec.chr_id;

Line 2586: OKC_API.SET_MESSAGE (

2582: OR l_tilv_rec.amount = G_MISS_NUM
2583: OR l_tilv_rec.amount = 0 THEN
2584: l_return_status := OKL_API.G_RET_STS_ERROR;
2585: -- Message Text: Invalid value for the column Amount
2586: OKC_API.SET_MESSAGE (
2587: p_app_name => G_OKC_APP_NAME,
2588: p_msg_name => G_INVALID_VALUE,
2589: p_token1 => G_COL_NAME_TOKEN,
2590: p_token1_value => 'Amount');

Line 2660: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2656: -- End of comments
2657:
2658: PROCEDURE Create_Remarket_Invoice (
2659: p_api_version IN NUMBER,
2660: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2661: x_msg_count OUT NOCOPY NUMBER,
2662: x_msg_data OUT NOCOPY VARCHAR2,
2663: x_return_status OUT NOCOPY VARCHAR2,
2664: p_order_line_id IN NUMBER,

Line 2727: OKC_API.SET_MESSAGE (

2723:
2724: IF p_order_line_id IS NULL
2725: OR p_order_line_id = G_MISS_NUM THEN
2726:
2727: OKC_API.SET_MESSAGE (
2728: p_app_name => G_OKC_APP_NAME,
2729: p_msg_name => 'OKC_NO_PARAMS',
2730: p_token1 => 'PARAM',
2731: p_token1_value => 'ORDER_LINE_ID',

Line 3171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3167: -- End of comments
3168:
3169: PROCEDURE Create_Scrt_Dpst_Dsps_Inv (
3170: p_api_version IN NUMBER,
3171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3172: x_msg_count OUT NOCOPY NUMBER,
3173: x_msg_data OUT NOCOPY VARCHAR2,
3174: x_return_status OUT NOCOPY VARCHAR2,
3175: p_contract_id IN NUMBER,

Line 3250: OKC_API.SET_MESSAGE (

3246:
3247: IF p_contract_id IS NULL
3248: OR p_contract_id = G_MISS_NUM THEN
3249:
3250: OKC_API.SET_MESSAGE (
3251: p_app_name => G_OKC_APP_NAME,
3252: p_msg_name => 'OKC_NO_PARAMS',
3253: p_token1 => 'PARAM',
3254: p_token1_value => 'CONTRACT_ID',

Line 3711: OKC_API.SET_MESSAGE (

3707: FETCH l_qte_csr INTO l_qte_rec;
3708:
3709: IF l_qte_csr%NOTFOUND THEN
3710: l_return_status := OKL_API.G_RET_STS_ERROR;
3711: OKC_API.SET_MESSAGE (
3712: p_app_name => G_OKC_APP_NAME,
3713: p_msg_name => G_INVALID_VALUE,
3714: p_token1 => G_COL_NAME_TOKEN,
3715: p_token1_value => 'Quote_Id');

Line 3737: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN

3733: OPEN l_assetreturn_csr(cp_id => l_qte_rec.art_id);
3734: FETCH l_assetreturn_csr INTO l_legal_entity_id;
3735: CLOSE l_assetreturn_csr;
3736:
3737: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3738: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3739: p_msg_name => g_required_value,
3740: p_token1 => g_col_name_token,
3741: p_token1_value => 'legal_entity_id');

Line 3742: RAISE OKC_API.G_EXCEPTION_ERROR;

3738: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3739: p_msg_name => g_required_value,
3740: p_token1 => g_col_name_token,
3741: p_token1_value => 'legal_entity_id');
3742: RAISE OKC_API.G_EXCEPTION_ERROR;
3743: END IF;
3744:
3745: l_taiv_rec.legal_entity_id := l_legal_entity_id;
3746: END IF;

Line 4443: OKC_API.SET_MESSAGE (

4439: -- AND nvl(l_future_invoices_exists,'N') = 'N' THEN -- rmunjulu 4610850 Added condition to Check if future billing adjustments exist
4440: IF NOT l_sdd_invoice THEN --added by veramach for bug#6766479
4441: l_return_status := OKL_API.G_RET_STS_ERROR;
4442: -- Message Text: The invoice has a balance of zero.
4443: OKC_API.SET_MESSAGE (
4444: p_app_name => G_APP_NAME,
4445: p_msg_name => 'OKL_BPD_ZERO_INVOICE');
4446: END IF; --added by veramach for bug#6766479
4447: IF l_sdd_invoice THEN --veramach bug#6766479

Line 4568: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4564: -- End of comments
4565:
4566: PROCEDURE Create_Quote_Invoice (
4567: p_api_version IN NUMBER,
4568: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4569: x_msg_count OUT NOCOPY NUMBER,
4570: x_msg_data OUT NOCOPY VARCHAR2,
4571: x_return_status OUT NOCOPY VARCHAR2,
4572: p_quote_id IN NUMBER,

Line 4760: OKC_API.SET_MESSAGE (

4756:
4757: IF p_quote_id IS NULL
4758: OR p_quote_id = G_MISS_NUM THEN
4759:
4760: OKC_API.SET_MESSAGE (
4761: p_app_name => G_OKC_APP_NAME,
4762: p_msg_name => 'OKC_NO_PARAMS',
4763: p_token1 => 'PARAM',
4764: p_token1_value => 'QUOTE_ID',

Line 5228: OKC_API.SET_MESSAGE (

5224: FETCH l_qte_csr INTO l_qte_rec;
5225:
5226: IF l_qte_csr%NOTFOUND THEN
5227: l_return_status := OKL_API.G_RET_STS_ERROR;
5228: OKC_API.SET_MESSAGE (
5229: p_app_name => G_OKC_APP_NAME,
5230: p_msg_name => G_INVALID_VALUE,
5231: p_token1 => G_COL_NAME_TOKEN,
5232: p_token1_value => 'Quote_Id');