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 723: OKC_API.SET_MESSAGE (

719:
720: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
721: OR NVL (l_pos_try_id, G_MISS_NUM) = G_MISS_NUM THEN
722: l_return_status := OKL_API.G_RET_STS_ERROR;
723: OKC_API.SET_MESSAGE (
724: P_APP_NAME => G_OKC_APP_NAME,
725: P_MSG_NAME => G_INVALID_VALUE,
726: P_TOKEN1 => G_COL_NAME_TOKEN,
727: P_TOKEN1_VALUE => 'TRANSACTION TYPE');

Line 745: OKC_API.SET_MESSAGE (

741:
742: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
743: OR NVL (l_neg_try_id, G_MISS_NUM) = G_MISS_NUM THEN
744: l_return_status := OKL_API.G_RET_STS_ERROR;
745: OKC_API.SET_MESSAGE (
746: p_app_name => G_OKC_APP_NAME,
747: p_msg_name => G_INVALID_VALUE,
748: p_token1 => G_COL_NAME_TOKEN,
749: p_token1_value => 'Transaction Type');

Line 774: OKC_API.SET_MESSAGE (

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

Line 796: OKC_API.SET_MESSAGE (

792:
793: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
794: OR NVL (l_roll_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
795: l_return_status := OKL_API.G_RET_STS_ERROR;
796: OKC_API.SET_MESSAGE (
797: p_app_name => G_OKC_APP_NAME,
798: p_msg_name => G_INVALID_VALUE,
799: p_token1 => G_COL_NAME_TOKEN,
800: p_token1_value => 'Transaction Type');

Line 827: OKC_API.SET_MESSAGE (

823: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
824: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
825: OR NVL (l_release_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
826: l_return_status := OKL_API.G_RET_STS_ERROR;
827: OKC_API.SET_MESSAGE (
828: p_app_name => G_OKC_APP_NAME,
829: p_msg_name => G_INVALID_VALUE,
830: p_token1 => G_COL_NAME_TOKEN,
831: p_token1_value => 'Transaction Type');

Line 850: okc_api.set_message (

846: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
847: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
848: OR NVL (l_release_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
849: l_return_status := okl_api.g_ret_sts_error;
850: okc_api.set_message (
851: p_app_name => g_okc_app_name,
852: p_msg_name => g_invalid_value,
853: p_token1 => g_col_name_token,
854: p_token1_value => 'transaction type');

Line 862: OKC_API.SET_MESSAGE (

858:
859: IF NVL (p_pos_amount, 0) IN (G_MISS_NUM, 0)
860: AND NVL (p_neg_amount, 0) IN (G_MISS_NUM, 0)THEN
861: l_return_status := OKL_API.G_RET_STS_ERROR;
862: OKC_API.SET_MESSAGE (
863: p_app_name => G_OKC_APP_NAME,
864: p_msg_name => G_REQUIRED_VALUE,
865: p_token1 => G_COL_NAME_TOKEN,
866: p_token1_value => 'Amount');

Line 871: OKC_API.SET_MESSAGE (

867: END IF;
868:
869: IF NVL (p_taiv_rec.khr_id, G_MISS_NUM) = G_MISS_NUM THEN
870: l_return_status := OKL_API.G_RET_STS_ERROR;
871: OKC_API.SET_MESSAGE (
872: p_app_name => G_OKC_APP_NAME,
873: p_msg_name => G_REQUIRED_VALUE,
874: p_token1 => G_COL_NAME_TOKEN,
875: p_token1_value => 'Contract_Id');

Line 880: OKC_API.SET_MESSAGE (

876: END IF;
877:
878: IF NVL (p_taiv_rec.currency_code, G_MISS_CHAR) = G_MISS_CHAR THEN
879: l_return_status := OKL_API.G_RET_STS_ERROR;
880: OKC_API.SET_MESSAGE (
881: p_app_name => G_OKC_APP_NAME,
882: p_msg_name => G_REQUIRED_VALUE,
883: p_token1 => G_COL_NAME_TOKEN,
884: p_token1_value => 'Currency_Code');

Line 889: OKC_API.SET_MESSAGE (

885: END IF;
886:
887: IF NVL (p_taiv_rec.description, G_MISS_CHAR) = G_MISS_CHAR 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 => 'Description');

Line 920: OKC_API.SET_MESSAGE (

916: --akrangan bug 6494341 fix end
917:
918: IF NVL (p_tilv_tbl(i).amount, G_MISS_NUM) = G_MISS_NUM THEN
919: l_return_status := OKL_API.G_RET_STS_ERROR;
920: OKC_API.SET_MESSAGE (
921: p_app_name => G_OKC_APP_NAME,
922: p_msg_name => G_REQUIRED_VALUE,
923: p_token1 => G_COL_NAME_TOKEN,
924: p_token1_value => 'Amount');

Line 935: OKC_API.SET_MESSAGE (

931: -- End - Bug#5874824 - Asset Remarketing Fix */
932:
933: IF NVL (p_tilv_tbl(i).sty_id, G_MISS_NUM) = G_MISS_NUM THEN
934: l_return_status := OKL_API.G_RET_STS_ERROR;
935: OKC_API.SET_MESSAGE (
936: p_app_name => G_OKC_APP_NAME,
937: p_msg_name => G_REQUIRED_VALUE,
938: p_token1 => G_COL_NAME_TOKEN,
939: p_token1_value => 'Stream_Type_Id');

Line 944: OKC_API.SET_MESSAGE (

940: END IF;
941:
942: IF NVL (p_tilv_tbl(i).description, G_MISS_CHAR) = G_MISS_CHAR THEN
943: l_return_status := OKL_API.G_RET_STS_ERROR;
944: OKC_API.SET_MESSAGE (
945: p_app_name => G_OKC_APP_NAME,
946: p_msg_name => G_REQUIRED_VALUE,
947: p_token1 => G_COL_NAME_TOKEN,
948: p_token1_value => 'Description');

Line 1123: OKC_API.SET_MESSAGE (

1119:
1120: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1121: OR NVL (l_pos_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1122: l_return_status := OKL_API.G_RET_STS_ERROR;
1123: OKC_API.SET_MESSAGE (
1124: p_app_name => G_OKC_APP_NAME,
1125: p_msg_name => G_INVALID_VALUE,
1126: p_token1 => G_COL_NAME_TOKEN,
1127: p_token1_value => 'Transaction Type');

Line 1138: OKC_API.SET_MESSAGE (

1134:
1135: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1136: OR NVL (l_neg_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1137: l_return_status := OKL_API.G_RET_STS_ERROR;
1138: OKC_API.SET_MESSAGE (
1139: p_app_name => G_OKC_APP_NAME,
1140: p_msg_name => G_INVALID_VALUE,
1141: p_token1 => G_COL_NAME_TOKEN,
1142: p_token1_value => 'Transaction Type');

Line 1161: OKC_API.SET_MESSAGE (

1157:
1158: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1159: OR NVL (l_roll_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1160: l_return_status := OKL_API.G_RET_STS_ERROR;
1161: OKC_API.SET_MESSAGE (
1162: p_app_name => G_OKC_APP_NAME,
1163: p_msg_name => G_INVALID_VALUE,
1164: p_token1 => G_COL_NAME_TOKEN,
1165: p_token1_value => 'Transaction Type');

Line 1176: OKC_API.SET_MESSAGE (

1172:
1173: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1174: OR NVL (l_roll_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1175: l_return_status := OKL_API.G_RET_STS_ERROR;
1176: OKC_API.SET_MESSAGE (
1177: p_app_name => G_OKC_APP_NAME,
1178: p_msg_name => G_INVALID_VALUE,
1179: p_token1 => G_COL_NAME_TOKEN,
1180: p_token1_value => 'Transaction Type');

Line 1202: OKC_API.SET_MESSAGE (

1198: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
1199: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1200: OR NVL (l_release_bill_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1201: l_return_status := OKL_API.G_RET_STS_ERROR;
1202: OKC_API.SET_MESSAGE (
1203: p_app_name => G_OKC_APP_NAME,
1204: p_msg_name => G_INVALID_VALUE,
1205: p_token1 => G_COL_NAME_TOKEN,
1206: p_token1_value => 'Transaction Type');

Line 1218: OKC_API.SET_MESSAGE (

1214: -- 02-Dec-2004 PAGARG Bug# 4043464, check correct variable for G_MISS value
1215: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS
1216: OR NVL (l_release_cm_try_id, G_MISS_NUM) = G_MISS_NUM THEN
1217: l_return_status := OKL_API.G_RET_STS_ERROR;
1218: OKC_API.SET_MESSAGE (
1219: p_app_name => G_OKC_APP_NAME,
1220: p_msg_name => G_INVALID_VALUE,
1221: p_token1 => G_COL_NAME_TOKEN,
1222: p_token1_value => 'Transaction Type');

Line 1230: OKC_API.SET_MESSAGE (

1226:
1227: IF NVL (p_pos_amount, 0) IN (G_MISS_NUM, 0)
1228: AND NVL (p_neg_amount, 0) IN (G_MISS_NUM, 0)THEN
1229: l_return_status := OKL_API.G_RET_STS_ERROR;
1230: OKC_API.SET_MESSAGE (
1231: p_app_name => G_OKC_APP_NAME,
1232: p_msg_name => G_REQUIRED_VALUE,
1233: p_token1 => G_COL_NAME_TOKEN,
1234: p_token1_value => 'Amount');

Line 1239: OKC_API.SET_MESSAGE (

1235: END IF;
1236:
1237: IF NVL (p_taiv_rec.khr_id, G_MISS_NUM) = G_MISS_NUM THEN
1238: l_return_status := OKL_API.G_RET_STS_ERROR;
1239: OKC_API.SET_MESSAGE (
1240: p_app_name => G_OKC_APP_NAME,
1241: p_msg_name => G_REQUIRED_VALUE,
1242: p_token1 => G_COL_NAME_TOKEN,
1243: p_token1_value => 'Contract_Id');

Line 1248: OKC_API.SET_MESSAGE (

1244: END IF;
1245:
1246: IF NVL (p_taiv_rec.currency_code, G_MISS_CHAR) = G_MISS_CHAR THEN
1247: l_return_status := OKL_API.G_RET_STS_ERROR;
1248: OKC_API.SET_MESSAGE (
1249: p_app_name => G_OKC_APP_NAME,
1250: p_msg_name => G_REQUIRED_VALUE,
1251: p_token1 => G_COL_NAME_TOKEN,
1252: p_token1_value => 'Currency_Code');

Line 1257: OKC_API.SET_MESSAGE (

1253: END IF;
1254:
1255: IF NVL (p_taiv_rec.description, G_MISS_CHAR) = G_MISS_CHAR THEN
1256: l_return_status := OKL_API.G_RET_STS_ERROR;
1257: OKC_API.SET_MESSAGE (
1258: p_app_name => G_OKC_APP_NAME,
1259: p_msg_name => G_REQUIRED_VALUE,
1260: p_token1 => G_COL_NAME_TOKEN,
1261: p_token1_value => 'Description');

Line 1395: OKC_API.SET_MESSAGE (

1391: -- *******************
1392:
1393: IF NVL (p_tilv_rec.amount, G_MISS_NUM) = G_MISS_NUM THEN
1394: l_return_status := OKL_API.G_RET_STS_ERROR;
1395: OKC_API.SET_MESSAGE (
1396: p_app_name => G_OKC_APP_NAME,
1397: p_msg_name => G_REQUIRED_VALUE,
1398: p_token1 => G_COL_NAME_TOKEN,
1399: p_token1_value => 'Amount');

Line 1404: OKC_API.SET_MESSAGE (

1400: END IF;
1401:
1402: IF NVL (p_tilv_rec.tai_id, G_MISS_NUM) = G_MISS_NUM THEN
1403: l_return_status := OKL_API.G_RET_STS_ERROR;
1404: OKC_API.SET_MESSAGE (
1405: p_app_name => G_OKC_APP_NAME,
1406: p_msg_name => G_REQUIRED_VALUE,
1407: p_token1 => G_COL_NAME_TOKEN,
1408: p_token1_value => 'Invoice_Header_Id');

Line 1413: OKC_API.SET_MESSAGE (

1409: END IF;
1410:
1411: IF NVL (p_tilv_rec.sty_id, G_MISS_NUM) = G_MISS_NUM THEN
1412: l_return_status := OKL_API.G_RET_STS_ERROR;
1413: OKC_API.SET_MESSAGE (
1414: p_app_name => G_OKC_APP_NAME,
1415: p_msg_name => G_REQUIRED_VALUE,
1416: p_token1 => G_COL_NAME_TOKEN,
1417: p_token1_value => 'Stream_Type_Id');

Line 1422: OKC_API.SET_MESSAGE (

1418: END IF;
1419:
1420: IF NVL (p_tilv_rec.description, G_MISS_CHAR) = G_MISS_CHAR THEN
1421: l_return_status := OKL_API.G_RET_STS_ERROR;
1422: OKC_API.SET_MESSAGE (
1423: p_app_name => G_OKC_APP_NAME,
1424: p_msg_name => G_REQUIRED_VALUE,
1425: p_token1 => G_COL_NAME_TOKEN,
1426: p_token1_value => 'Description');

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

1690: OPEN l_assetreturns_csr(cp_kle_id => l_cle_rec.cle_id);
1691: FETCH l_assetreturns_csr INTO l_legal_entity_id;
1692: CLOSE l_assetreturns_csr;
1693:
1694: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
1695: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1696: p_msg_name => g_required_value,
1697: p_token1 => g_col_name_token,
1698: p_token1_value => 'legal_entity_id');

Line 1699: RAISE OKC_API.G_EXCEPTION_ERROR;

1695: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1696: p_msg_name => g_required_value,
1697: p_token1 => g_col_name_token,
1698: p_token1_value => 'legal_entity_id');
1699: RAISE OKC_API.G_EXCEPTION_ERROR;
1700: END IF;
1701:
1702: -- Legal Entity Changes End
1703:

Line 1765: OKC_API.SET_MESSAGE (

1761:
1762: IF l_stream_status <> OKL_API.G_RET_STS_SUCCESS
1763: OR NVL (l_sty_id, G_MISS_NUM) = G_MISS_NUM THEN
1764: l_return_status := OKL_API.G_RET_STS_ERROR;
1765: OKC_API.SET_MESSAGE (
1766: p_app_name => G_OKC_APP_NAME,
1767: p_msg_name => G_INVALID_VALUE,
1768: p_token1 => G_COL_NAME_TOKEN,
1769: p_token1_value => 'Stream_Type');

Line 1930: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1926: -- End of comments
1927:
1928: PROCEDURE Create_Repair_Invoice (
1929: p_api_version IN NUMBER,
1930: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1931: x_msg_count OUT NOCOPY NUMBER,
1932: x_msg_data OUT NOCOPY VARCHAR2,
1933: x_return_status OUT NOCOPY VARCHAR2,
1934: p_ariv_tbl IN ariv_tbl_type,

Line 2007: OKC_API.SET_MESSAGE (

2003: -- **********************************************
2004:
2005: IF p_ariv_tbl.COUNT = 0 THEN
2006:
2007: OKC_API.SET_MESSAGE (
2008: p_app_name => G_OKC_APP_NAME,
2009: p_msg_name => 'OKC_NO_PARAMS',
2010: p_token1 => 'PARAM',
2011: p_token1_value => 'ARIV_TBL',

Line 2360: OKC_API.SET_MESSAGE (

2356: FETCH l_art_csr INTO l_art_rec;
2357:
2358: IF l_art_csr%NOTFOUND THEN
2359: l_return_status := OKL_API.G_RET_STS_ERROR;
2360: OKC_API.SET_MESSAGE (
2361: p_app_name => G_OKC_APP_NAME,
2362: p_msg_name => G_INVALID_VALUE,
2363: p_token1 => G_COL_NAME_TOKEN,
2364: p_token1_value => 'Order_Line_Id');

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

2365:
2366: ELSE
2367:
2368: -- RRAVIKIR Legal Entity Changes
2369: IF (l_art_rec.legal_entity_id is null or l_art_rec.legal_entity_id = OKC_API.G_MISS_NUM) THEN
2370: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2371: p_msg_name => g_required_value,
2372: p_token1 => g_col_name_token,
2373: p_token1_value => 'legal_entity_id');

Line 2374: RAISE OKC_API.G_EXCEPTION_ERROR;

2370: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2371: p_msg_name => g_required_value,
2372: p_token1 => g_col_name_token,
2373: p_token1_value => 'legal_entity_id');
2374: RAISE OKC_API.G_EXCEPTION_ERROR;
2375: END IF;
2376: -- Legal Entity Changes End
2377:
2378: l_taiv_rec.khr_id := l_art_rec.chr_id;

Line 2480: OKC_API.SET_MESSAGE (

2476: OR l_tilv_rec.amount = G_MISS_NUM
2477: OR l_tilv_rec.amount = 0 THEN
2478: l_return_status := OKL_API.G_RET_STS_ERROR;
2479: -- Message Text: Invalid value for the column Amount
2480: OKC_API.SET_MESSAGE (
2481: p_app_name => G_OKC_APP_NAME,
2482: p_msg_name => G_INVALID_VALUE,
2483: p_token1 => G_COL_NAME_TOKEN,
2484: p_token1_value => 'Amount');

Line 2554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2550: -- End of comments
2551:
2552: PROCEDURE Create_Remarket_Invoice (
2553: p_api_version IN NUMBER,
2554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2555: x_msg_count OUT NOCOPY NUMBER,
2556: x_msg_data OUT NOCOPY VARCHAR2,
2557: x_return_status OUT NOCOPY VARCHAR2,
2558: p_order_line_id IN NUMBER,

Line 2621: OKC_API.SET_MESSAGE (

2617:
2618: IF p_order_line_id IS NULL
2619: OR p_order_line_id = G_MISS_NUM THEN
2620:
2621: OKC_API.SET_MESSAGE (
2622: p_app_name => G_OKC_APP_NAME,
2623: p_msg_name => 'OKC_NO_PARAMS',
2624: p_token1 => 'PARAM',
2625: p_token1_value => 'ORDER_LINE_ID',

Line 3065: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3061: -- End of comments
3062:
3063: PROCEDURE Create_Scrt_Dpst_Dsps_Inv (
3064: p_api_version IN NUMBER,
3065: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3066: x_msg_count OUT NOCOPY NUMBER,
3067: x_msg_data OUT NOCOPY VARCHAR2,
3068: x_return_status OUT NOCOPY VARCHAR2,
3069: p_contract_id IN NUMBER,

Line 3144: OKC_API.SET_MESSAGE (

3140:
3141: IF p_contract_id IS NULL
3142: OR p_contract_id = G_MISS_NUM THEN
3143:
3144: OKC_API.SET_MESSAGE (
3145: p_app_name => G_OKC_APP_NAME,
3146: p_msg_name => 'OKC_NO_PARAMS',
3147: p_token1 => 'PARAM',
3148: p_token1_value => 'CONTRACT_ID',

Line 3605: OKC_API.SET_MESSAGE (

3601: FETCH l_qte_csr INTO l_qte_rec;
3602:
3603: IF l_qte_csr%NOTFOUND THEN
3604: l_return_status := OKL_API.G_RET_STS_ERROR;
3605: OKC_API.SET_MESSAGE (
3606: p_app_name => G_OKC_APP_NAME,
3607: p_msg_name => G_INVALID_VALUE,
3608: p_token1 => G_COL_NAME_TOKEN,
3609: p_token1_value => 'Quote_Id');

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

3627: OPEN l_assetreturn_csr(cp_id => l_qte_rec.art_id);
3628: FETCH l_assetreturn_csr INTO l_legal_entity_id;
3629: CLOSE l_assetreturn_csr;
3630:
3631: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
3632: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3633: p_msg_name => g_required_value,
3634: p_token1 => g_col_name_token,
3635: p_token1_value => 'legal_entity_id');

Line 3636: RAISE OKC_API.G_EXCEPTION_ERROR;

3632: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
3633: p_msg_name => g_required_value,
3634: p_token1 => g_col_name_token,
3635: p_token1_value => 'legal_entity_id');
3636: RAISE OKC_API.G_EXCEPTION_ERROR;
3637: END IF;
3638:
3639: l_taiv_rec.legal_entity_id := l_legal_entity_id;
3640: END IF;

Line 4330: OKC_API.SET_MESSAGE (

4326: -- AND nvl(l_future_invoices_exists,'N') = 'N' THEN -- rmunjulu 4610850 Added condition to Check if future billing adjustments exist
4327: IF NOT l_sdd_invoice THEN --added by veramach for bug#6766479
4328: l_return_status := OKL_API.G_RET_STS_ERROR;
4329: -- Message Text: The invoice has a balance of zero.
4330: OKC_API.SET_MESSAGE (
4331: p_app_name => G_APP_NAME,
4332: p_msg_name => 'OKL_BPD_ZERO_INVOICE');
4333: END IF; --added by veramach for bug#6766479
4334: IF l_sdd_invoice THEN --veramach bug#6766479

Line 4455: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4451: -- End of comments
4452:
4453: PROCEDURE Create_Quote_Invoice (
4454: p_api_version IN NUMBER,
4455: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4456: x_msg_count OUT NOCOPY NUMBER,
4457: x_msg_data OUT NOCOPY VARCHAR2,
4458: x_return_status OUT NOCOPY VARCHAR2,
4459: p_quote_id IN NUMBER,

Line 4647: OKC_API.SET_MESSAGE (

4643:
4644: IF p_quote_id IS NULL
4645: OR p_quote_id = G_MISS_NUM THEN
4646:
4647: OKC_API.SET_MESSAGE (
4648: p_app_name => G_OKC_APP_NAME,
4649: p_msg_name => 'OKC_NO_PARAMS',
4650: p_token1 => 'PARAM',
4651: p_token1_value => 'QUOTE_ID',

Line 5115: OKC_API.SET_MESSAGE (

5111: FETCH l_qte_csr INTO l_qte_rec;
5112:
5113: IF l_qte_csr%NOTFOUND THEN
5114: l_return_status := OKL_API.G_RET_STS_ERROR;
5115: OKC_API.SET_MESSAGE (
5116: p_app_name => G_OKC_APP_NAME,
5117: p_msg_name => G_INVALID_VALUE,
5118: p_token1 => G_COL_NAME_TOKEN,
5119: p_token1_value => 'Quote_Id');