APPS.AK_CUSTOM_PVT dependencies on FND_MESSAGE

Line 232: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');

228: fetch l_get_resp_id into l_resp_id_pk;
229: if (l_get_resp_id%notfound) then
230: close l_get_resp_id;
231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
232: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
233: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
234: FND_MSG_PUB.Add;
235: end if;
236: RAISE FND_API.G_EXC_ERROR;

Line 233: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

229: if (l_get_resp_id%notfound) then
230: close l_get_resp_id;
231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
232: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
233: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
234: FND_MSG_PUB.Add;
235: end if;
236: RAISE FND_API.G_EXC_ERROR;
237: end if;

Line 246: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');

242: fetch l_get_resp_id2 into l_level_id_pk;
243: if (l_get_resp_id2%notfound) then
244: close l_get_resp_id2;
245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
246: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
247: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
248: FND_MSG_PUB.Add;
249: end if;
250: RAISE FND_API.G_EXC_ERROR;

Line 247: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

243: if (l_get_resp_id2%notfound) then
244: close l_get_resp_id2;
245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
246: FND_MESSAGE.SET_NAME('AK','AK_RESP_IS_NOT_VALID');
247: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
248: FND_MSG_PUB.Add;
249: end if;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;

Line 260: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');

256: fetch l_get_org_id into l_org_id_pk;
257: if (l_get_org_id%notfound) then
258: close l_get_org_id;
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
260: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
261: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
262: FND_MSG_PUB.Add;
263: end if;
264: RAISE FND_API.G_EXC_ERROR;

Line 261: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

257: if (l_get_org_id%notfound) then
258: close l_get_org_id;
259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
260: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
261: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
262: FND_MSG_PUB.Add;
263: end if;
264: RAISE FND_API.G_EXC_ERROR;
265: end if;

Line 274: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');

270: fetch l_get_org_id2 into l_level_id_pk;
271: if (l_get_org_id2%notfound) then
272: close l_get_org_id2;
273: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
274: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
275: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
276: FND_MSG_PUB.Add;
277: end if;
278: RAISE FND_API.G_EXC_ERROR;

Line 275: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

271: if (l_get_org_id2%notfound) then
272: close l_get_org_id2;
273: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
274: FND_MESSAGE.SET_NAME('AK','AK_ORG_IS_NOT_VALID');
275: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
276: FND_MSG_PUB.Add;
277: end if;
278: RAISE FND_API.G_EXC_ERROR;
279: end if;

Line 288: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');

284: fetch l_get_fun_name into l_fun_pk;
285: if (l_get_fun_name%notfound) then
286: close l_get_fun_name;
287: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
288: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');
289: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
290: FND_MSG_PUB.Add;
291: end if;
292: RAISE FND_API.G_EXC_ERROR;

Line 289: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

285: if (l_get_fun_name%notfound) then
286: close l_get_fun_name;
287: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
288: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');
289: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
290: FND_MSG_PUB.Add;
291: end if;
292: RAISE FND_API.G_EXC_ERROR;
293: end if;

Line 302: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');

298: fetch l_get_fun_name2 into l_level_id_pk;
299: if (l_get_fun_name2%notfound) then
300: close l_get_fun_name2;
301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
302: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');
303: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
304: FND_MSG_PUB.Add;
305: end if;
306: RAISE FND_API.G_EXC_ERROR;

Line 303: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);

299: if (l_get_fun_name2%notfound) then
300: close l_get_fun_name2;
301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
302: FND_MESSAGE.SET_NAME('AK','AK_FUN_IS_NOT_VALID');
303: FND_MESSAGE.SET_TOKEN('KEY',p_levelpk);
304: FND_MSG_PUB.Add;
305: end if;
306: RAISE FND_API.G_EXC_ERROR;
307: end if;

Line 316: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

312: -- - a list of region_application_id and region_code in p_object_PK_tbl
313: if (p_application_id = FND_API.G_MISS_NUM) then
314: if (p_custom_PK_tbl.count = 0) then
315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
316: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
317: FND_MSG_PUB.Add;
318: end if;
319: raise FND_API.G_EXC_ERROR;
320: end if;

Line 326: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');

322: if (p_custom_PK_tbl.count > 0) then
323: -- both application ID and a list of regions to be extracted are
324: -- given, issue a warning that we will ignore the application ID
325: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
326: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
327: FND_MSG_PUB.Add;
328: end if;
329: end if;
330: end if;

Line 348: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');

344: l_custom_pk_tbl(l_index).region_code;
345: if (l_get_region_code_csr%notfound and l_index = 1) then
346: close l_get_region_code_csr;
347: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
348: FND_MESSAGE.SET_NAME('AK','AK_REGION_DOES_NOT_EXIST');
349: FND_MSG_PUB.Add;
350: end if;
351: raise FND_API.G_EXC_ERROR;
352: end if;

Line 590: -- FND_MESSAGE.SET_NAME('AK','AK_CUST_FOR_REG_DOES_NOT_EXIST');

586: end loop;
587:
588: -- else
589: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
590: -- FND_MESSAGE.SET_NAME('AK','AK_CUST_FOR_REG_DOES_NOT_EXIST');
591: -- FND_MSG_PUB.Add;
592: -- end if;
593: -- raise FND_API.G_EXC_ERROR;
594: end if;

Line 601: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_PK_VALUE_ERROR');

597:
598: EXCEPTION
599: WHEN VALUE_ERROR THEN
600: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
601: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_PK_VALUE_ERROR');
602: FND_MSG_PUB.Add;
603: end if;
604: --dbms_output.put_line('Value error occurred - check your custom list.');
605: p_return_status := FND_API.G_RET_STS_ERROR;

Line 790: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_DOES_NOT_EXIST');

786: fetch l_get_custom_csr into l_custom_rec;
787: if (l_get_custom_csr%notfound) then
788: close l_get_custom_csr;
789: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
790: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_DOES_NOT_EXIST');
791: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
792: p_region_code ||' '||
793: to_char(p_custom_application_id) ||' '||
794: p_custom_code);

Line 791: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

787: if (l_get_custom_csr%notfound) then
788: close l_get_custom_csr;
789: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
790: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_DOES_NOT_EXIST');
791: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
792: p_region_code ||' '||
793: to_char(p_custom_application_id) ||' '||
794: p_custom_code);
795: FND_MSG_PUB.Add;

Line 809: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_TL_DOES_NOT_EXIST');

805: fetch l_get_custom_tl_csr into l_custom_tl_rec;
806: if (l_get_custom_tl_csr%notfound) then
807: close l_get_custom_tl_csr;
808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
809: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_TL_DOES_NOT_EXIST');
810: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
811: p_region_code ||' '||
812: to_char(p_custom_application_id) ||' '||
813: p_custom_code);

Line 810: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

806: if (l_get_custom_tl_csr%notfound) then
807: close l_get_custom_tl_csr;
808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
809: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_TL_DOES_NOT_EXIST');
810: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
811: p_region_code ||' '||
812: to_char(p_custom_application_id) ||' '||
813: p_custom_code);
814: FND_MSG_PUB.Add;

Line 852: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');

848: then
849: -- dbms_output.put_line('Custom ' || p_custom_code
850: -- || ' not downloaded due to validation error');
851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
852: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');
853: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
854: p_region_code ||' '||
855: to_char(p_custom_application_id) ||' '||
856: p_custom_code);

Line 853: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

849: -- dbms_output.put_line('Custom ' || p_custom_code
850: -- || ' not downloaded due to validation error');
851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
852: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');
853: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
854: p_region_code ||' '||
855: to_char(p_custom_application_id) ||' '||
856: p_custom_code);
857: FND_MSG_PUB.Add;

Line 1075: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');

1071:
1072: EXCEPTION
1073: WHEN VALUE_ERROR THEN
1074: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1075: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1076: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1077: ' ' || p_region_code || ' ' ||
1078: to_char(p_custom_application_id) ||
1079: ' ' || p_custom_code);

Line 1076: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

1072: EXCEPTION
1073: WHEN VALUE_ERROR THEN
1074: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1075: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
1076: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1077: ' ' || p_region_code || ' ' ||
1078: to_char(p_custom_application_id) ||
1079: ' ' || p_custom_code);
1080: FND_MSG_PUB.Add;

Line 1085: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');

1081: end if;
1082: p_return_status := FND_API.G_RET_STS_ERROR;
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');
1086: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1087: ' ' || p_region_code || ' ' ||
1088: to_char(p_custom_application_id) ||
1089: ' ' || p_custom_code);

Line 1086: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

1082: p_return_status := FND_API.G_RET_STS_ERROR;
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_DOWNLOADED');
1086: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1087: ' ' || p_region_code || ' ' ||
1088: to_char(p_custom_application_id) ||
1089: ' ' || p_custom_code);
1090: FND_MSG_PUB.Add;

Line 1169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_TL_DOES_NOT_EXIST');

1165: open l_get_cust_region_tl_csr(l_cust_region_rec.property_name);
1166: fetch l_get_cust_region_tl_csr into l_cust_region_tl_rec;
1167: if (l_get_cust_region_tl_csr%notfound) then
1168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_TL_DOES_NOT_EXIST');
1170: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_rec.region_application_id) ||' '|| l_cust_region_rec.region_code ||' '|| to_char(l_cust_region_rec.customization_application_id) ||' '|| l_cust_region_rec.customization_code);
1171: FND_MSG_PUB.Add;
1172: end if;
1173: -- dbms_output.put_line('Cannot find customization '||p_custom_code);

Line 1170: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_rec.region_application_id) ||' '|| l_cust_region_rec.region_code ||' '|| to_char(l_cust_region_rec.customization_application_id) ||' '|| l_cust_region_rec.customization_code);

1166: fetch l_get_cust_region_tl_csr into l_cust_region_tl_rec;
1167: if (l_get_cust_region_tl_csr%notfound) then
1168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_TL_DOES_NOT_EXIST');
1170: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_rec.region_application_id) ||' '|| l_cust_region_rec.region_code ||' '|| to_char(l_cust_region_rec.customization_application_id) ||' '|| l_cust_region_rec.customization_code);
1171: FND_MSG_PUB.Add;
1172: end if;
1173: -- dbms_output.put_line('Cannot find customization '||p_custom_code);
1174: close l_get_cust_region_tl_csr;

Line 1197: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_DOWNLOADED');

1193: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1194: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1195: close l_get_cust_region_tl_csr;
1196: close l_get_cust_region_csr;
1197: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_DOWNLOADED');
1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1199: p_region_code ||' '||
1200: to_char(p_custom_application_id) ||' '||
1201: p_custom_code);

Line 1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

1194: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1195: close l_get_cust_region_tl_csr;
1196: close l_get_cust_region_csr;
1197: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_DOWNLOADED');
1198: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1199: p_region_code ||' '||
1200: to_char(p_custom_application_id) ||' '||
1201: p_custom_code);
1202: FND_MSG_PUB.Add;

Line 1294: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');

1290: p_return_status := FND_API.G_RET_STS_SUCCESS;
1291: EXCEPTION
1292: WHEN VALUE_ERROR THEN
1293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1294: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
1295: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1296: ' ' || p_region_code ||
1297: ' ' || to_char(p_custom_application_id) ||
1298: ' ' || p_custom_code || ' ' ||

Line 1295: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

1291: EXCEPTION
1292: WHEN VALUE_ERROR THEN
1293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1294: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
1295: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1296: ' ' || p_region_code ||
1297: ' ' || to_char(p_custom_application_id) ||
1298: ' ' || p_custom_code || ' ' ||
1299: ' ' || l_cust_region_rec.property_name);

Line 1385: FND_MESSAGE.SET_NAME('AK','AK_CUST_ITEM_TL_DOES_NOT_EXIST');

1381: l_cust_region_item_rec.property_name);
1382: fetch l_get_cust_region_item_tl_csr into l_cust_region_item_tl_rec;
1383: if (l_get_cust_region_item_tl_csr%notfound) then
1384: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1385: FND_MESSAGE.SET_NAME('AK','AK_CUST_ITEM_TL_DOES_NOT_EXIST');
1386: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_item_rec.region_application_id) ||' '|| l_cust_region_item_rec.region_code
1387: ||' '|| to_char(l_cust_region_item_rec.customization_application_id) ||' '|| l_cust_region_item_rec.customization_code
1388: ||' '|| l_cust_region_item_rec.property_name);
1389: FND_MSG_PUB.Add;

Line 1386: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_item_rec.region_application_id) ||' '|| l_cust_region_item_rec.region_code

1382: fetch l_get_cust_region_item_tl_csr into l_cust_region_item_tl_rec;
1383: if (l_get_cust_region_item_tl_csr%notfound) then
1384: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1385: FND_MESSAGE.SET_NAME('AK','AK_CUST_ITEM_TL_DOES_NOT_EXIST');
1386: FND_MESSAGE.SET_TOKEN('KEY', to_char(l_cust_region_item_rec.region_application_id) ||' '|| l_cust_region_item_rec.region_code
1387: ||' '|| to_char(l_cust_region_item_rec.customization_application_id) ||' '|| l_cust_region_item_rec.customization_code
1388: ||' '|| l_cust_region_item_rec.property_name);
1389: FND_MSG_PUB.Add;
1390: end if;

Line 1417: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_DOWNLOADED');

1413: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1415: close l_get_cust_region_item_tl_csr;
1416: close l_get_cust_region_item_csr;
1417: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_DOWNLOADED');
1418: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1419: p_region_code ||' '||
1420: to_char(p_custom_application_id) ||' '||
1421: p_custom_code);

Line 1418: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1415: close l_get_cust_region_item_tl_csr;
1416: close l_get_cust_region_item_csr;
1417: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_DOWNLOADED');
1418: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1419: p_region_code ||' '||
1420: to_char(p_custom_application_id) ||' '||
1421: p_custom_code);
1422: FND_MSG_PUB.Add;

Line 1517: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');

1513: p_return_status := FND_API.G_RET_STS_SUCCESS;
1514: EXCEPTION
1515: WHEN VALUE_ERROR THEN
1516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1517: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');
1518: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1519: ' ' || p_region_code ||
1520: ' ' || to_char(p_custom_application_id) ||
1521: ' ' || p_custom_code || ' ' ||

Line 1518: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

1514: EXCEPTION
1515: WHEN VALUE_ERROR THEN
1516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1517: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');
1518: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1519: ' ' || p_region_code ||
1520: ' ' || to_char(p_custom_application_id) ||
1521: ' ' || p_custom_code || ' ' ||
1522: ' ' || l_cust_region_item_rec.property_name);

Line 1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');

1606: p_end_date_active => l_criteria_rec.end_date_active,
1607: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1609: close l_get_criteria_csr;
1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');
1611: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1612: p_region_code ||' '||
1613: to_char(p_custom_application_id) ||' '||
1614: p_custom_code);

Line 1611: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

1607: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1609: close l_get_criteria_csr;
1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');
1611: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||
1612: p_region_code ||' '||
1613: to_char(p_custom_application_id) ||' '||
1614: p_custom_code);
1615: FND_MSG_PUB.Add;

Line 1715: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

1711: p_return_status := FND_API.G_RET_STS_SUCCESS;
1712: EXCEPTION
1713: WHEN VALUE_ERROR THEN
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1717: ' ' || p_region_code ||
1718: ' ' || to_char(p_custom_application_id) ||
1719: ' ' || p_custom_code || ' ' ||

Line 1716: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

1712: EXCEPTION
1713: WHEN VALUE_ERROR THEN
1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1715: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
1716: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
1717: ' ' || p_region_code ||
1718: ' ' || to_char(p_custom_application_id) ||
1719: ' ' || p_custom_code || ' ' ||
1720: ' ' || to_char(l_criteria_rec.sequence_number));

Line 1816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1812: if ((p_region_application_id is null) or
1813: (p_region_application_id = FND_API.G_MISS_NUM)) then
1814: l_error := TRUE;
1815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1817: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
1818: FND_MSG_PUB.Add;
1819: end if;
1820: end if;

Line 1817: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

1813: (p_region_application_id = FND_API.G_MISS_NUM)) then
1814: l_error := TRUE;
1815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1816: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1817: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
1818: FND_MSG_PUB.Add;
1819: end if;
1820: end if;
1821:

Line 1826: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1822: if ((p_region_code is null) or
1823: (p_region_code = FND_API.G_MISS_CHAR)) then
1824: l_error := TRUE;
1825: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1826: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1827: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
1828: FND_MSG_PUB.Add;
1829: end if;
1830: end if;

Line 1827: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

1823: (p_region_code = FND_API.G_MISS_CHAR)) then
1824: l_error := TRUE;
1825: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1826: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1827: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
1828: FND_MSG_PUB.Add;
1829: end if;
1830: end if;
1831:

Line 1836: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1832: if ((p_custom_application_id is null) or
1833: (p_custom_application_id = FND_API.G_MISS_NUM)) then
1834: l_error := TRUE;
1835: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1836: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1837: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_APPLICATION_ID');
1838: FND_MSG_PUB.Add;
1839: end if;
1840: end if;

Line 1837: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_APPLICATION_ID');

1833: (p_custom_application_id = FND_API.G_MISS_NUM)) then
1834: l_error := TRUE;
1835: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1836: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1837: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_APPLICATION_ID');
1838: FND_MSG_PUB.Add;
1839: end if;
1840: end if;
1841:

Line 1846: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1842: if ((p_custom_code is null) or
1843: (p_custom_code = FND_API.G_MISS_CHAR)) then
1844: l_error := TRUE;
1845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1846: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1847: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_CODE');
1848: FND_MSG_PUB.Add;
1849: end if;
1850: end if;

Line 1847: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_CODE');

1843: (p_custom_code = FND_API.G_MISS_CHAR)) then
1844: l_error := TRUE;
1845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1846: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1847: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_CODE');
1848: FND_MSG_PUB.Add;
1849: end if;
1850: end if;
1851:

Line 1859: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1855: (p_customization_level_id = FND_API.G_MISS_NUM and
1856: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1857: l_error := TRUE;
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1859: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1860: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_LEVEL_ID');
1861: FND_MSG_PUB.Add;
1862: end if;
1863: end if;

Line 1860: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_LEVEL_ID');

1856: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1857: l_error := TRUE;
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1859: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1860: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_LEVEL_ID');
1861: FND_MSG_PUB.Add;
1862: end if;
1863: end if;
1864:

Line 1870: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1866: (p_start_date_active = FND_API.G_MISS_DATE and
1867: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1868: l_error := TRUE;
1869: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1870: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1871: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');
1872: FND_MSG_PUB.Add;
1873: end if;
1874: end if;

Line 1871: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');

1867: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1868: l_error := TRUE;
1869: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1870: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1871: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');
1872: FND_MSG_PUB.Add;
1873: end if;
1874: end if;
1875:

Line 1881: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

1877: (p_name = FND_API.G_MISS_CHAR and
1878: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1879: l_error := TRUE;
1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1881: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
1883: FND_MSG_PUB.Add;
1884: end if;
1885: end if;

Line 1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

1878: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1879: l_error := TRUE;
1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1881: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');
1883: FND_MSG_PUB.Add;
1884: end if;
1885: end if;
1886:

Line 1896: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');

1892: p_region_application_id => p_region_application_id,
1893: p_region_code => p_region_code)) then
1894: l_error := TRUE;
1895: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1896: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
1897: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) || ' ' ||
1898: p_region_code);
1899: FND_MSG_PUB.Add;
1900: end if;

Line 1897: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) || ' ' ||

1893: p_region_code => p_region_code)) then
1894: l_error := TRUE;
1895: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1896: FND_MESSAGE.SET_NAME('AK','AK_INVALID_REGION_REFERENCE');
1897: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) || ' ' ||
1898: p_region_code);
1899: FND_MSG_PUB.Add;
1900: end if;
1901: --dbms_output.put_line(l_api_name || ' Invalid region');

Line 2004: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2000: if ((p_region_application_id is null) or
2001: (p_region_application_id = FND_API.G_MISS_NUM)) then
2002: l_error := TRUE;
2003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2004: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2005: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2006: FND_MSG_PUB.Add;
2007: end if;
2008: end if;

Line 2005: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

2001: (p_region_application_id = FND_API.G_MISS_NUM)) then
2002: l_error := TRUE;
2003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2004: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2005: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2006: FND_MSG_PUB.Add;
2007: end if;
2008: end if;
2009:

Line 2014: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2010: if ((p_region_code is null) or
2011: (p_region_code = FND_API.G_MISS_CHAR)) then
2012: l_error := TRUE;
2013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2014: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2015: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2016: FND_MSG_PUB.Add;
2017: end if;
2018: end if;

Line 2015: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

2011: (p_region_code = FND_API.G_MISS_CHAR)) then
2012: l_error := TRUE;
2013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2014: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2015: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2016: FND_MSG_PUB.Add;
2017: end if;
2018: end if;
2019:

Line 2024: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2020: if ((p_custom_application_id is null) or
2021: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2022: l_error := TRUE;
2023: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2024: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2025: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2026: FND_MSG_PUB.Add;
2027: end if;
2028: end if;

Line 2025: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');

2021: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2022: l_error := TRUE;
2023: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2024: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2025: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2026: FND_MSG_PUB.Add;
2027: end if;
2028: end if;
2029:

Line 2034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2030: if ((p_custom_code is null) or
2031: (p_custom_code = FND_API.G_MISS_CHAR)) then
2032: l_error := TRUE;
2033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2036: FND_MSG_PUB.Add;
2037: end if;
2038: end if;

Line 2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');

2031: (p_custom_code = FND_API.G_MISS_CHAR)) then
2032: l_error := TRUE;
2033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2036: FND_MSG_PUB.Add;
2037: end if;
2038: end if;
2039:

Line 2044: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2040: if ((p_property_name is null) or
2041: (p_property_name = FND_API.G_MISS_CHAR)) then
2042: l_error := TRUE;
2043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2044: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2045: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');
2046: FND_MSG_PUB.Add;
2047: end if;
2048: end if;

Line 2045: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');

2041: (p_property_name = FND_API.G_MISS_CHAR)) then
2042: l_error := TRUE;
2043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2044: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2045: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');
2046: FND_MSG_PUB.Add;
2047: end if;
2048: end if;
2049:

Line 2057: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');

2053: if (l_check_custom_csr%notfound) then
2054: l_error := TRUE;
2055: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2
2056: ) then
2057: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2058: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2059: ' ' || p_region_code );
2060: FND_MSG_PUB.Add;
2061: end if;

Line 2058: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

2054: l_error := TRUE;
2055: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2
2056: ) then
2057: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2058: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2059: ' ' || p_region_code );
2060: FND_MSG_PUB.Add;
2061: end if;
2062: --dbms_output.put_line('Parent region does not exist!');

Line 2168: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2164: if ((p_region_application_id is null) or
2165: (p_region_application_id = FND_API.G_MISS_NUM)) then
2166: l_error := TRUE;
2167: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2168: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2169: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2170: FND_MSG_PUB.Add;
2171: end if;
2172: end if;

Line 2169: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

2165: (p_region_application_id = FND_API.G_MISS_NUM)) then
2166: l_error := TRUE;
2167: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2168: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2169: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2170: FND_MSG_PUB.Add;
2171: end if;
2172: end if;
2173:

Line 2178: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2174: if ((p_region_code is null) or
2175: (p_region_code = FND_API.G_MISS_CHAR)) then
2176: l_error := TRUE;
2177: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2178: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2179: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2180: FND_MSG_PUB.Add;
2181: end if;
2182: end if;

Line 2179: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

2175: (p_region_code = FND_API.G_MISS_CHAR)) then
2176: l_error := TRUE;
2177: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2178: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2179: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2180: FND_MSG_PUB.Add;
2181: end if;
2182: end if;
2183:

Line 2188: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2184: if ((p_custom_application_id is null) or
2185: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2186: l_error := TRUE;
2187: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2188: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2189: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2190: FND_MSG_PUB.Add;
2191: end if;
2192: end if;

Line 2189: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');

2185: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2186: l_error := TRUE;
2187: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2188: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2189: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2190: FND_MSG_PUB.Add;
2191: end if;
2192: end if;
2193:

Line 2198: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2194: if ((p_custom_code is null) or
2195: (p_custom_code = FND_API.G_MISS_CHAR)) then
2196: l_error := TRUE;
2197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2198: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2199: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2200: FND_MSG_PUB.Add;
2201: end if;
2202: end if;

Line 2199: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');

2195: (p_custom_code = FND_API.G_MISS_CHAR)) then
2196: l_error := TRUE;
2197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2198: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2199: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2200: FND_MSG_PUB.Add;
2201: end if;
2202: end if;
2203:

Line 2208: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2204: if ((p_property_name is null) or
2205: (p_property_name = FND_API.G_MISS_CHAR)) then
2206: l_error := TRUE;
2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2208: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2209: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');
2210: FND_MSG_PUB.Add;
2211: end if;
2212: end if;

Line 2209: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');

2205: (p_property_name = FND_API.G_MISS_CHAR)) then
2206: l_error := TRUE;
2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2208: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2209: FND_MESSAGE.SET_TOKEN('COLUMN', 'PROPERTY_NAME');
2210: FND_MSG_PUB.Add;
2211: end if;
2212: end if;
2213:

Line 2218: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2214: if ((p_attr_appl_id is null) or
2215: (p_attr_appl_id = FND_API.G_MISS_NUM)) then
2216: l_error := TRUE;
2217: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2218: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2219: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2220: FND_MSG_PUB.Add;
2221: end if;
2222: end if;

Line 2219: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

2215: (p_attr_appl_id = FND_API.G_MISS_NUM)) then
2216: l_error := TRUE;
2217: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2218: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2219: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2220: FND_MSG_PUB.Add;
2221: end if;
2222: end if;
2223:

Line 2228: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2224: if ((p_attr_code is null) or
2225: (p_attr_code = FND_API.G_MISS_CHAR)) then
2226: l_error := TRUE;
2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2228: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2229: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2230: FND_MSG_PUB.Add;
2231: end if;
2232: end if;

Line 2229: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

2225: (p_attr_code = FND_API.G_MISS_CHAR)) then
2226: l_error := TRUE;
2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2228: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2229: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2230: FND_MSG_PUB.Add;
2231: end if;
2232: end if;
2233:

Line 2240: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');

2236: fetch l_check_custom_csr into l_dummy;
2237: if (l_check_custom_csr%notfound) then
2238: l_error := TRUE;
2239: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2240: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2242: ' ' || p_region_code );
2243: FND_MSG_PUB.Add;
2244: end if;

Line 2241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

2237: if (l_check_custom_csr%notfound) then
2238: l_error := TRUE;
2239: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2240: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2242: ' ' || p_region_code );
2243: FND_MSG_PUB.Add;
2244: end if;
2245: --dbms_output.put_line('Parent region does not exist!');

Line 2353: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2349: if ((p_region_application_id is null) or
2350: (p_region_application_id = FND_API.G_MISS_NUM)) then
2351: l_error := TRUE;
2352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2353: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2354: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2355: FND_MSG_PUB.Add;
2356: end if;
2357: end if;

Line 2354: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');

2350: (p_region_application_id = FND_API.G_MISS_NUM)) then
2351: l_error := TRUE;
2352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2353: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2354: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_APPLICATION_ID');
2355: FND_MSG_PUB.Add;
2356: end if;
2357: end if;
2358:

Line 2363: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2359: if ((p_region_code is null) or
2360: (p_region_code = FND_API.G_MISS_CHAR)) then
2361: l_error := TRUE;
2362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2363: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2364: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2365: FND_MSG_PUB.Add;
2366: end if;
2367: end if;

Line 2364: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');

2360: (p_region_code = FND_API.G_MISS_CHAR)) then
2361: l_error := TRUE;
2362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2363: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2364: FND_MESSAGE.SET_TOKEN('COLUMN', 'REGION_CODE');
2365: FND_MSG_PUB.Add;
2366: end if;
2367: end if;
2368:

Line 2373: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2369: if ((p_custom_application_id is null) or
2370: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2371: l_error := TRUE;
2372: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2373: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2375: FND_MSG_PUB.Add;
2376: end if;
2377: end if;

Line 2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');

2370: (p_custom_application_id = FND_API.G_MISS_NUM)) then
2371: l_error := TRUE;
2372: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2373: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_APPLICATION_ID');
2375: FND_MSG_PUB.Add;
2376: end if;
2377: end if;
2378:

Line 2383: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2379: if ((p_custom_code is null) or
2380: (p_custom_code = FND_API.G_MISS_CHAR)) then
2381: l_error := TRUE;
2382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2383: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2384: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2385: FND_MSG_PUB.Add;
2386: end if;
2387: end if;

Line 2384: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');

2380: (p_custom_code = FND_API.G_MISS_CHAR)) then
2381: l_error := TRUE;
2382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2383: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2384: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOM_CODE');
2385: FND_MSG_PUB.Add;
2386: end if;
2387: end if;
2388:

Line 2393: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2389: if ((p_attr_appl_id is null) or
2390: (p_attr_appl_id = FND_API.G_MISS_NUM)) then
2391: l_error := TRUE;
2392: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2393: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2394: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2395: FND_MSG_PUB.Add;
2396: end if;
2397: end if;

Line 2394: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

2390: (p_attr_appl_id = FND_API.G_MISS_NUM)) then
2391: l_error := TRUE;
2392: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2393: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2394: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
2395: FND_MSG_PUB.Add;
2396: end if;
2397: end if;
2398:

Line 2403: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2399: if ((p_attr_code is null) or
2400: (p_attr_code = FND_API.G_MISS_CHAR)) then
2401: l_error := TRUE;
2402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2403: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2404: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2405: FND_MSG_PUB.Add;
2406: end if;
2407: end if;

Line 2404: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

2400: (p_attr_code = FND_API.G_MISS_CHAR)) then
2401: l_error := TRUE;
2402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2403: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2404: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
2405: FND_MSG_PUB.Add;
2406: end if;
2407: end if;
2408:

Line 2417: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2413: (p_start_date_active = FND_API.G_MISS_DATE and
2414: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2415: l_error := TRUE;
2416: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2417: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2418: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: end if;

Line 2418: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');

2414: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2415: l_error := TRUE;
2416: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2417: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2418: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');
2419: FND_MSG_PUB.Add;
2420: end if;
2421: end if;
2422:

Line 2429: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');

2425: fetch l_check_custom_csr into l_dummy;
2426: if (l_check_custom_csr%notfound) then
2427: l_error := TRUE;
2428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2429: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2430: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2431: ' ' || p_region_code );
2432: FND_MSG_PUB.Add;
2433: end if;

Line 2430: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

2426: if (l_check_custom_csr%notfound) then
2427: l_error := TRUE;
2428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2429: FND_MESSAGE.SET_NAME('AK','AK_INVALID_CUSTOM_REFERENCE');
2430: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
2431: ' ' || p_region_code );
2432: FND_MSG_PUB.Add;
2433: end if;
2434: --dbms_output.put_line('Parent region does not exist!');

Line 2446: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

2442: (p_operation = FND_API.G_MISS_CHAR and
2443: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2444: l_error := TRUE;
2445: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2446: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2447: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION');
2448: FND_MSG_PUB.Add;
2449: end if;
2450: end if;

Line 2447: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION');

2443: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2444: l_error := TRUE;
2445: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2446: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2447: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION');
2448: FND_MSG_PUB.Add;
2449: end if;
2450: end if;
2451:

Line 2578: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_EXISTS');

2574: p_custom_code => p_custom_code,
2575: p_region_application_id => p_region_appl_id,
2576: p_region_code => p_region_code) then
2577: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2578: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_EXISTS');
2579: FND_MSG_PUB.Add;
2580: end if;
2581: --dbms_output.put_line(l_api_name || 'Error - row already exists');
2582: raise FND_API.G_EXC_ERROR;

Line 2762: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUSTOM_FAILED');

2758: p_region_application_id => p_region_appl_id,
2759: p_region_code => p_region_code) then
2760:
2761: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2762: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUSTOM_FAILED');
2763: FND_MSG_PUB.Add;
2764: end if;
2765: --dbms_output.put_line(l_api_name || 'Error - row already exists');
2766: raise FND_API.G_EXC_ERROR;

Line 2812: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_CREATED');

2808: -- /** commit the insert **/
2809: commit;
2810:
2811: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2812: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_CREATED');
2813: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUSTOM',TRUE);
2814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2815: ' ' || p_custom_code || ' ' || to_char(p_region_appl_id) || ' ' || p_region_code || ' ' || p_name);
2816: FND_MSG_PUB.Add;

Line 2813: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUSTOM',TRUE);

2809: commit;
2810:
2811: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2812: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_CREATED');
2813: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUSTOM',TRUE);
2814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2815: ' ' || p_custom_code || ' ' || to_char(p_region_appl_id) || ' ' || p_region_code || ' ' || p_name);
2816: FND_MSG_PUB.Add;
2817: end if;

Line 2814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

2810:
2811: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2812: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_CREATED');
2813: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUSTOM',TRUE);
2814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2815: ' ' || p_custom_code || ' ' || to_char(p_region_appl_id) || ' ' || p_region_code || ' ' || p_name);
2816: FND_MSG_PUB.Add;
2817: end if;
2818:

Line 2828: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');

2824:
2825: EXCEPTION
2826: WHEN VALUE_ERROR THEN
2827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2828: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
2829: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2830: ' ' || p_custom_code || ' ' ||
2831: to_char(p_region_appl_id) || ' ' ||
2832: p_region_code ||

Line 2829: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

2825: EXCEPTION
2826: WHEN VALUE_ERROR THEN
2827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2828: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
2829: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2830: ' ' || p_custom_code || ' ' ||
2831: to_char(p_region_appl_id) || ' ' ||
2832: p_region_code ||
2833: ' ' || p_name);

Line 2843: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_CREATED');

2839: p_count => p_msg_count,
2840: p_data => p_msg_data);
2841: WHEN FND_API.G_EXC_ERROR THEN
2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_CREATED');
2844: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2845: ' ' || p_custom_code || ' ' ||
2846: to_char(p_region_appl_id) || ' ' ||
2847: p_region_code ||

Line 2844: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

2840: p_data => p_msg_data);
2841: WHEN FND_API.G_EXC_ERROR THEN
2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_CREATED');
2844: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
2845: ' ' || p_custom_code || ' ' ||
2846: to_char(p_region_appl_id) || ' ' ||
2847: p_region_code ||
2848: ' ' || p_name);

Line 2956: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_EXISTS');

2952: p_region_application_id => p_region_appl_id,
2953: p_region_code => p_region_code,
2954: p_property_name => p_property_name) then
2955: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2956: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_EXISTS');
2957: FND_MSG_PUB.Add;
2958: end if;
2959: --dbms_output.put_line(l_api_name || 'Error - row already exists');
2960: raise FND_API.G_EXC_ERROR;

Line 3085: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REGION_FAILED');

3081: p_region_code => p_region_code,
3082: p_property_name => p_property_name) then
3083:
3084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3085: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REGION_FAILED');
3086: FND_MSG_PUB.Add;
3087: end if;
3088: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3089: raise FND_API.G_EXC_ERROR;

Line 3136: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_CREATED');

3132: -- /** commit the insert **/
3133: commit;
3134:
3135: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3136: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_CREATED');
3137: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REGION',TRUE);
3138: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3139: ' ' || p_custom_code || ' ' ||
3140: to_char(p_region_appl_id) || ' ' ||

Line 3137: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REGION',TRUE);

3133: commit;
3134:
3135: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3136: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_CREATED');
3137: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REGION',TRUE);
3138: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3139: ' ' || p_custom_code || ' ' ||
3140: to_char(p_region_appl_id) || ' ' ||
3141: p_region_code ||

Line 3138: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3134:
3135: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3136: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_CREATED');
3137: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REGION',TRUE);
3138: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3139: ' ' || p_custom_code || ' ' ||
3140: to_char(p_region_appl_id) || ' ' ||
3141: p_region_code ||
3142: ' ' || p_property_name);

Line 3154: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');

3150:
3151: EXCEPTION
3152: WHEN VALUE_ERROR THEN
3153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3154: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
3155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3156: ' ' || p_custom_code || ' ' ||
3157: to_char(p_region_appl_id) || ' ' ||
3158: p_region_code ||

Line 3155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3151: EXCEPTION
3152: WHEN VALUE_ERROR THEN
3153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3154: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
3155: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3156: ' ' || p_custom_code || ' ' ||
3157: to_char(p_region_appl_id) || ' ' ||
3158: p_region_code ||
3159: ' ' || p_property_name);

Line 3169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_CREATED');

3165: p_count => p_msg_count,
3166: p_data => p_msg_data);
3167: WHEN FND_API.G_EXC_ERROR THEN
3168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_CREATED');
3170: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3171: ' ' || p_custom_code || ' ' ||
3172: to_char(p_region_appl_id) || ' ' ||
3173: p_region_code ||

Line 3170: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3166: p_data => p_msg_data);
3167: WHEN FND_API.G_EXC_ERROR THEN
3168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3169: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_CREATED');
3170: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3171: ' ' || p_custom_code || ' ' ||
3172: to_char(p_region_appl_id) || ' ' ||
3173: p_region_code ||
3174: ' ' || p_property_name);

Line 3286: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_EXISTS');

3282: p_attribute_appl_id => p_attr_appl_id,
3283: p_attribute_code => p_attr_code,
3284: p_property_name => p_property_name) then
3285: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3286: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_EXISTS');
3287: FND_MSG_PUB.Add;
3288: end if;
3289: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3290: raise FND_API.G_EXC_ERROR;

Line 3423: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REG_ITEM_FAILED');

3419: p_attribute_code => p_attr_code,
3420: p_property_name => p_property_name) then
3421:
3422: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3423: FND_MESSAGE.SET_NAME('AK','AK_INSERT_CUST_REG_ITEM_FAILED');
3424: FND_MSG_PUB.Add;
3425: end if;
3426: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3427: raise FND_API.G_EXC_ERROR;

Line 3480: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_CREATED');

3476: -- /** commit the insert **/
3477: commit;
3478:
3479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3480: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_CREATED');
3481: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REG_ITEM',TRUE);
3482: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3483: ' ' || p_custom_code || ' ' ||
3484: to_char(p_region_appl_id) || ' ' ||

Line 3481: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REG_ITEM',TRUE);

3477: commit;
3478:
3479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3480: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_CREATED');
3481: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REG_ITEM',TRUE);
3482: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3483: ' ' || p_custom_code || ' ' ||
3484: to_char(p_region_appl_id) || ' ' ||
3485: p_region_code || ' ' ||

Line 3482: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3478:
3479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3480: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_CREATED');
3481: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CUST_REG_ITEM',TRUE);
3482: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3483: ' ' || p_custom_code || ' ' ||
3484: to_char(p_region_appl_id) || ' ' ||
3485: p_region_code || ' ' ||
3486: to_char(p_attr_appl_id) || ' ' ||

Line 3500: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_VALUE_ERROR');

3496:
3497: EXCEPTION
3498: WHEN VALUE_ERROR THEN
3499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3500: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_VALUE_ERROR');
3501: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3502: ' ' || p_custom_code || ' ' ||
3503: to_char(p_region_appl_id) || ' ' ||
3504: p_region_code || ' ' ||

Line 3501: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3497: EXCEPTION
3498: WHEN VALUE_ERROR THEN
3499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3500: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_VALUE_ERROR');
3501: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3502: ' ' || p_custom_code || ' ' ||
3503: to_char(p_region_appl_id) || ' ' ||
3504: p_region_code || ' ' ||
3505: to_char(p_attr_appl_id) || ' ' ||

Line 3516: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_NOT_CREATED');

3512: p_count => p_msg_count,
3513: p_data => p_msg_data);
3514: WHEN FND_API.G_EXC_ERROR THEN
3515: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3516: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_NOT_CREATED');
3517: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3518: ' ' || p_custom_code || ' ' ||
3519: to_char(p_region_appl_id) || ' ' ||
3520: p_region_code || ' ' ||

Line 3517: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3513: p_data => p_msg_data);
3514: WHEN FND_API.G_EXC_ERROR THEN
3515: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3516: FND_MESSAGE.SET_NAME('AK','AK_CUST_REG_ITEM_NOT_CREATED');
3517: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3518: ' ' || p_custom_code || ' ' ||
3519: to_char(p_region_appl_id) || ' ' ||
3520: p_region_code || ' ' ||
3521: to_char(p_attr_appl_id) || ' ' ||

Line 3637: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_EXISTS');

3633: p_attribute_appl_id => p_attr_appl_id,
3634: p_attribute_code => p_attr_code,
3635: p_sequence_number => p_sequence_number) then
3636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3637: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_EXISTS');
3638: FND_MSG_PUB.Add;
3639: end if;
3640: --dbms_output.put_line(l_api_name || 'Error - row already exists');
3641: raise FND_API.G_EXC_ERROR;

Line 3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');

3773: -- /** commit the insert **/
3774: commit;
3775:
3776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');
3778: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CRITERIA',TRUE);
3779: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3780: ' ' || p_custom_code || ' ' ||
3781: to_char(p_region_appl_id) || ' ' ||

Line 3778: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CRITERIA',TRUE);

3774: commit;
3775:
3776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');
3778: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CRITERIA',TRUE);
3779: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3780: ' ' || p_custom_code || ' ' ||
3781: to_char(p_region_appl_id) || ' ' ||
3782: p_region_code || ' ' ||

Line 3779: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3775:
3776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3777: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_CREATED');
3778: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_LC_CRITERIA',TRUE);
3779: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3780: ' ' || p_custom_code || ' ' ||
3781: to_char(p_region_appl_id) || ' ' ||
3782: p_region_code || ' ' ||
3783: to_char(p_attr_appl_id) || ' ' ||

Line 3797: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

3793:
3794: EXCEPTION
3795: WHEN VALUE_ERROR THEN
3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3797: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3799: ' ' || p_custom_code || ' ' ||
3800: to_char(p_region_appl_id) || ' ' ||
3801: p_region_code || ' ' ||

Line 3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3794: EXCEPTION
3795: WHEN VALUE_ERROR THEN
3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3797: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3799: ' ' || p_custom_code || ' ' ||
3800: to_char(p_region_appl_id) || ' ' ||
3801: p_region_code || ' ' ||
3802: to_char(p_attr_appl_id) || ' ' ||

Line 3813: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_CREATED');

3809: p_count => p_msg_count,
3810: p_data => p_msg_data);
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3813: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_CREATED');
3814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3815: ' ' || p_custom_code || ' ' ||
3816: to_char(p_region_appl_id) || ' ' ||
3817: p_region_code || ' ' ||

Line 3814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||

3810: p_data => p_msg_data);
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3813: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_CREATED');
3814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_custom_appl_id) ||
3815: ' ' || p_custom_code || ' ' ||
3816: to_char(p_region_appl_id) || ' ' ||
3817: p_region_code || ' ' ||
3818: to_char(p_attr_appl_id) || ' ' ||

Line 4261: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_DOES_NOT_EXIST');

4257: open l_get_row_csr;
4258: fetch l_get_row_csr into l_custom_rec;
4259: if (l_get_row_csr%notfound) then
4260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4261: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_DOES_NOT_EXIST');
4262: FND_MSG_PUB.Add;
4263: end if;
4264: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
4265: close l_get_row_csr;

Line 4275: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_EXIST');

4271: open l_get_tl_row_csr(l_lang);
4272: fetch l_get_tl_row_csr into l_custom_tl_rec;
4273: if (l_get_tl_row_csr%notfound) then
4274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4275: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_EXIST');
4276: FND_MSG_PUB.Add;
4277: end if;
4278: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
4279: close l_get_tl_row_csr;

Line 4460: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');

4456: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
4457: and CUSTOMIZATION_CODE = p_custom_code;
4458: if (sql%notfound) then
4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4460: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');
4461: FND_MSG_PUB.Add;
4462: end if;
4463: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
4464: raise FND_API.G_EXC_ERROR;

Line 4493: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');

4489: and CUSTOMIZATION_CODE = p_custom_code
4490: and l_lang in (LANGUAGE, SOURCE_LANG);
4491: if (sql%notfound) then
4492: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4493: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATE_FAILED');
4494: FND_MSG_PUB.Add;
4495: end if;
4496: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
4497: raise FND_API.G_EXC_ERROR;

Line 4504: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATED');

4500: -- /** commit the update **/
4501: -- commit;
4502:
4503: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4504: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATED');
4505: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4506: ' ' || p_region_code ||
4507: ' ' || to_char(p_custom_appl_id) ||
4508: ' ' || p_custom_code );

Line 4505: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4501: -- commit;
4502:
4503: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4504: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_UPDATED');
4505: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4506: ' ' || p_region_code ||
4507: ' ' || to_char(p_custom_appl_id) ||
4508: ' ' || p_custom_code );
4509: FND_MSG_PUB.Add;

Line 4521: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');

4517:
4518: EXCEPTION
4519: WHEN VALUE_ERROR THEN
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4521: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
4522: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4523: ' ' || p_region_code ||
4524: ' ' || to_char(p_custom_appl_id) ||
4525: ' ' || p_custom_code );

Line 4522: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4518: EXCEPTION
4519: WHEN VALUE_ERROR THEN
4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4521: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_VALUE_ERROR');
4522: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4523: ' ' || p_region_code ||
4524: ' ' || to_char(p_custom_appl_id) ||
4525: ' ' || p_custom_code );
4526: FND_MSG_PUB.Add;

Line 4535: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_UPDATED');

4531: p_count => p_msg_count,
4532: p_data => p_msg_data);
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4535: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_UPDATED');
4536: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4537: ' ' || p_region_code ||
4538: ' ' || to_char(p_custom_appl_id) ||
4539: ' ' || p_custom_code );

Line 4536: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4532: p_data => p_msg_data);
4533: WHEN FND_API.G_EXC_ERROR THEN
4534: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4535: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_NOT_UPDATED');
4536: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4537: ' ' || p_region_code ||
4538: ' ' || to_char(p_custom_appl_id) ||
4539: ' ' || p_custom_code );
4540: FND_MSG_PUB.Add;

Line 4657: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_DOES_NOT_EXIST');

4653: open l_get_row_csr;
4654: fetch l_get_row_csr into l_cust_region_rec;
4655: if (l_get_row_csr%notfound) then
4656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4657: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_DOES_NOT_EXIST');
4658: FND_MSG_PUB.Add;
4659: end if;
4660: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
4661: close l_get_row_csr;

Line 4671: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_EXIST');

4667: open l_get_tl_row_csr(l_lang);
4668: fetch l_get_tl_row_csr into l_cust_region_tl_rec;
4669: if (l_get_tl_row_csr%notfound) then
4670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4671: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_EXIST');
4672: FND_MSG_PUB.Add;
4673: end if;
4674: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
4675: close l_get_tl_row_csr;

Line 4784: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');

4780: and CUSTOMIZATION_CODE = p_custom_code
4781: and PROPERTY_NAME = p_property_name;
4782: if (sql%notfound) then
4783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4784: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');
4785: FND_MSG_PUB.Add;
4786: end if;
4787: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
4788: raise FND_API.G_EXC_ERROR;

Line 4805: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');

4801: and PROPERTY_NAME = p_property_name
4802: and l_lang in (LANGUAGE, SOURCE_LANG);
4803: if (sql%notfound) then
4804: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4805: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATE_FAILED');
4806: FND_MSG_PUB.Add;
4807: end if;
4808: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
4809: raise FND_API.G_EXC_ERROR;

Line 4816: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATED');

4812: -- /** commit the update **/
4813: -- commit;
4814:
4815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4816: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATED');
4817: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4818: ' ' || p_region_code ||
4819: ' ' || to_char(p_custom_appl_id) ||
4820: ' ' || p_custom_code || ' ' ||

Line 4817: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4813: -- commit;
4814:
4815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4816: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_UPDATED');
4817: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4818: ' ' || p_region_code ||
4819: ' ' || to_char(p_custom_appl_id) ||
4820: ' ' || p_custom_code || ' ' ||
4821: p_property_name);

Line 4834: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');

4830:
4831: EXCEPTION
4832: WHEN VALUE_ERROR THEN
4833: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4834: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
4835: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4836: ' ' || p_region_code ||
4837: ' ' || to_char(p_custom_appl_id) ||
4838: ' ' || p_custom_code || ' ' ||

Line 4835: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4831: EXCEPTION
4832: WHEN VALUE_ERROR THEN
4833: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4834: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_VALUE_ERROR');
4835: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4836: ' ' || p_region_code ||
4837: ' ' || to_char(p_custom_appl_id) ||
4838: ' ' || p_custom_code || ' ' ||
4839: p_property_name);

Line 4849: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_UPDATED');

4845: p_count => p_msg_count,
4846: p_data => p_msg_data);
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4849: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_UPDATED');
4850: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4851: ' ' || p_region_code ||
4852: ' ' || to_char(p_custom_appl_id) ||
4853: ' ' || p_custom_code || ' ' ||

Line 4850: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

4846: p_data => p_msg_data);
4847: WHEN FND_API.G_EXC_ERROR THEN
4848: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4849: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_UPDATED');
4850: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
4851: ' ' || p_region_code ||
4852: ' ' || to_char(p_custom_appl_id) ||
4853: ' ' || p_custom_code || ' ' ||
4854: p_property_name);

Line 4978: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_DOES_NOT_EXIST');

4974: open l_get_row_csr;
4975: fetch l_get_row_csr into l_cust_reg_item_rec;
4976: if (l_get_row_csr%notfound) then
4977: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4978: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_DOES_NOT_EXIST');
4979: FND_MSG_PUB.Add;
4980: end if;
4981: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
4982: close l_get_row_csr;

Line 4992: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_DOES_NOT_EXIST');

4988: open l_get_tl_row_csr(l_lang);
4989: fetch l_get_tl_row_csr into l_cust_reg_item_tl_rec;
4990: if (l_get_tl_row_csr%notfound) then
4991: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4992: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_DOES_NOT_EXIST');
4993: FND_MSG_PUB.Add;
4994: end if;
4995: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
4996: close l_get_tl_row_csr;

Line 5109: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');

5105: and ATTRIBUTE_CODE = p_attribute_code
5106: and PROPERTY_NAME = p_property_name;
5107: if (sql%notfound) then
5108: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5109: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');
5110: FND_MSG_PUB.Add;
5111: end if;
5112: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
5113: raise FND_API.G_EXC_ERROR;

Line 5132: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');

5128: and PROPERTY_NAME = p_property_name
5129: and l_lang in (LANGUAGE, SOURCE_LANG);
5130: if (sql%notfound) then
5131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5132: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATE_FAILED');
5133: FND_MSG_PUB.Add;
5134: end if;
5135: --dbms_output.put_line(l_api_name || 'TL Row does not exist during update');
5136: raise FND_API.G_EXC_ERROR;

Line 5143: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATED');

5139: -- /** commit the update **/
5140: -- commit;
5141:
5142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5143: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATED');
5144: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5145: ' ' || p_region_code ||
5146: ' ' || to_char(p_custom_appl_id) ||
5147: ' ' || p_custom_code || ' ' ||

Line 5144: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5140: -- commit;
5141:
5142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5143: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_UPDATED');
5144: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5145: ' ' || p_region_code ||
5146: ' ' || to_char(p_custom_appl_id) ||
5147: ' ' || p_custom_code || ' ' ||
5148: p_property_name);

Line 5161: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');

5157:
5158: EXCEPTION
5159: WHEN VALUE_ERROR THEN
5160: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5161: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');
5162: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5163: ' ' || p_region_code ||
5164: ' ' || to_char(p_custom_appl_id) ||
5165: ' ' || p_custom_code || ' ' ||

Line 5162: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5158: EXCEPTION
5159: WHEN VALUE_ERROR THEN
5160: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5161: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_VALUE_ERROR');
5162: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5163: ' ' || p_region_code ||
5164: ' ' || to_char(p_custom_appl_id) ||
5165: ' ' || p_custom_code || ' ' ||
5166: p_property_name);

Line 5176: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_UPDATED');

5172: p_count => p_msg_count,
5173: p_data => p_msg_data);
5174: WHEN FND_API.G_EXC_ERROR THEN
5175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5176: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_UPDATED');
5177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5178: ' ' || p_region_code ||
5179: ' ' || to_char(p_custom_appl_id) ||
5180: ' ' || p_custom_code || ' ' ||

Line 5177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5173: p_data => p_msg_data);
5174: WHEN FND_API.G_EXC_ERROR THEN
5175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5176: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_UPDATED');
5177: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5178: ' ' || p_region_code ||
5179: ' ' || to_char(p_custom_appl_id) ||
5180: ' ' || p_custom_code || ' ' ||
5181: p_property_name);

Line 5290: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_DOES_NOT_EXIST');

5286: open l_get_row_csr;
5287: fetch l_get_row_csr into l_criteria_rec;
5288: if (l_get_row_csr%notfound) then
5289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5290: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_DOES_NOT_EXIST');
5291: FND_MSG_PUB.Add;
5292: end if;
5293: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
5294: close l_get_row_csr;

Line 5420: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATE_FAILED');

5416: and ATTRIBUTE_CODE = p_attribute_code
5417: and SEQUENCE_NUMBER = p_sequence_number;
5418: if (sql%notfound) then
5419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5420: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATE_FAILED');
5421: FND_MSG_PUB.Add;
5422: end if;
5423: -- dbms_output.put_line(l_api_name || 'Row does not exist during update');
5424: raise FND_API.G_EXC_ERROR;

Line 5431: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');

5427: -- /** commit the update **/
5428: -- commit;
5429:
5430: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5431: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');
5432: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5433: ' ' || p_region_code ||
5434: ' ' || to_char(p_custom_appl_id) ||
5435: ' ' || p_custom_code || ' ' ||

Line 5432: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5428: -- commit;
5429:
5430: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5431: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_UPDATED');
5432: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5433: ' ' || p_region_code ||
5434: ' ' || to_char(p_custom_appl_id) ||
5435: ' ' || p_custom_code || ' ' ||
5436: to_char(p_sequence_number));

Line 5449: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');

5445:
5446: EXCEPTION
5447: WHEN VALUE_ERROR THEN
5448: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5449: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
5450: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5451: ' ' || p_region_code ||
5452: ' ' || to_char(p_custom_appl_id) ||
5453: ' ' || p_custom_code || ' ' ||

Line 5450: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5446: EXCEPTION
5447: WHEN VALUE_ERROR THEN
5448: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5449: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_VALUE_ERROR');
5450: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5451: ' ' || p_region_code ||
5452: ' ' || to_char(p_custom_appl_id) ||
5453: ' ' || p_custom_code || ' ' ||
5454: to_char(p_sequence_number));

Line 5464: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');

5460: p_count => p_msg_count,
5461: p_data => p_msg_data);
5462: WHEN FND_API.G_EXC_ERROR THEN
5463: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5464: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');
5465: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5466: ' ' || p_region_code ||
5467: ' ' || to_char(p_custom_appl_id) ||
5468: ' ' || p_custom_code || ' ' ||

Line 5465: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||

5461: p_data => p_msg_data);
5462: WHEN FND_API.G_EXC_ERROR THEN
5463: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5464: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_UPDATED');
5465: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||
5466: ' ' || p_region_code ||
5467: ' ' || to_char(p_custom_appl_id) ||
5468: ' ' || p_custom_code || ' ' ||
5469: to_char(p_sequence_number));