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.HZ_FORMAT_PUB dependencies on FND_MESSAGE

Line 313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');

309: OPEN c_location_territory(p_location_id);
310: FETCH c_location_territory INTO l_to_territory_code;
311: IF c_location_territory%NOTFOUND THEN
312: CLOSE c_location_territory;
313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
317: fnd_msg_pub.add;

Line 314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);

310: FETCH c_location_territory INTO l_to_territory_code;
311: IF c_location_territory%NOTFOUND THEN
312: CLOSE c_location_territory;
313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
317: fnd_msg_pub.add;
318: RAISE fnd_api.g_exc_error;

Line 315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);

311: IF c_location_territory%NOTFOUND THEN
312: CLOSE c_location_territory;
313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
317: fnd_msg_pub.add;
318: RAISE fnd_api.g_exc_error;
319: ELSE

Line 316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));

312: CLOSE c_location_territory;
313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
317: fnd_msg_pub.add;
318: RAISE fnd_api.g_exc_error;
319: ELSE
320: CLOSE c_location_territory;

Line 406: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

402: END IF;
403: END IF;
404:
405: IF l_style_format_code IS NULL THEN
406: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
407: fnd_msg_pub.add;
408: RAISE fnd_api.g_exc_error;
409: END IF;
410:

Line 452: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

448: x_loaded_rows_cnt => g_layout_tbl_cnt
449: );
450:
451: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
452: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
453: fnd_msg_pub.add;
454: RAISE fnd_api.g_exc_error;
455: END IF;
456:

Line 699: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

695: END IF;
696: END IF;
697:
698: IF l_style_format_code IS NULL THEN
699: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
700: fnd_msg_pub.add;
701: RAISE fnd_api.g_exc_error;
702: END IF;
703:

Line 764: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

760: x_loaded_rows_cnt => g_layout_tbl_cnt
761: );
762:
763: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
764: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
765: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
766: fnd_msg_pub.add;
767: RAISE fnd_api.g_exc_error;
768: END IF;

Line 765: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

761: );
762:
763: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
764: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
765: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
766: fnd_msg_pub.add;
767: RAISE fnd_api.g_exc_error;
768: END IF;
769:

Line 985: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

981: END IF;
982: END IF;
983:
984: IF l_style_format_code IS NULL THEN
985: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
986: fnd_msg_pub.add;
987: RAISE fnd_api.g_exc_error;
988: END IF;
989:

Line 1050: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

1046: x_loaded_rows_cnt => g_layout_tbl_cnt
1047: );
1048:
1049: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1050: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1051: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1052: fnd_msg_pub.add;
1053: RAISE fnd_api.g_exc_error;
1054: END IF;

Line 1051: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

1047: );
1048:
1049: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1050: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1051: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1052: fnd_msg_pub.add;
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1055:

Line 1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');

1186: OPEN c_location_territory(p_location_id);
1187: FETCH c_location_territory INTO l_to_territory_code;
1188: IF c_location_territory%NOTFOUND THEN
1189: CLOSE c_location_territory;
1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
1194: fnd_msg_pub.add;

Line 1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);

1187: FETCH c_location_territory INTO l_to_territory_code;
1188: IF c_location_territory%NOTFOUND THEN
1189: CLOSE c_location_territory;
1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;

Line 1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);

1188: IF c_location_territory%NOTFOUND THEN
1189: CLOSE c_location_territory;
1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;
1196: ELSE

Line 1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));

1189: CLOSE c_location_territory;
1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;
1196: ELSE
1197: CLOSE c_location_territory;

Line 1283: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

1279: END IF;
1280: END IF;
1281:
1282: IF l_style_format_code IS NULL THEN
1283: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1284: fnd_msg_pub.add;
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287:

Line 1329: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

1325: x_loaded_rows_cnt => g_layout_tbl_cnt
1326: );
1327:
1328: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1329: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1330: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1331: fnd_msg_pub.add;
1332: RAISE fnd_api.g_exc_error;
1333: END IF;

Line 1330: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

1326: );
1327:
1328: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1329: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1330: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1331: fnd_msg_pub.add;
1332: RAISE fnd_api.g_exc_error;
1333: END IF;
1334:

Line 1558: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

1554: END IF;
1555: END IF;
1556:
1557: IF l_style_format_code IS NULL THEN
1558: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1559: fnd_msg_pub.add;
1560: RAISE fnd_api.g_exc_error;
1561: END IF;
1562:

Line 1664: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

1660: x_loaded_rows_cnt => g_layout_tbl_cnt
1661: );
1662:
1663: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1664: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1665: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1666: fnd_msg_pub.add;
1667: RAISE fnd_api.g_exc_error;
1668: END IF;

Line 1665: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

1661: );
1662:
1663: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1664: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1665: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1666: fnd_msg_pub.add;
1667: RAISE fnd_api.g_exc_error;
1668: END IF;
1669:

Line 1834: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

1830: END IF;
1831:
1832:
1833: IF l_style_format_code IS NULL THEN
1834: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1835: fnd_msg_pub.add;
1836: RAISE fnd_api.g_exc_error;
1837: END IF;
1838:

Line 1880: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

1876: x_loaded_rows_cnt => g_layout_tbl_cnt
1877: );
1878:
1879: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1880: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1881: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1882: fnd_msg_pub.add;
1883: RAISE fnd_api.g_exc_error;
1884: END IF;

Line 1881: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

1877: );
1878:
1879: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1880: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1881: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1882: fnd_msg_pub.add;
1883: RAISE fnd_api.g_exc_error;
1884: END IF;
1885:

Line 2093: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

2089: END IF;
2090:
2091:
2092: IF l_style_format_code IS NULL THEN
2093: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2094: fnd_msg_pub.add;
2095: RAISE fnd_api.g_exc_error;
2096: END IF;
2097:

Line 2163: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

2159: x_loaded_rows_cnt => g_layout_tbl_cnt
2160: );
2161:
2162: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
2163: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
2164: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
2165: fnd_msg_pub.add;
2166: RAISE fnd_api.g_exc_error;
2167: END IF;

Line 2164: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);

2160: );
2161:
2162: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
2163: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
2164: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
2165: fnd_msg_pub.add;
2166: RAISE fnd_api.g_exc_error;
2167: END IF;
2168:

Line 2324: fnd_message.set_name('AR','HZ_INVALID_ENTITY_NAME');

2320:
2321: SELECT COUNT(TABLE_ID) INTO l_tab_count
2322: FROM FND_TABLES WHERE TABLE_NAME = p_object_code;
2323: IF l_tab_count = 0 THEN
2324: fnd_message.set_name('AR','HZ_INVALID_ENTITY_NAME');
2325: fnd_msg_pub.add;
2326: RAISE fnd_api.g_exc_error;
2327: END IF;
2328:

Line 2397: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

2393: END IF;
2394:
2395:
2396: IF l_style_format_code IS NULL THEN
2397: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2398: fnd_msg_pub.add;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401:

Line 2471: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');

2467: x_loaded_rows_cnt => g_layout_tbl_cnt
2468: );
2469:
2470: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
2471: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
2472: fnd_msg_pub.add;
2473: RAISE fnd_api.g_exc_error;
2474: END IF;
2475:

Line 2620: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

2616:
2617: EXCEPTION
2618: -----Bug No.4145590
2619: WHEN OTHERS THEN
2620: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2621: fnd_message.set_token('ERROR',SQLERRM);
2622: fnd_msg_pub.add;
2623: return NULL;
2624:

Line 2621: fnd_message.set_token('ERROR',SQLERRM);

2617: EXCEPTION
2618: -----Bug No.4145590
2619: WHEN OTHERS THEN
2620: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2621: fnd_message.set_token('ERROR',SQLERRM);
2622: fnd_msg_pub.add;
2623: return NULL;
2624:
2625: END format_address;

Line 2707: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

2703:
2704: EXCEPTION
2705: -----Bug No.4145590
2706: WHEN OTHERS THEN
2707: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2708: fnd_message.set_token('ERROR',SQLERRM);
2709: fnd_msg_pub.add;
2710: return NULL;
2711:

Line 2708: fnd_message.set_token('ERROR',SQLERRM);

2704: EXCEPTION
2705: -----Bug No.4145590
2706: WHEN OTHERS THEN
2707: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2708: fnd_message.set_token('ERROR',SQLERRM);
2709: fnd_msg_pub.add;
2710: return NULL;
2711:
2712: END format_address_lov;

Line 2778: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

2774:
2775: EXCEPTION
2776: -----Bug No.4145590
2777: WHEN OTHERS THEN
2778: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2779: fnd_message.set_token('ERROR',SQLERRM);
2780: fnd_msg_pub.add;
2781: return NULL;
2782:

Line 2779: fnd_message.set_token('ERROR',SQLERRM);

2775: EXCEPTION
2776: -----Bug No.4145590
2777: WHEN OTHERS THEN
2778: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2779: fnd_message.set_token('ERROR',SQLERRM);
2780: fnd_msg_pub.add;
2781: return NULL;
2782:
2783: END format_name;

Line 2980: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');

2976: FETCH c_def_style_format INTO l_style_format_code;
2977: IF c_def_style_format%NOTFOUND THEN
2978: -- Error condition... could not determine Style Format whatsoever.
2979: x_return_status := fnd_api.g_ret_sts_error;
2980: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2981: fnd_msg_pub.add;
2982: END IF;
2983: CLOSE c_def_style_format;
2984: