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.AK_CUSTOM_PVT dependencies on FND_MSG_PUB

Line 231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

227: open l_get_resp_id(p_levelpk);
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;

Line 234: FND_MSG_PUB.Add;

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;
238: close l_get_resp_id;

Line 245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

241: open l_get_resp_id2;
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;

Line 248: FND_MSG_PUB.Add;

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;
252: close l_get_resp_id2;

Line 259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

255: open l_get_org_id(p_levelpk);
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;

Line 262: FND_MSG_PUB.Add;

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;
266: close l_get_org_id;

Line 273: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

269: open l_get_org_id2;
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;

Line 276: FND_MSG_PUB.Add;

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;
280: close l_get_org_id2;

Line 287: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

283: open l_get_fun_name(p_levelpk);
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;

Line 290: FND_MSG_PUB.Add;

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;
294: close l_get_fun_name;

Line 301: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

297: open l_get_fun_name2;
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;

Line 304: FND_MSG_PUB.Add;

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;
308: close l_get_fun_name2;

Line 315: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

311: -- - p_application_id alone, or
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;

Line 317: FND_MSG_PUB.Add;

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;
321: else

Line 325: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

321: else
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;

Line 327: FND_MSG_PUB.Add;

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;
331:

Line 347: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

343: l_custom_pk_tbl(l_index).region_appl_id,
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;

Line 349: FND_MSG_PUB.Add;

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;
353: exit when l_get_region_code_csr%notfound;

Line 589: -- if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

585: l_index := l_custom_pk_tbl.NEXT(l_index);
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;

Line 591: -- FND_MSG_PUB.Add;

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;
595:

Line 600: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

596: p_return_status := FND_API.G_RET_STS_SUCCESS;
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.');

Line 602: FND_MSG_PUB.Add;

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;
606: WHEN FND_API.G_EXC_ERROR THEN

Line 611: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

607: p_return_status := FND_API.G_RET_STS_ERROR;
608: WHEN OTHERS THEN
609: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
612: SUBSTR (SQLERRM, 1, 240) );
613: FND_MSG_PUB.Add;
614: end DOWNLOAD_CUSTOM;
615:

Line 613: FND_MSG_PUB.Add;

609: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
610: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
612: SUBSTR (SQLERRM, 1, 240) );
613: FND_MSG_PUB.Add;
614: end DOWNLOAD_CUSTOM;
615:
616: --=======================================================
617: -- Procedure INSERT_CUSTOM_PK_TABLE

Line 721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

717: WHEN FND_API.G_EXC_ERROR THEN
718: p_return_status := FND_API.G_RET_STS_ERROR;
719: WHEN OTHERS THEN
720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
722: SUBSTR (SQLERRM, 1, 240) );
723: FND_MSG_PUB.Add;
724: end INSERT_CUSTOM_PK_TABLE;
725:

Line 723: FND_MSG_PUB.Add;

719: WHEN OTHERS THEN
720: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
722: SUBSTR (SQLERRM, 1, 240) );
723: FND_MSG_PUB.Add;
724: end INSERT_CUSTOM_PK_TABLE;
725:
726: --=======================================================
727: -- Procedure WRITE_CUSTOM_TO_BUFFER (local procedure)

Line 789: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

785: open l_get_custom_csr;
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) ||' '||

Line 795: FND_MSG_PUB.Add;

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;
796: end if;
797: -- dbms_output.put_line('Cannot find customization '||p_custom_code);
798: RAISE FND_API.G_EXC_ERROR;
799: end if;

Line 808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

804: open l_get_custom_tl_csr;
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) ||' '||

Line 814: FND_MSG_PUB.Add;

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;
815: end if;
816: --dbms_output.put_line('Cannot find custom TL '||p_custom_code);
817: RAISE FND_API.G_EXC_ERROR;
818: end if;

Line 851: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

847: )
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) ||' '||

Line 857: FND_MSG_PUB.Add;

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;
858: end if;
859: raise FND_API.G_EXC_ERROR;
860: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUSTOM */
861: end if; /* if p_validation_level */

Line 1074: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1070: p_return_status := FND_API.G_RET_STS_SUCCESS;
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) ||

Line 1080: FND_MSG_PUB.Add;

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;
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

Line 1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1080: FND_MSG_PUB.Add;
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) ||

Line 1090: FND_MSG_PUB.Add;

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;
1091: end if;
1092: p_return_status := FND_API.G_RET_STS_ERROR;
1093: WHEN OTHERS THEN
1094: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1095: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1091: end if;
1092: p_return_status := FND_API.G_RET_STS_ERROR;
1093: WHEN OTHERS THEN
1094: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1096: SUBSTR (SQLERRM, 1, 240) );
1097: FND_MSG_PUB.Add;
1098: end WRITE_CUSTOM_TO_BUFFER;
1099:

Line 1097: FND_MSG_PUB.Add;

1093: WHEN OTHERS THEN
1094: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1096: SUBSTR (SQLERRM, 1, 240) );
1097: FND_MSG_PUB.Add;
1098: end WRITE_CUSTOM_TO_BUFFER;
1099:
1100: --=======================================================
1101: -- Procedure WRITE_CUST_REGION_TO_BUFFER (local procedure)

Line 1168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1164: exit when l_get_cust_region_csr%notfound;
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;

Line 1171: FND_MSG_PUB.Add;

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;
1175: close l_get_cust_region_csr;

Line 1194: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1190: p_property_number_value => l_cust_region_rec.property_number_value,
1191: p_criteria_join_condition => l_cust_region_rec.criteria_join_condition,
1192: p_property_varchar2_value_tl => l_cust_region_tl_rec.property_varchar2_value,
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) ||' '||

Line 1202: FND_MSG_PUB.Add;

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;
1203: raise FND_API.G_EXC_ERROR;
1204: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION */
1205:
1206:

Line 1293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1289:
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) ||

Line 1300: FND_MSG_PUB.Add;

1296: ' ' || p_region_code ||
1297: ' ' || to_char(p_custom_application_id) ||
1298: ' ' || p_custom_code || ' ' ||
1299: ' ' || l_cust_region_rec.property_name);
1300: FND_MSG_PUB.Add;
1301: end if;
1302: p_return_status := FND_API.G_RET_STS_ERROR;
1303: WHEN FND_API.G_EXC_ERROR THEN
1304: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1303: WHEN FND_API.G_EXC_ERROR THEN
1304: p_return_status := FND_API.G_RET_STS_ERROR;
1305: WHEN OTHERS THEN
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1308: SUBSTR (SQLERRM, 1, 240) );
1309: FND_MSG_PUB.Add;
1310: end WRITE_CUST_REGION_TO_BUFFER;
1311:

Line 1309: FND_MSG_PUB.Add;

