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_PARTY_STAGE dependencies on FND_MESSAGE

Line 1446: log(fnd_message.get);

1442: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1443: 'STAGE_NEW_DENORM', l_idx_mem, l_num_prll, 'STAGE_NEW_DENORM');
1444: IF l_req_id = 0 THEN
1445: log('Error submitting request');
1446: log(fnd_message.get);
1447: ELSE
1448: log('Submitted request ID for Party Index: ' || l_req_id );
1449: log('Request ID : ' || l_req_id);
1450: END IF;

Line 1683: log(fnd_message.get);

1679: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1680: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1681: IF l_sub_requests(i) = 0 THEN
1682: log('Error submitting worker ' || i);
1683: log(fnd_message.get);
1684: ELSE
1685: log('Submitted request for Worker ' || TO_CHAR(I) );
1686: log('Request ID : ' || l_sub_requests(i));
1687: END IF;

Line 1710: log(fnd_message.get);

1706: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1707: l_command, l_idx_mem, l_num_prll, l_index);
1708: IF l_req_id = 0 THEN
1709: log('Error submitting request');
1710: log(fnd_message.get);
1711: ELSE
1712: log('Submitted request ID for Party Index: ' || l_req_id );
1713: log('Request ID : ' || l_req_id);
1714: END IF;

Line 1734: log(fnd_message.get);

1730: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1731: l_command, l_idx_mem, l_num_prll, l_index);
1732: IF l_req_id = 0 THEN
1733: log('Error submitting request');
1734: log(fnd_message.get);
1735: ELSE
1736: log('Submitted request ID for Party Site Index: ' || l_req_id );
1737: log('Request ID : ' || l_req_id);
1738: END IF;

Line 1757: log(fnd_message.get);

1753: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1754: l_command, l_idx_mem, l_num_prll, l_index);
1755: IF l_req_id = 0 THEN
1756: log('Error submitting request');
1757: log(fnd_message.get);
1758: ELSE
1759: log('Submitted request ID for Party Index: ' || l_req_id );
1760: log('Request ID : ' || l_req_id);
1761: END IF;

Line 1780: log(fnd_message.get);

1776: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1777: l_command, l_idx_mem, l_num_prll, l_index);
1778: IF l_req_id = 0 THEN
1779: log('Error submitting request');
1780: log(fnd_message.get);
1781: ELSE
1782: log('Submitted request ID for Contact Point Index: ' || l_req_id );
1783: log('Request ID : ' || l_req_id);
1784: END IF;

Line 1848: log(fnd_message.get);

1844: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1845: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1846: IF l_sub_requests(i) = 0 THEN
1847: log('Error submitting worker ' || i);
1848: log(fnd_message.get);
1849: ELSE
1850: log('Submitted request for Worker ' || TO_CHAR(I) );
1851: log('Request ID : ' || l_sub_requests(i));
1852: END IF;

Line 1947: log(fnd_message.get);

1943: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1944: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1945: IF l_sub_requests(i) = 0 THEN
1946: log('Error submitting worker ' || i);
1947: log(fnd_message.get);
1948: ELSE
1949: log('Submitted request for Worker ' || TO_CHAR(I) );
1950: log('Request ID : ' || l_sub_requests(i));
1951: END IF;

Line 1969: log(fnd_message.get);

1965: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1966: l_command, l_idx_mem, l_num_prll, l_index);
1967: IF l_req_id = 0 THEN
1968: log('Error submitting request');
1969: log(fnd_message.get);
1970: ELSE
1971: log('Submitted request ID for Party Index: ' || l_req_id );
1972: log('Request ID : ' || l_req_id);
1973: END IF;

Line 1988: log(fnd_message.get);

1984: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1985: l_command, l_idx_mem, l_num_prll, l_index);
1986: IF l_req_id = 0 THEN
1987: log('Error submitting request');
1988: log(fnd_message.get);
1989: ELSE
1990: log('Submitted request ID for Party Site Index: ' || l_req_id );
1991: log('Request ID : ' || l_req_id);
1992: END IF;

Line 2007: log(fnd_message.get);

2003: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2004: l_command, l_idx_mem, l_num_prll, l_index);
2005: IF l_req_id = 0 THEN
2006: log('Error submitting request');
2007: log(fnd_message.get);
2008: ELSE
2009: log('Submitted request ID for Party Index: ' || l_req_id );
2010: log('Request ID : ' || l_req_id);
2011: END IF;

Line 2026: log(fnd_message.get);

2022: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2023: l_command, l_idx_mem, l_num_prll, l_index);
2024: IF l_req_id = 0 THEN
2025: log('Error submitting request');
2026: log(fnd_message.get);
2027: ELSE
2028: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2029: log('Request ID : ' || l_req_id);
2030: END IF;

Line 2068: log(fnd_message.get);

2064: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2065: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2066: IF l_req_id = 0 THEN
2067: log('Error submitting request');
2068: log(fnd_message.get);
2069: ELSE
2070: log('Submitted request ID for Party Index: ' || l_req_id );
2071: log('Request ID : ' || l_req_id);
2072: END IF;

Line 2090: log(fnd_message.get);

2086: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2087: l_command, l_idx_mem, l_num_prll, 'HZ_PARTY_SITES');
2088: IF l_req_id = 0 THEN
2089: log('Error submitting request');
2090: log(fnd_message.get);
2091: ELSE
2092: log('Submitted request ID for Party Site Index: ' || l_req_id );
2093: log('Request ID : ' || l_req_id);
2094: END IF;

Line 2112: log(fnd_message.get);

2108: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2109: l_command, l_idx_mem, l_num_prll, 'HZ_ORG_CONTACTS');
2110: IF l_req_id = 0 THEN
2111: log('Error submitting request');
2112: log(fnd_message.get);
2113: ELSE
2114: log('Submitted request ID for Party Index: ' || l_req_id );
2115: log('Request ID : ' || l_req_id);
2116: END IF;

Line 2134: log(fnd_message.get);

2130: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2131: l_command, l_idx_mem, l_num_prll, 'HZ_CONTACT_POINTS');
2132: IF l_req_id = 0 THEN
2133: log('Error submitting request');
2134: log(fnd_message.get);
2135: ELSE
2136: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2137: log('Request ID : ' || l_req_id);
2138: END IF;

Line 2190: log(fnd_message.get);

2186: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2187: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2188: IF l_req_id = 0 THEN
2189: log('Error submitting request');
2190: log(fnd_message.get);
2191: ELSE
2192: log('Submitted request ID for Party Index: ' || l_req_id );
2193: log('Request ID : ' || l_req_id);
2194: END IF;

Line 2230: log(fnd_message.get);

2226: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2227: l_command, l_idx_mem, l_num_prll, 'HZ_PARTY_SITES');
2228: IF l_req_id = 0 THEN
2229: log('Error submitting request');
2230: log(fnd_message.get);
2231: ELSE
2232: log('Submitted request ID for Party Index: ' || l_req_id );
2233: log('Request ID : ' || l_req_id);
2234: END IF;

Line 2270: log(fnd_message.get);

2266: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2267: l_command, l_idx_mem, l_num_prll, 'HZ_ORG_CONTACTS');
2268: IF l_req_id = 0 THEN
2269: log('Error submitting request');
2270: log(fnd_message.get);
2271: ELSE
2272: log('Submitted request ID for Contact Index: ' || l_req_id );
2273: log('Request ID : ' || l_req_id);
2274: END IF;

Line 2310: log(fnd_message.get);

2306: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2307: l_command, l_idx_mem, l_num_prll, 'HZ_CONTACT_POINTS');
2308: IF l_req_id = 0 THEN
2309: log('Error submitting request');
2310: log(fnd_message.get);
2311: ELSE
2312: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2313: log('Request ID : ' || l_req_id);
2314: END IF;

Line 2333: log(fnd_message.get);

2329: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2330: l_command, l_idx_mem, l_num_prll, l_index);
2331: IF l_req_id = 0 THEN
2332: log('Error submitting request');
2333: log(fnd_message.get);
2334: ELSE
2335: log('Submitted request ID for Party Index: ' || l_req_id );
2336: log('Request ID : ' || l_req_id);
2337: END IF;

Line 2351: log(fnd_message.get);

2347: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2348: l_command, l_idx_mem, l_num_prll, l_index);
2349: IF l_req_id = 0 THEN
2350: log('Error submitting request');
2351: log(fnd_message.get);
2352: ELSE
2353: log('Submitted request ID for Party Site Index: ' || l_req_id );
2354: log('Request ID : ' || l_req_id);
2355: END IF;

Line 2369: log(fnd_message.get);

2365: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2366: l_command, l_idx_mem, l_num_prll, l_index);
2367: IF l_req_id = 0 THEN
2368: log('Error submitting request');
2369: log(fnd_message.get);
2370: ELSE
2371: log('Submitted request ID for Contact Index: ' || l_req_id );
2372: log('Request ID : ' || l_req_id);
2373: END IF;

Line 2387: log(fnd_message.get);

2383: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2384: l_command, l_idx_mem, l_num_prll, l_index);
2385: IF l_req_id = 0 THEN
2386: log('Error submitting request');
2387: log(fnd_message.get);
2388: ELSE
2389: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2390: log('Request ID : ' || l_req_id);
2391: END IF;

Line 2446: log(fnd_message.get);

2442: argument2 => NULL /* p_indexes_only */
2443: );
2444: IF l_req_id = 0 THEN
2445: log('Error submitting sync request');
2446: log(fnd_message.get);
2447: ELSE
2448: log('Submitted request ID for Sync : ' || l_req_id );
2449: log('Request ID : ' || l_req_id);
2450: END IF;

Line 2472: log(fnd_message.get);

2468: retcode := 2;
2469: errbuf := errbuf || logerror || SQLERRM;
2470: FND_FILE.close;
2471: WHEN OTHERS THEN
2472: log(fnd_message.get);
2473: outandlog('Error: Aborting staging');
2474: retcode := 2;
2475: errbuf := errbuf || logerror || SQLERRM;
2476: FND_FILE.close;

Line 2986: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);

2982: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2983:
2984: EXCEPTION
2985: WHEN FND_API.G_EXC_ERROR THEN
2986: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2987: retcode := 2;
2988: errbuf := errbuf || logerror;
2989: FND_FILE.close;
2990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2991: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);

2987: retcode := 2;
2988: errbuf := errbuf || logerror;
2989: FND_FILE.close;
2990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2991: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2992: retcode := 2;
2993: errbuf := errbuf || logerror;
2994: FND_FILE.close;
2995: WHEN OTHERS THEN

Line 3165: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3161: IF l_req1 <> 1 THEN
3162: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req1),
3163: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3164: IF dphase <> 'COMPLETE' THEN
3165: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3166: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3167: FND_MSG_PUB.ADD;
3168: RAISE FND_API.G_EXC_ERROR;
3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3166: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);

3162: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req1),
3163: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3164: IF dphase <> 'COMPLETE' THEN
3165: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3166: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3167: FND_MSG_PUB.ADD;
3168: RAISE FND_API.G_EXC_ERROR;
3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3166: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3167: FND_MSG_PUB.ADD;
3168: RAISE FND_API.G_EXC_ERROR;
3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3171: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;

Line 3171: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);

3167: FND_MSG_PUB.ADD;
3168: RAISE FND_API.G_EXC_ERROR;
3169: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3170: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3171: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;
3175: END IF;

Line 3180: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3176: IF l_req2 <> 1 THEN
3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),
3178: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3179: IF dphase <> 'COMPLETE' THEN
3180: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3181: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3181: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);

3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),
3178: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3179: IF dphase <> 'COMPLETE' THEN
3180: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3181: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3181: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3186: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;

Line 3186: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);

3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3186: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190: END IF;

Line 3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3191: IF l_req3 <> 1 THEN
3192: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),
3193: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3194: IF dphase <> 'COMPLETE' THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3196: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3196: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);

3192: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),
3193: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3194: IF dphase <> 'COMPLETE' THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3196: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3196: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3201: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: END IF;

Line 3201: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);

3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3201: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: END IF;
3205: END IF;

Line 3210: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3206: IF l_req4 <> 1 THEN
3207: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),
3208: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3209: IF dphase <> 'COMPLETE' THEN
3210: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3211: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3211: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);

3207: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),
3208: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3209: IF dphase <> 'COMPLETE' THEN
3210: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3211: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3211: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3216: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;

Line 3216: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);

3212: FND_MSG_PUB.ADD;
3213: RAISE FND_API.G_EXC_ERROR;
3214: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3215: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3216: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220: END IF;

Line 3225: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3221: IF l_req5 <> 1 THEN
3222: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),
3223: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3224: IF dphase <> 'COMPLETE' THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3226: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3226: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);

3222: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),
3223: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3224: IF dphase <> 'COMPLETE' THEN
3225: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3226: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3226: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3231: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3232: FND_MSG_PUB.ADD;
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;

Line 3231: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);

3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3230: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3231: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3232: FND_MSG_PUB.ADD;
3233: RAISE FND_API.G_EXC_ERROR;
3234: END IF;
3235: END IF;

Line 3240: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3236: IF l_req6 <> 1 THEN
3237: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),
3238: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3239: IF dphase <> 'COMPLETE' THEN
3240: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3241: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3241: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);

3237: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),
3238: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3239: IF dphase <> 'COMPLETE' THEN
3240: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3241: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3241: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3246: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;

Line 3246: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);

3242: FND_MSG_PUB.ADD;
3243: RAISE FND_API.G_EXC_ERROR;
3244: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3245: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3246: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3247: FND_MSG_PUB.ADD;
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250: END IF;

Line 3255: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3251: IF l_req7 <> 1 THEN
3252: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),
3253: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3254: IF dphase <> 'COMPLETE' THEN
3255: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3256: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);

3252: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),
3253: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3254: IF dphase <> 'COMPLETE' THEN
3255: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3256: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3261: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;

Line 3261: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);

3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3260: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3261: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.G_EXC_ERROR;
3264: END IF;
3265: END IF;

Line 3270: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3266: IF l_req8 <> 1 THEN
3267: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),
3268: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3269: IF dphase <> 'COMPLETE' THEN
3270: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3271: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3272: FND_MSG_PUB.ADD;
3273: RAISE FND_API.G_EXC_ERROR;
3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3271: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);

3267: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),
3268: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3269: IF dphase <> 'COMPLETE' THEN
3270: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3271: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3272: FND_MSG_PUB.ADD;
3273: RAISE FND_API.G_EXC_ERROR;
3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3271: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3272: FND_MSG_PUB.ADD;
3273: RAISE FND_API.G_EXC_ERROR;
3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3276: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;

Line 3276: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);

3272: FND_MSG_PUB.ADD;
3273: RAISE FND_API.G_EXC_ERROR;
3274: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3275: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3276: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3277: FND_MSG_PUB.ADD;
3278: RAISE FND_API.G_EXC_ERROR;
3279: END IF;
3280: END IF;

Line 3285: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3281: IF l_req9 <> 1 THEN
3282: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),
3283: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3284: IF dphase <> 'COMPLETE' THEN
3285: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3286: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3287: FND_MSG_PUB.ADD;
3288: RAISE FND_API.G_EXC_ERROR;
3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3286: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);

3282: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),
3283: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3284: IF dphase <> 'COMPLETE' THEN
3285: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3286: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3287: FND_MSG_PUB.ADD;
3288: RAISE FND_API.G_EXC_ERROR;
3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3286: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3287: FND_MSG_PUB.ADD;
3288: RAISE FND_API.G_EXC_ERROR;
3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3291: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3292: FND_MSG_PUB.ADD;
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;

Line 3291: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);

3287: FND_MSG_PUB.ADD;
3288: RAISE FND_API.G_EXC_ERROR;
3289: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3290: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3291: FND_MESSAGE.SET_TOKEN('ID' ,l_req9);
3292: FND_MSG_PUB.ADD;
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295: END IF;

Line 3300: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3296: IF l_req10 <> 1 THEN
3297: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),
3298: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3299: IF dphase <> 'COMPLETE' THEN
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3301: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

Line 3301: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);

3297: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),
3298: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3299: IF dphase <> 'COMPLETE' THEN
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3301: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

Line 3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

3301: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;

Line 3306: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);

3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ID' ,l_req10);
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: END IF;
3310: END IF;

Line 3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

3311: EXCEPTION
3312: WHEN FND_API.G_EXC_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: WHEN OTHERS THEN
3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: RAISE FND_API.G_EXC_ERROR;

Line 3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');

3312: WHEN FND_API.G_EXC_ERROR THEN
3313: RAISE FND_API.G_EXC_ERROR;
3314: WHEN OTHERS THEN
3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: RAISE FND_API.G_EXC_ERROR;
3320: END;

Line 3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3313: RAISE FND_API.G_EXC_ERROR;
3314: WHEN OTHERS THEN
3315: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3316: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: RAISE FND_API.G_EXC_ERROR;
3320: END;
3321:

Line 4079: outandlog('Error: ' || FND_MESSAGE.GET);

4075: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
4076:
4077: EXCEPTION
4078: WHEN FND_API.G_EXC_ERROR THEN
4079: outandlog('Error: ' || FND_MESSAGE.GET);
4080: log('Error ' || SQLERRM);
4081: retcode := 2;
4082: errbuf := errbuf || logerror;
4083: outandlog('Aborting concurrent program execution');

Line 4086: outandlog('Error: ' || FND_MESSAGE.GET);

4082: errbuf := errbuf || logerror;
4083: outandlog('Aborting concurrent program execution');
4084: FND_FILE.close;
4085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4086: outandlog('Error: ' || FND_MESSAGE.GET);
4087: log('Error ' || SQLERRM);
4088: retcode := 2;
4089: errbuf := errbuf || logerror;
4090: outandlog('Aborting concurrent program execution');

Line 4093: outandlog('Error: ' || FND_MESSAGE.GET);

4089: errbuf := errbuf || logerror;
4090: outandlog('Aborting concurrent program execution');
4091: FND_FILE.close;
4092: WHEN OTHERS THEN
4093: outandlog('Error: ' || FND_MESSAGE.GET);
4094: log('SQL Error ' || SQLERRM);
4095: retcode := 2;
4096: errbuf := errbuf || logerror || SQLERRM;
4097: outandlog('Aborting concurrent program execution');

Line 4224: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');

4220:
4221: l(' RETURN l_stage_rec;');
4222: l('EXCEPTION');
4223: l(' WHEN OTHERS THEN');
4224: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4225: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4226: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4227: l(' FND_MSG_PUB.ADD;');
4228: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

Line 4225: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');

4221: l(' RETURN l_stage_rec;');
4222: l('EXCEPTION');
4223: l(' WHEN OTHERS THEN');
4224: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4225: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4226: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4227: l(' FND_MSG_PUB.ADD;');
4228: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4229:

Line 4226: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');

4222: l('EXCEPTION');
4223: l(' WHEN OTHERS THEN');
4224: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4225: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4226: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4227: l(' FND_MSG_PUB.ADD;');
4228: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4229:
4230: l('END;');

Line 4234: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');

4230: l('END;');
4231:
4232: EXCEPTION
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_ERROR;

Line 4235: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');

4231:
4232: EXCEPTION
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_ERROR;
4239: END;

Line 4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

4232: EXCEPTION
4233: WHEN OTHERS THEN
4234: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4235: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4236: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4237: FND_MSG_PUB.ADD;
4238: RAISE FND_API.G_EXC_ERROR;
4239: END;
4240:

Line 11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');

11621: '(:attrval,:lang,:attr,:entity) from dual';
11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);

Line 11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

11622: dbms_sql.parse(c,l_sql,2);
11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11630: FND_MSG_PUB.ADD;

Line 11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

11623: dbms_sql.close_cursor(c);
11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11630: FND_MSG_PUB.ADD;
11631: END;

Line 11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);

11624: EXCEPTION WHEN OTHERS THEN
11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11630: FND_MSG_PUB.ADD;
11631: END;
11632: END LOOP;

Line 11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);

11625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11626: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11627: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11629: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11630: FND_MSG_PUB.ADD;
11631: END;
11632: END LOOP;
11633: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME

Line 11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');

11648: '(:record_id,:entity,:attr) from dual';
11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11656: FND_MSG_PUB.ADD;

Line 11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);

11649: dbms_sql.parse(c,l_sql,2);
11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11656: FND_MSG_PUB.ADD;
11657: END;

Line 11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);

11650: dbms_sql.close_cursor(c);
11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11656: FND_MSG_PUB.ADD;
11657: END;
11658: END LOOP;

Line 11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);

11651: EXCEPTION WHEN OTHERS THEN
11652: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11653: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11654: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11656: FND_MSG_PUB.ADD;
11657: END;
11658: END LOOP;
11659: EXCEPTION