1305: WHEN OTHERS THEN
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1308: SUBSTR (SQLERRM, 1, 240) );
1309: FND_MSG_PUB.Add;
1310: end WRITE_CUST_REGION_TO_BUFFER;
1311:
1312: --=======================================================
1313: -- Procedure WRITE_CUST_REG_ITEM_TO_BUFFER (local procedure)

Line 1384: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1380: open l_get_cust_region_item_tl_csr(l_cust_region_item_rec.attribute_application_id, l_cust_region_item_rec.attribute_code,
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);

Line 1389: FND_MSG_PUB.Add;

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;
1391: -- dbms_output.put_line('Cannot find customization '||p_custom_code);
1392: close l_get_cust_region_item_tl_csr;
1393: close l_get_cust_region_item_csr;

Line 1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1410: p_property_number_value => l_cust_region_item_rec.property_number_value,
1411: p_property_date_value => to_char(l_cust_region_item_rec.property_date_value),
1412: p_property_varchar2_value_tl => l_cust_region_item_rec.property_varchar2_value,
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) ||' '||

Line 1422: FND_MSG_PUB.Add;

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;
1423: raise FND_API.G_EXC_ERROR;
1424: end if; /* if AK_CUSTOM_PVT.VALIDATE_CUST_REGION_ITEM */
1425:
1426: else

Line 1516: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1512:
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) ||

Line 1523: FND_MSG_PUB.Add;

1519: ' ' || p_region_code ||
1520: ' ' || to_char(p_custom_application_id) ||
1521: ' ' || p_custom_code || ' ' ||
1522: ' ' || l_cust_region_item_rec.property_name);
1523: FND_MSG_PUB.Add;
1524: end if;
1525: p_return_status := FND_API.G_RET_STS_ERROR;
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1530: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1526: WHEN FND_API.G_EXC_ERROR THEN
1527: p_return_status := FND_API.G_RET_STS_ERROR;
1528: WHEN OTHERS THEN
1529: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1531: SUBSTR (SQLERRM, 1, 240) );
1532: FND_MSG_PUB.Add;
1533: end WRITE_CUST_REG_ITEM_TO_BUFFER;
1534:

Line 1532: FND_MSG_PUB.Add;

1528: WHEN OTHERS THEN
1529: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1531: SUBSTR (SQLERRM, 1, 240) );
1532: FND_MSG_PUB.Add;
1533: end WRITE_CUST_REG_ITEM_TO_BUFFER;
1534:
1535: --=======================================================
1536: -- Procedure WRITE_CRITERIA_TO_BUFFER (local procedure)

Line 1608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1604: p_value_date => to_char(l_criteria_rec.value_date),
1605: p_start_date_active => l_criteria_rec.start_date_active,
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 ||' '||

Line 1615: FND_MSG_PUB.Add;

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;
1616: raise FND_API.G_EXC_ERROR;
1617: end if; /* if AK_CUSTOM_PVT.VALIDATE_CRITERIA */
1618:
1619: else

Line 1714: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1710:
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) ||

Line 1721: FND_MSG_PUB.Add;

1717: ' ' || p_region_code ||
1718: ' ' || to_char(p_custom_application_id) ||
1719: ' ' || p_custom_code || ' ' ||
1720: ' ' || to_char(l_criteria_rec.sequence_number));
1721: FND_MSG_PUB.Add;
1722: end if;
1723: p_return_status := FND_API.G_RET_STS_ERROR;
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1728: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1724: WHEN FND_API.G_EXC_ERROR THEN
1725: p_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN OTHERS THEN
1727: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1729: SUBSTR (SQLERRM, 1, 240) );
1730: FND_MSG_PUB.Add;
1731: end WRITE_CRITERIA_TO_BUFFER;
1732:

Line 1730: FND_MSG_PUB.Add;

1726: WHEN OTHERS THEN
1727: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1729: SUBSTR (SQLERRM, 1, 240) );
1730: FND_MSG_PUB.Add;
1731: end WRITE_CRITERIA_TO_BUFFER;
1732:
1733: --=======================================================
1734: -- Function VALIDATE_CUSTOM

Line 1815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1811: --** check that key columns are not null and not missing **
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;

Line 1818: FND_MSG_PUB.Add;

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:
1822: if ((p_region_code is null) or

Line 1825: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1821:
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;

Line 1828: FND_MSG_PUB.Add;

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:
1832: if ((p_custom_application_id is null) or

Line 1835: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1831:
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;

Line 1838: FND_MSG_PUB.Add;

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:
1842: if ((p_custom_code is null) or

Line 1845: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1841:
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;

Line 1848: FND_MSG_PUB.Add;

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:
1852: --** check that required columns are not null and, unless calling **

Line 1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1854: if ((p_customization_level_id is null) or
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;

Line 1861: FND_MSG_PUB.Add;

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:
1865: if ((p_start_date_active is null) or

Line 1869: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1865: if ((p_start_date_active is null) or
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;

Line 1872: FND_MSG_PUB.Add;

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:
1876: if ((p_name is null) or

Line 1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1876: if ((p_name is null) or
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;

Line 1883: FND_MSG_PUB.Add;

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:
1887: --** Validate columns **

Line 1895: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1891: p_return_status => l_return_status,
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;

Line 1899: FND_MSG_PUB.Add;

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');
1902: end if;
1903:

Line 1914: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1910: p_return_status := FND_API.G_RET_STS_ERROR;
1911: return FALSE;
1912: WHEN OTHERS THEN
1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1915: SUBSTR (SQLERRM, 1, 240) );
1916: FND_MSG_PUB.Add;
1917: return FALSE;
1918:

Line 1916: FND_MSG_PUB.Add;

1912: WHEN OTHERS THEN
1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1915: SUBSTR (SQLERRM, 1, 240) );
1916: FND_MSG_PUB.Add;
1917: return FALSE;
1918:
1919: end VALIDATE_CUSTOM;
1920:

Line 2003: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

1999: --** check that key columns are not null and not missing **
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;

Line 2006: FND_MSG_PUB.Add;

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:
2010: if ((p_region_code is null) or

Line 2013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2009:
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;

Line 2016: FND_MSG_PUB.Add;

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:
2020: if ((p_custom_application_id is null) or

Line 2023: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2019:
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;

Line 2026: FND_MSG_PUB.Add;

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:
2030: if ((p_custom_code is null) or

Line 2033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2029:
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;

Line 2036: FND_MSG_PUB.Add;

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:
2040: if ((p_property_name is null) or

Line 2043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2039:
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;

Line 2046: FND_MSG_PUB.Add;

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:
2050: -- - Check that the parent region exists

Line 2055: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2

2051: open l_check_custom_csr;
2052: fetch l_check_custom_csr into l_dummy;
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 );

Line 2060: FND_MSG_PUB.Add;

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!');
2063: end if;
2064: close l_check_custom_csr;

Line 2076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2072: p_return_status := FND_API.G_RET_STS_ERROR;
2073: return FALSE;
2074: WHEN OTHERS THEN
2075: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2077: SUBSTR (SQLERRM, 1, 240) );
2078: FND_MSG_PUB.Add;
2079: return FALSE;
2080:

Line 2078: FND_MSG_PUB.Add;

2074: WHEN OTHERS THEN
2075: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2076: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2077: SUBSTR (SQLERRM, 1, 240) );
2078: FND_MSG_PUB.Add;
2079: return FALSE;
2080:
2081: end VALIDATE_CUST_REGION;
2082:

Line 2167: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2163: --** check that key columns are not null and not missing **
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;

Line 2170: FND_MSG_PUB.Add;

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:
2174: if ((p_region_code is null) or

Line 2177: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2173:
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;

Line 2180: FND_MSG_PUB.Add;

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:
2184: if ((p_custom_application_id is null) or

Line 2187: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2183:
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;

Line 2190: FND_MSG_PUB.Add;

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:
2194: if ((p_custom_code is null) or

Line 2197: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2193:
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;

Line 2200: FND_MSG_PUB.Add;

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:
2204: if ((p_property_name is null) or

Line 2207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2203:
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;

Line 2210: FND_MSG_PUB.Add;

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:
2214: if ((p_attr_appl_id is null) or

Line 2217: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2213:
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;

Line 2220: FND_MSG_PUB.Add;

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:
2224: if ((p_attr_code is null) or

Line 2227: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2223:
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;

Line 2230: FND_MSG_PUB.Add;

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:
2234: -- - Check that the parent region exists

Line 2239: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2235: open l_check_custom_csr;
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;

Line 2243: FND_MSG_PUB.Add;

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!');
2246: end if;
2247: close l_check_custom_csr;

Line 2259: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2255: p_return_status := FND_API.G_RET_STS_ERROR;
2256: return FALSE;
2257: WHEN OTHERS THEN
2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2259: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2260: SUBSTR (SQLERRM, 1, 240) );
2261: FND_MSG_PUB.Add;
2262: return FALSE;
2263:

Line 2261: FND_MSG_PUB.Add;

2257: WHEN OTHERS THEN
2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2259: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2260: SUBSTR (SQLERRM, 1, 240) );
2261: FND_MSG_PUB.Add;
2262: return FALSE;
2263:
2264: end VALIDATE_CUST_REGION_ITEM;
2265:

Line 2352: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2348: --** check that key columns are not null and not missing **
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;

Line 2355: FND_MSG_PUB.Add;

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:
2359: if ((p_region_code is null) or

Line 2362: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2358:
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;

Line 2365: FND_MSG_PUB.Add;

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:
2369: if ((p_custom_application_id is null) or

Line 2372: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2368:
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;

Line 2375: FND_MSG_PUB.Add;

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:
2379: if ((p_custom_code is null) or

Line 2382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2378:
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;

Line 2385: FND_MSG_PUB.Add;

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:
2389: if ((p_attr_appl_id is null) or

Line 2392: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2388:
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;

Line 2395: FND_MSG_PUB.Add;

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:
2399: if ((p_attr_code is null) or

Line 2402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2398:
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;

Line 2405: FND_MSG_PUB.Add;

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:
2409: --** check that required columns are not null and, unless calling **

Line 2416: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2412: if ((p_start_date_active is null) or
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;

Line 2419: FND_MSG_PUB.Add;

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:
2423: -- - Check that the parent region exists

Line 2428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2424: open l_check_custom_csr;
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;

Line 2432: FND_MSG_PUB.Add;

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!');
2435: end if;
2436: close l_check_custom_csr;

Line 2445: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then

2441: if ((p_operation is null) or
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;

Line 2448: FND_MSG_PUB.Add;

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:
2452: -- return true if no error, false otherwise

Line 2462: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2458: p_return_status := FND_API.G_RET_STS_ERROR;
2459: return FALSE;
2460: WHEN OTHERS THEN
2461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2462: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2463: SUBSTR (SQLERRM, 1, 240) );
2464: FND_MSG_PUB.Add;
2465: return FALSE;
2466:

Line 2464: FND_MSG_PUB.Add;

2460: WHEN OTHERS THEN
2461: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2462: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2463: SUBSTR (SQLERRM, 1, 240) );
2464: FND_MSG_PUB.Add;
2465: return FALSE;
2466:
2467: end VALIDATE_CRITERIA;
2468:

Line 2564: FND_MSG_PUB.initialize;

2560:
2561: -- Initialize the message table if requested.
2562:
2563: if p_init_msg_tbl then
2564: FND_MSG_PUB.initialize;
2565: end if;
2566:
2567: savepoint start_create_custom;
2568:

Line 2577: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2573: p_custom_appl_id => p_custom_appl_id,
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');

Line 2579: FND_MSG_PUB.Add;

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;
2583: end if;

Line 2761: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2757: p_custom_code => p_custom_code,
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');

Line 2763: FND_MSG_PUB.Add;

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;
2767: end if;

Line 2811: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

2807:
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);

Line 2816: FND_MSG_PUB.Add;

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:
2819: p_return_status := FND_API.G_RET_STS_SUCCESS;
2820:

Line 2821: FND_MSG_PUB.Count_And_Get (

2817: end if;
2818:
2819: p_return_status := FND_API.G_RET_STS_SUCCESS;
2820:
2821: FND_MSG_PUB.Count_And_Get (
2822: p_count => p_msg_count,
2823: p_data => p_msg_data);
2824:
2825: EXCEPTION

Line 2827: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2823: p_data => p_msg_data);
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) || ' ' ||

Line 2834: FND_MSG_PUB.Add;

2830: ' ' || p_custom_code || ' ' ||
2831: to_char(p_region_appl_id) || ' ' ||
2832: p_region_code ||
2833: ' ' || p_name);
2834: FND_MSG_PUB.Add;
2835: end if;
2836: p_return_status := FND_API.G_RET_STS_ERROR;
2837: rollback to start_create_custom;
2838: FND_MSG_PUB.Count_And_Get (

Line 2838: FND_MSG_PUB.Count_And_Get (

2834: FND_MSG_PUB.Add;
2835: end if;
2836: p_return_status := FND_API.G_RET_STS_ERROR;
2837: rollback to start_create_custom;
2838: FND_MSG_PUB.Count_And_Get (
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

Line 2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2838: FND_MSG_PUB.Count_And_Get (
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) || ' ' ||

Line 2849: FND_MSG_PUB.Add;

2845: ' ' || p_custom_code || ' ' ||
2846: to_char(p_region_appl_id) || ' ' ||
2847: p_region_code ||
2848: ' ' || p_name);
2849: FND_MSG_PUB.Add;
2850: end if;
2851: p_return_status := FND_API.G_RET_STS_ERROR;
2852: rollback to start_create_custom;
2853: FND_MSG_PUB.Count_And_Get (

Line 2853: FND_MSG_PUB.Count_And_Get (

2849: FND_MSG_PUB.Add;
2850: end if;
2851: p_return_status := FND_API.G_RET_STS_ERROR;
2852: rollback to start_create_custom;
2853: FND_MSG_PUB.Count_And_Get (
2854: p_count => p_msg_count,
2855: p_data => p_msg_data);
2856: WHEN OTHERS THEN
2857: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2855: p_data => p_msg_data);
2856: WHEN OTHERS THEN
2857: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: rollback to start_create_custom;
2859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2860: SUBSTR (SQLERRM, 1, 240) );
2861: FND_MSG_PUB.Add;
2862: FND_MSG_PUB.Count_And_Get (
2863: p_count => p_msg_count,

Line 2861: FND_MSG_PUB.Add;

2857: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: rollback to start_create_custom;
2859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2860: SUBSTR (SQLERRM, 1, 240) );
2861: FND_MSG_PUB.Add;
2862: FND_MSG_PUB.Count_And_Get (
2863: p_count => p_msg_count,
2864: p_data => p_msg_data);
2865: end CREATE_CUSTOM;

Line 2862: FND_MSG_PUB.Count_And_Get (

2858: rollback to start_create_custom;
2859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2860: SUBSTR (SQLERRM, 1, 240) );
2861: FND_MSG_PUB.Add;
2862: FND_MSG_PUB.Count_And_Get (
2863: p_count => p_msg_count,
2864: p_data => p_msg_data);
2865: end CREATE_CUSTOM;
2866:

Line 2941: FND_MSG_PUB.initialize;

2937:
2938: -- Initialize the message table if requested.
2939:
2940: if p_init_msg_tbl then
2941: FND_MSG_PUB.initialize;
2942: end if;
2943:
2944: savepoint start_create_cust_region;
2945:

Line 2955: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

2951: p_custom_code => p_custom_code,
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');

Line 2957: FND_MSG_PUB.Add;

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;
2961: end if;

Line 3084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3080: p_region_application_id => p_region_appl_id,
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');

Line 3086: FND_MSG_PUB.Add;

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;
3090: end if;

Line 3135: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3131:
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 || ' ' ||

Line 3143: FND_MSG_PUB.Add;

3139: ' ' || p_custom_code || ' ' ||
3140: to_char(p_region_appl_id) || ' ' ||
3141: p_region_code ||
3142: ' ' || p_property_name);
3143: FND_MSG_PUB.Add;
3144: end if;
3145: p_return_status := FND_API.G_RET_STS_SUCCESS;
3146:
3147: FND_MSG_PUB.Count_And_Get (

Line 3147: FND_MSG_PUB.Count_And_Get (

3143: FND_MSG_PUB.Add;
3144: end if;
3145: p_return_status := FND_API.G_RET_STS_SUCCESS;
3146:
3147: FND_MSG_PUB.Count_And_Get (
3148: p_count => p_msg_count,
3149: p_data => p_msg_data);
3150:
3151: EXCEPTION

Line 3153: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3149: p_data => p_msg_data);
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) || ' ' ||

Line 3160: FND_MSG_PUB.Add;

3156: ' ' || p_custom_code || ' ' ||
3157: to_char(p_region_appl_id) || ' ' ||
3158: p_region_code ||
3159: ' ' || p_property_name);
3160: FND_MSG_PUB.Add;
3161: end if;
3162: p_return_status := FND_API.G_RET_STS_ERROR;
3163: rollback to start_create_cust_region;
3164: FND_MSG_PUB.Count_And_Get (

Line 3164: FND_MSG_PUB.Count_And_Get (

3160: FND_MSG_PUB.Add;
3161: end if;
3162: p_return_status := FND_API.G_RET_STS_ERROR;
3163: rollback to start_create_cust_region;
3164: FND_MSG_PUB.Count_And_Get (
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

Line 3168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3164: FND_MSG_PUB.Count_And_Get (
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) || ' ' ||

Line 3175: FND_MSG_PUB.Add;

3171: ' ' || p_custom_code || ' ' ||
3172: to_char(p_region_appl_id) || ' ' ||
3173: p_region_code ||
3174: ' ' || p_property_name);
3175: FND_MSG_PUB.Add;
3176: end if;
3177: p_return_status := FND_API.G_RET_STS_ERROR;
3178: rollback to start_create_cust_region;
3179: FND_MSG_PUB.Count_And_Get (

Line 3179: FND_MSG_PUB.Count_And_Get (

3175: FND_MSG_PUB.Add;
3176: end if;
3177: p_return_status := FND_API.G_RET_STS_ERROR;
3178: rollback to start_create_cust_region;
3179: FND_MSG_PUB.Count_And_Get (
3180: p_count => p_msg_count,
3181: p_data => p_msg_data);
3182: WHEN OTHERS THEN
3183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3185: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3181: p_data => p_msg_data);
3182: WHEN OTHERS THEN
3183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3184: rollback to start_create_cust_region;
3185: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3186: SUBSTR (SQLERRM, 1, 240) );
3187: FND_MSG_PUB.Add;
3188: FND_MSG_PUB.Count_And_Get (
3189: p_count => p_msg_count,

Line 3187: FND_MSG_PUB.Add;

3183: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3184: rollback to start_create_cust_region;
3185: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3186: SUBSTR (SQLERRM, 1, 240) );
3187: FND_MSG_PUB.Add;
3188: FND_MSG_PUB.Count_And_Get (
3189: p_count => p_msg_count,
3190: p_data => p_msg_data);
3191: end CREATE_CUST_REGION;

Line 3188: FND_MSG_PUB.Count_And_Get (

3184: rollback to start_create_cust_region;
3185: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3186: SUBSTR (SQLERRM, 1, 240) );
3187: FND_MSG_PUB.Add;
3188: FND_MSG_PUB.Count_And_Get (
3189: p_count => p_msg_count,
3190: p_data => p_msg_data);
3191: end CREATE_CUST_REGION;
3192:

Line 3269: FND_MSG_PUB.initialize;

3265:
3266: -- Initialize the message table if requested.
3267:
3268: if p_init_msg_tbl then
3269: FND_MSG_PUB.initialize;
3270: end if;
3271:
3272: savepoint start_create_cust_reg_item;
3273:

Line 3285: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3281: p_region_code => p_region_code,
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');

Line 3287: FND_MSG_PUB.Add;

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;
3291: end if;

Line 3422: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3418: p_attribute_appl_id => p_attr_appl_id,
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');

Line 3424: FND_MSG_PUB.Add;

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;
3428: end if;

Line 3479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3475:
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 || ' ' ||

Line 3488: FND_MSG_PUB.Add;

3484: to_char(p_region_appl_id) || ' ' ||
3485: p_region_code || ' ' ||
3486: to_char(p_attr_appl_id) || ' ' ||
3487: p_attr_code || ' ' || p_property_name);
3488: FND_MSG_PUB.Add;
3489: end if;
3490:
3491: p_return_status := FND_API.G_RET_STS_SUCCESS;
3492:

Line 3493: FND_MSG_PUB.Count_And_Get (

3489: end if;
3490:
3491: p_return_status := FND_API.G_RET_STS_SUCCESS;
3492:
3493: FND_MSG_PUB.Count_And_Get (
3494: p_count => p_msg_count,
3495: p_data => p_msg_data);
3496:
3497: EXCEPTION

Line 3499: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3495: p_data => p_msg_data);
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) || ' ' ||

Line 3507: FND_MSG_PUB.Add;

3503: to_char(p_region_appl_id) || ' ' ||
3504: p_region_code || ' ' ||
3505: to_char(p_attr_appl_id) || ' ' ||
3506: p_attr_code || ' ' || p_property_name);
3507: FND_MSG_PUB.Add;
3508: end if;
3509: p_return_status := FND_API.G_RET_STS_ERROR;
3510: rollback to start_create_cust_reg_item;
3511: FND_MSG_PUB.Count_And_Get (

Line 3511: FND_MSG_PUB.Count_And_Get (

3507: FND_MSG_PUB.Add;
3508: end if;
3509: p_return_status := FND_API.G_RET_STS_ERROR;
3510: rollback to start_create_cust_reg_item;
3511: FND_MSG_PUB.Count_And_Get (
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

Line 3515: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3511: FND_MSG_PUB.Count_And_Get (
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) || ' ' ||

Line 3523: FND_MSG_PUB.Add;

3519: to_char(p_region_appl_id) || ' ' ||
3520: p_region_code || ' ' ||
3521: to_char(p_attr_appl_id) || ' ' ||
3522: p_attr_code || ' ' || p_property_name);
3523: FND_MSG_PUB.Add;
3524: end if;
3525: p_return_status := FND_API.G_RET_STS_ERROR;
3526: rollback to start_create_cust_reg_item;
3527: FND_MSG_PUB.Count_And_Get (

Line 3527: FND_MSG_PUB.Count_And_Get (

3523: FND_MSG_PUB.Add;
3524: end if;
3525: p_return_status := FND_API.G_RET_STS_ERROR;
3526: rollback to start_create_cust_reg_item;
3527: FND_MSG_PUB.Count_And_Get (
3528: p_count => p_msg_count,
3529: p_data => p_msg_data);
3530: WHEN OTHERS THEN
3531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3533: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3529: p_data => p_msg_data);
3530: WHEN OTHERS THEN
3531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3532: rollback to start_create_cust_reg_item;
3533: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3534: SUBSTR (SQLERRM, 1, 240) );
3535: FND_MSG_PUB.Add;
3536: FND_MSG_PUB.Count_And_Get (
3537: p_count => p_msg_count,

Line 3535: FND_MSG_PUB.Add;

3531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3532: rollback to start_create_cust_reg_item;
3533: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3534: SUBSTR (SQLERRM, 1, 240) );
3535: FND_MSG_PUB.Add;
3536: FND_MSG_PUB.Count_And_Get (
3537: p_count => p_msg_count,
3538: p_data => p_msg_data);
3539: end CREATE_CUST_REG_ITEM;

Line 3536: FND_MSG_PUB.Count_And_Get (

3532: rollback to start_create_cust_reg_item;
3533: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3534: SUBSTR (SQLERRM, 1, 240) );
3535: FND_MSG_PUB.Add;
3536: FND_MSG_PUB.Count_And_Get (
3537: p_count => p_msg_count,
3538: p_data => p_msg_data);
3539: end CREATE_CUST_REG_ITEM;
3540:

Line 3620: FND_MSG_PUB.initialize;

3616:
3617: -- Initialize the message table if requested.
3618:
3619: if p_init_msg_tbl then
3620: FND_MSG_PUB.initialize;
3621: end if;
3622:
3623: savepoint start_create_criteria;
3624:

Line 3636: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

3632: p_region_code => p_region_code,
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');

Line 3638: FND_MSG_PUB.Add;

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;
3642: end if;

Line 3776: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3772:
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 || ' ' ||

Line 3785: FND_MSG_PUB.Add;

3781: to_char(p_region_appl_id) || ' ' ||
3782: p_region_code || ' ' ||
3783: to_char(p_attr_appl_id) || ' ' ||
3784: p_attr_code || ' ' || p_sequence_number);
3785: FND_MSG_PUB.Add;
3786: end if;
3787:
3788: p_return_status := FND_API.G_RET_STS_SUCCESS;
3789:

Line 3790: FND_MSG_PUB.Count_And_Get (

3786: end if;
3787:
3788: p_return_status := FND_API.G_RET_STS_SUCCESS;
3789:
3790: FND_MSG_PUB.Count_And_Get (
3791: p_count => p_msg_count,
3792: p_data => p_msg_data);
3793:
3794: EXCEPTION

Line 3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3792: p_data => p_msg_data);
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) || ' ' ||

Line 3804: FND_MSG_PUB.Add;

3800: to_char(p_region_appl_id) || ' ' ||
3801: p_region_code || ' ' ||
3802: to_char(p_attr_appl_id) || ' ' ||
3803: p_attr_code || ' ' || p_sequence_number);
3804: FND_MSG_PUB.Add;
3805: end if;
3806: p_return_status := FND_API.G_RET_STS_ERROR;
3807: rollback to start_create_criteria;
3808: FND_MSG_PUB.Count_And_Get (

Line 3808: FND_MSG_PUB.Count_And_Get (

3804: FND_MSG_PUB.Add;
3805: end if;
3806: p_return_status := FND_API.G_RET_STS_ERROR;
3807: rollback to start_create_criteria;
3808: FND_MSG_PUB.Count_And_Get (
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

Line 3812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3808: FND_MSG_PUB.Count_And_Get (
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) || ' ' ||

Line 3820: FND_MSG_PUB.Add;

3816: to_char(p_region_appl_id) || ' ' ||
3817: p_region_code || ' ' ||
3818: to_char(p_attr_appl_id) || ' ' ||
3819: p_attr_code || ' ' || p_sequence_number);
3820: FND_MSG_PUB.Add;
3821: end if;
3822: p_return_status := FND_API.G_RET_STS_ERROR;
3823: rollback to start_create_criteria;
3824: FND_MSG_PUB.Count_And_Get (

Line 3824: FND_MSG_PUB.Count_And_Get (

3820: FND_MSG_PUB.Add;
3821: end if;
3822: p_return_status := FND_API.G_RET_STS_ERROR;
3823: rollback to start_create_criteria;
3824: FND_MSG_PUB.Count_And_Get (
3825: p_count => p_msg_count,
3826: p_data => p_msg_data);
3827: WHEN OTHERS THEN
3828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3830: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3826: p_data => p_msg_data);
3827: WHEN OTHERS THEN
3828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3829: rollback to start_create_criteria;
3830: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3831: SUBSTR (SQLERRM, 1, 240) );
3832: FND_MSG_PUB.Add;
3833: FND_MSG_PUB.Count_And_Get (
3834: p_count => p_msg_count,

Line 3832: FND_MSG_PUB.Add;

3828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3829: rollback to start_create_criteria;
3830: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3831: SUBSTR (SQLERRM, 1, 240) );
3832: FND_MSG_PUB.Add;
3833: FND_MSG_PUB.Count_And_Get (
3834: p_count => p_msg_count,
3835: p_data => p_msg_data);
3836: end CREATE_CRITERIA;

Line 3833: FND_MSG_PUB.Count_And_Get (

3829: rollback to start_create_criteria;
3830: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3831: SUBSTR (SQLERRM, 1, 240) );
3832: FND_MSG_PUB.Add;
3833: FND_MSG_PUB.Count_And_Get (
3834: p_count => p_msg_count,
3835: p_data => p_msg_data);
3836: end CREATE_CRITERIA;
3837:

Line 3905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3901: p_return_status := FND_API.G_RET_STS_ERROR;
3902: return FALSE;
3903: WHEN OTHERS THEN
3904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3906: SUBSTR (SQLERRM, 1, 240) );
3907: FND_MSG_PUB.Add;
3908: return FALSE;
3909:

Line 3907: FND_MSG_PUB.Add;

3903: WHEN OTHERS THEN
3904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3905: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3906: SUBSTR (SQLERRM, 1, 240) );
3907: FND_MSG_PUB.Add;
3908: return FALSE;
3909:
3910: end CUSTOM_EXISTS;
3911:

Line 3981: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3977: p_return_status := FND_API.G_RET_STS_ERROR;
3978: return FALSE;
3979: WHEN OTHERS THEN
3980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3981: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3982: SUBSTR (SQLERRM, 1, 240) );
3983: FND_MSG_PUB.Add;
3984: return FALSE;
3985:

Line 3983: FND_MSG_PUB.Add;

3979: WHEN OTHERS THEN
3980: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3981: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3982: SUBSTR (SQLERRM, 1, 240) );
3983: FND_MSG_PUB.Add;
3984: return FALSE;
3985:
3986: end CUST_REGION_EXISTS;
3987:

Line 4061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4057: p_return_status := FND_API.G_RET_STS_ERROR;
4058: return FALSE;
4059: WHEN OTHERS THEN
4060: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4062: SUBSTR (SQLERRM, 1, 240) );
4063: FND_MSG_PUB.Add;
4064: return FALSE;
4065:

Line 4063: FND_MSG_PUB.Add;

4059: WHEN OTHERS THEN
4060: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4061: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4062: SUBSTR (SQLERRM, 1, 240) );
4063: FND_MSG_PUB.Add;
4064: return FALSE;
4065:
4066: end CUST_REG_ITEM_EXISTS;
4067:

Line 4141: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4137: p_return_status := FND_API.G_RET_STS_ERROR;
4138: return FALSE;
4139: WHEN OTHERS THEN
4140: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4141: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4142: SUBSTR (SQLERRM, 1, 240) );
4143: FND_MSG_PUB.Add;
4144: return FALSE;
4145:

Line 4143: FND_MSG_PUB.Add;

4139: WHEN OTHERS THEN
4140: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4141: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4142: SUBSTR (SQLERRM, 1, 240) );
4143: FND_MSG_PUB.Add;
4144: return FALSE;
4145:
4146: end CRITERIA_EXISTS;
4147:

Line 4248: FND_MSG_PUB.initialize;

4244:
4245: -- Initialize the message table if requested.
4246:
4247: if p_init_msg_tbl then
4248: FND_MSG_PUB.initialize;
4249: end if;
4250:
4251: savepoint start_update_custom;
4252:

Line 4260: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4256: --** retrieve ak_customizations row if it exists **
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');

Line 4262: FND_MSG_PUB.Add;

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;
4266: raise FND_API.G_EXC_ERROR;

Line 4274: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4270: --** retrieve ak_customizations_tl row if it exists **
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');

Line 4276: FND_MSG_PUB.Add;

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;
4280: raise FND_API.G_EXC_ERROR;

Line 4459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4455: and REGION_CODE = p_region_code
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');

Line 4461: FND_MSG_PUB.Add;

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;
4465: end if;

Line 4492: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4488: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
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');

Line 4494: FND_MSG_PUB.Add;

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;
4498: end if;

Line 4503: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4499:
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) ||

Line 4509: FND_MSG_PUB.Add;

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;
4510: end if;
4511:
4512: p_return_status := FND_API.G_RET_STS_SUCCESS;
4513:

Line 4514: FND_MSG_PUB.Count_And_Get (

4510: end if;
4511:
4512: p_return_status := FND_API.G_RET_STS_SUCCESS;
4513:
4514: FND_MSG_PUB.Count_And_Get (
4515: p_count => p_msg_count,
4516: p_data => p_msg_data);
4517:
4518: EXCEPTION

Line 4520: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4516: p_data => p_msg_data);
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) ||

Line 4526: FND_MSG_PUB.Add;

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;
4527: end if;
4528: rollback to start_update_custom;
4529: p_return_status := FND_API.G_RET_STS_ERROR;
4530: FND_MSG_PUB.Count_And_Get (

Line 4530: FND_MSG_PUB.Count_And_Get (

4526: FND_MSG_PUB.Add;
4527: end if;
4528: rollback to start_update_custom;
4529: p_return_status := FND_API.G_RET_STS_ERROR;
4530: FND_MSG_PUB.Count_And_Get (
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

Line 4534: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4530: FND_MSG_PUB.Count_And_Get (
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) ||

Line 4540: FND_MSG_PUB.Add;

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;
4541: end if;
4542: p_return_status := FND_API.G_RET_STS_ERROR;
4543: rollback to start_update_custom;
4544: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 4544: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4540: FND_MSG_PUB.Add;
4541: end if;
4542: p_return_status := FND_API.G_RET_STS_ERROR;
4543: rollback to start_update_custom;
4544: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4545: SUBSTR (SQLERRM, 1, 240) );
4546: FND_MSG_PUB.Add;
4547: FND_MSG_PUB.Count_And_Get (
4548: p_count => p_msg_count,

Line 4546: FND_MSG_PUB.Add;

4542: p_return_status := FND_API.G_RET_STS_ERROR;
4543: rollback to start_update_custom;
4544: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4545: SUBSTR (SQLERRM, 1, 240) );
4546: FND_MSG_PUB.Add;
4547: FND_MSG_PUB.Count_And_Get (
4548: p_count => p_msg_count,
4549: p_data => p_msg_data);
4550: end UPDATE_CUSTOM;

Line 4547: FND_MSG_PUB.Count_And_Get (

4543: rollback to start_update_custom;
4544: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4545: SUBSTR (SQLERRM, 1, 240) );
4546: FND_MSG_PUB.Add;
4547: FND_MSG_PUB.Count_And_Get (
4548: p_count => p_msg_count,
4549: p_data => p_msg_data);
4550: end UPDATE_CUSTOM;
4551:

Line 4644: FND_MSG_PUB.initialize;

4640:
4641: -- Initialize the message table if requested.
4642:
4643: if p_init_msg_tbl then
4644: FND_MSG_PUB.initialize;
4645: end if;
4646:
4647: savepoint start_update_cust_region;
4648:

Line 4656: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4652: --** retrieve ak_custom_regions row if it exists **
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');

Line 4658: FND_MSG_PUB.Add;

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;
4662: raise FND_API.G_EXC_ERROR;

Line 4670: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4666: --** retrieve ak_custom_regions_tl row if it exists **
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');

Line 4672: FND_MSG_PUB.Add;

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;
4676: raise FND_API.G_EXC_ERROR;

Line 4783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4779: and CUSTOMIZATION_APPLICATION_ID = p_custom_appl_id
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');

Line 4785: FND_MSG_PUB.Add;

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;
4789: end if;

Line 4804: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4800: and CUSTOMIZATION_CODE = p_custom_code
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');

Line 4806: FND_MSG_PUB.Add;

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;
4810: end if;

Line 4815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

4811:
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) ||

Line 4822: FND_MSG_PUB.Add;

4818: ' ' || p_region_code ||
4819: ' ' || to_char(p_custom_appl_id) ||
4820: ' ' || p_custom_code || ' ' ||
4821: p_property_name);
4822: FND_MSG_PUB.Add;
4823: end if;
4824:
4825: p_return_status := FND_API.G_RET_STS_SUCCESS;
4826:

Line 4827: FND_MSG_PUB.Count_And_Get (

4823: end if;
4824:
4825: p_return_status := FND_API.G_RET_STS_SUCCESS;
4826:
4827: FND_MSG_PUB.Count_And_Get (
4828: p_count => p_msg_count,
4829: p_data => p_msg_data);
4830:
4831: EXCEPTION

Line 4833: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4829: p_data => p_msg_data);
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) ||

Line 4840: FND_MSG_PUB.Add;

4836: ' ' || p_region_code ||
4837: ' ' || to_char(p_custom_appl_id) ||
4838: ' ' || p_custom_code || ' ' ||
4839: p_property_name);
4840: FND_MSG_PUB.Add;
4841: end if;
4842: rollback to start_update_cust_region;
4843: p_return_status := FND_API.G_RET_STS_ERROR;
4844: FND_MSG_PUB.Count_And_Get (

Line 4844: FND_MSG_PUB.Count_And_Get (

4840: FND_MSG_PUB.Add;
4841: end if;
4842: rollback to start_update_cust_region;
4843: p_return_status := FND_API.G_RET_STS_ERROR;
4844: FND_MSG_PUB.Count_And_Get (
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

Line 4848: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4844: FND_MSG_PUB.Count_And_Get (
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) ||

Line 4855: FND_MSG_PUB.Add;

4851: ' ' || p_region_code ||
4852: ' ' || to_char(p_custom_appl_id) ||
4853: ' ' || p_custom_code || ' ' ||
4854: p_property_name);
4855: FND_MSG_PUB.Add;
4856: end if;
4857: p_return_status := FND_API.G_RET_STS_ERROR;
4858: rollback to start_update_cust_region;
4859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 4859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4855: FND_MSG_PUB.Add;
4856: end if;
4857: p_return_status := FND_API.G_RET_STS_ERROR;
4858: rollback to start_update_cust_region;
4859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4860: SUBSTR (SQLERRM, 1, 240) );
4861: FND_MSG_PUB.Add;
4862: FND_MSG_PUB.Count_And_Get (
4863: p_count => p_msg_count,

Line 4861: FND_MSG_PUB.Add;

4857: p_return_status := FND_API.G_RET_STS_ERROR;
4858: rollback to start_update_cust_region;
4859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4860: SUBSTR (SQLERRM, 1, 240) );
4861: FND_MSG_PUB.Add;
4862: FND_MSG_PUB.Count_And_Get (
4863: p_count => p_msg_count,
4864: p_data => p_msg_data);
4865: end UPDATE_CUST_REGION;

Line 4862: FND_MSG_PUB.Count_And_Get (

4858: rollback to start_update_cust_region;
4859: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4860: SUBSTR (SQLERRM, 1, 240) );
4861: FND_MSG_PUB.Add;
4862: FND_MSG_PUB.Count_And_Get (
4863: p_count => p_msg_count,
4864: p_data => p_msg_data);
4865: end UPDATE_CUST_REGION;
4866:

Line 4965: FND_MSG_PUB.initialize;

4961:
4962: -- Initialize the message table if requested.
4963:
4964: if p_init_msg_tbl then
4965: FND_MSG_PUB.initialize;
4966: end if;
4967:
4968: savepoint start_update_cust_reg_item;
4969:

Line 4977: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4973: --** retrieve ak_custom_region_items row if it exists **
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');

Line 4979: FND_MSG_PUB.Add;

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;
4983: raise FND_API.G_EXC_ERROR;

Line 4991: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

4987: --** retrieve ak_custom_region_items_tl row if it exists **
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');

Line 4993: FND_MSG_PUB.Add;

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;
4997: raise FND_API.G_EXC_ERROR;

Line 5108: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5104: and ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
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');

Line 5110: FND_MSG_PUB.Add;

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;
5114: end if;

Line 5131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5127: and ATTRIBUTE_CODE = p_attribute_code
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');

Line 5133: FND_MSG_PUB.Add;

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;
5137: end if;

Line 5142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

5138:
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) ||

Line 5149: FND_MSG_PUB.Add;

5145: ' ' || p_region_code ||
5146: ' ' || to_char(p_custom_appl_id) ||
5147: ' ' || p_custom_code || ' ' ||
5148: p_property_name);
5149: FND_MSG_PUB.Add;
5150: end if;
5151:
5152: p_return_status := FND_API.G_RET_STS_SUCCESS;
5153:

Line 5154: FND_MSG_PUB.Count_And_Get (

5150: end if;
5151:
5152: p_return_status := FND_API.G_RET_STS_SUCCESS;
5153:
5154: FND_MSG_PUB.Count_And_Get (
5155: p_count => p_msg_count,
5156: p_data => p_msg_data);
5157:
5158: EXCEPTION

Line 5160: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5156: p_data => p_msg_data);
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) ||

Line 5167: FND_MSG_PUB.Add;

5163: ' ' || p_region_code ||
5164: ' ' || to_char(p_custom_appl_id) ||
5165: ' ' || p_custom_code || ' ' ||
5166: p_property_name);
5167: FND_MSG_PUB.Add;
5168: end if;
5169: rollback to start_update_cust_reg_item;
5170: p_return_status := FND_API.G_RET_STS_ERROR;
5171: FND_MSG_PUB.Count_And_Get (

Line 5171: FND_MSG_PUB.Count_And_Get (

5167: FND_MSG_PUB.Add;
5168: end if;
5169: rollback to start_update_cust_reg_item;
5170: p_return_status := FND_API.G_RET_STS_ERROR;
5171: FND_MSG_PUB.Count_And_Get (
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

Line 5175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5171: FND_MSG_PUB.Count_And_Get (
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) ||

Line 5182: FND_MSG_PUB.Add;

5178: ' ' || p_region_code ||
5179: ' ' || to_char(p_custom_appl_id) ||
5180: ' ' || p_custom_code || ' ' ||
5181: p_property_name);
5182: FND_MSG_PUB.Add;
5183: end if;
5184: p_return_status := FND_API.G_RET_STS_ERROR;
5185: rollback to start_update_cust_reg_item;
5186: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 5186: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5182: FND_MSG_PUB.Add;
5183: end if;
5184: p_return_status := FND_API.G_RET_STS_ERROR;
5185: rollback to start_update_cust_reg_item;
5186: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5187: SUBSTR (SQLERRM, 1, 240) );
5188: FND_MSG_PUB.Add;
5189: FND_MSG_PUB.Count_And_Get (
5190: p_count => p_msg_count,

Line 5188: FND_MSG_PUB.Add;

5184: p_return_status := FND_API.G_RET_STS_ERROR;
5185: rollback to start_update_cust_reg_item;
5186: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5187: SUBSTR (SQLERRM, 1, 240) );
5188: FND_MSG_PUB.Add;
5189: FND_MSG_PUB.Count_And_Get (
5190: p_count => p_msg_count,
5191: p_data => p_msg_data);
5192: end UPDATE_CUST_REG_ITEM;

Line 5189: FND_MSG_PUB.Count_And_Get (

5185: rollback to start_update_cust_reg_item;
5186: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5187: SUBSTR (SQLERRM, 1, 240) );
5188: FND_MSG_PUB.Add;
5189: FND_MSG_PUB.Count_And_Get (
5190: p_count => p_msg_count,
5191: p_data => p_msg_data);
5192: end UPDATE_CUST_REG_ITEM;
5193:

Line 5280: FND_MSG_PUB.initialize;

5276:
5277: -- Initialize the message table if requested.
5278:
5279: if p_init_msg_tbl then
5280: FND_MSG_PUB.initialize;
5281: end if;
5282:
5283: savepoint start_update_criteria;
5284:

Line 5289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

5285: --** retrieve ak_criteria row if it exists **
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');

Line 5291: FND_MSG_PUB.Add;

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;
5295: raise FND_API.G_EXC_ERROR;

Line 5419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5415: and ATTRIBUTE_APPLICATION_ID = p_attribute_appl_id
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');

Line 5421: FND_MSG_PUB.Add;

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;
5425: end if;

Line 5430: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

5426:
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) ||

Line 5437: FND_MSG_PUB.Add;

5433: ' ' || p_region_code ||
5434: ' ' || to_char(p_custom_appl_id) ||
5435: ' ' || p_custom_code || ' ' ||
5436: to_char(p_sequence_number));
5437: FND_MSG_PUB.Add;
5438: end if;
5439:
5440: p_return_status := FND_API.G_RET_STS_SUCCESS;
5441:

Line 5442: FND_MSG_PUB.Count_And_Get (

5438: end if;
5439:
5440: p_return_status := FND_API.G_RET_STS_SUCCESS;
5441:
5442: FND_MSG_PUB.Count_And_Get (
5443: p_count => p_msg_count,
5444: p_data => p_msg_data);
5445:
5446: EXCEPTION

Line 5448: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5444: p_data => p_msg_data);
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) ||

Line 5455: FND_MSG_PUB.Add;

5451: ' ' || p_region_code ||
5452: ' ' || to_char(p_custom_appl_id) ||
5453: ' ' || p_custom_code || ' ' ||
5454: to_char(p_sequence_number));
5455: FND_MSG_PUB.Add;
5456: end if;
5457: rollback to start_update_criteria;
5458: p_return_status := FND_API.G_RET_STS_ERROR;
5459: FND_MSG_PUB.Count_And_Get (

Line 5459: FND_MSG_PUB.Count_And_Get (

5455: FND_MSG_PUB.Add;
5456: end if;
5457: rollback to start_update_criteria;
5458: p_return_status := FND_API.G_RET_STS_ERROR;
5459: FND_MSG_PUB.Count_And_Get (
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

Line 5463: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5459: FND_MSG_PUB.Count_And_Get (
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) ||

Line 5470: FND_MSG_PUB.Add;

5466: ' ' || p_region_code ||
5467: ' ' || to_char(p_custom_appl_id) ||
5468: ' ' || p_custom_code || ' ' ||
5469: to_char(p_sequence_number));
5470: FND_MSG_PUB.Add;
5471: end if;
5472: p_return_status := FND_API.G_RET_STS_ERROR;
5473: rollback to start_update_criteria;
5474: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 5474: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5470: FND_MSG_PUB.Add;
5471: end if;
5472: p_return_status := FND_API.G_RET_STS_ERROR;
5473: rollback to start_update_criteria;
5474: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5475: SUBSTR (SQLERRM, 1, 240) );
5476: FND_MSG_PUB.Add;
5477: FND_MSG_PUB.Count_And_Get (
5478: p_count => p_msg_count,

Line 5476: FND_MSG_PUB.Add;

5472: p_return_status := FND_API.G_RET_STS_ERROR;
5473: rollback to start_update_criteria;
5474: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5475: SUBSTR (SQLERRM, 1, 240) );
5476: FND_MSG_PUB.Add;
5477: FND_MSG_PUB.Count_And_Get (
5478: p_count => p_msg_count,
5479: p_data => p_msg_data);
5480: end UPDATE_CRITERIA;

Line 5477: FND_MSG_PUB.Count_And_Get (

5473: rollback to start_update_criteria;
5474: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5475: SUBSTR (SQLERRM, 1, 240) );
5476: FND_MSG_PUB.Add;
5477: FND_MSG_PUB.Count_And_Get (
5478: p_count => p_msg_count,
5479: p_data => p_msg_data);
5480: end UPDATE_CRITERIA;
5481: