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 1434: log(fnd_message.get);

1430: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1431: 'STAGE_NEW_DENORM', l_idx_mem, l_num_prll, 'STAGE_NEW_DENORM');
1432: IF l_req_id = 0 THEN
1433: log('Error submitting request');
1434: log(fnd_message.get);
1435: ELSE
1436: log('Submitted request ID for Party Index: ' || l_req_id );
1437: log('Request ID : ' || l_req_id);
1438: END IF;

Line 1671: log(fnd_message.get);

1667: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1668: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1669: IF l_sub_requests(i) = 0 THEN
1670: log('Error submitting worker ' || i);
1671: log(fnd_message.get);
1672: ELSE
1673: log('Submitted request for Worker ' || TO_CHAR(I) );
1674: log('Request ID : ' || l_sub_requests(i));
1675: END IF;

Line 1698: log(fnd_message.get);

1694: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1695: l_command, l_idx_mem, l_num_prll, l_index);
1696: IF l_req_id = 0 THEN
1697: log('Error submitting request');
1698: log(fnd_message.get);
1699: ELSE
1700: log('Submitted request ID for Party Index: ' || l_req_id );
1701: log('Request ID : ' || l_req_id);
1702: END IF;

Line 1722: log(fnd_message.get);

1718: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1719: l_command, l_idx_mem, l_num_prll, l_index);
1720: IF l_req_id = 0 THEN
1721: log('Error submitting request');
1722: log(fnd_message.get);
1723: ELSE
1724: log('Submitted request ID for Party Site Index: ' || l_req_id );
1725: log('Request ID : ' || l_req_id);
1726: END IF;

Line 1745: log(fnd_message.get);

1741: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1742: l_command, l_idx_mem, l_num_prll, l_index);
1743: IF l_req_id = 0 THEN
1744: log('Error submitting request');
1745: log(fnd_message.get);
1746: ELSE
1747: log('Submitted request ID for Party Index: ' || l_req_id );
1748: log('Request ID : ' || l_req_id);
1749: END IF;

Line 1768: log(fnd_message.get);

1764: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1765: l_command, l_idx_mem, l_num_prll, l_index);
1766: IF l_req_id = 0 THEN
1767: log('Error submitting request');
1768: log(fnd_message.get);
1769: ELSE
1770: log('Submitted request ID for Contact Point Index: ' || l_req_id );
1771: log('Request ID : ' || l_req_id);
1772: END IF;

Line 1836: log(fnd_message.get);

1832: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1833: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1834: IF l_sub_requests(i) = 0 THEN
1835: log('Error submitting worker ' || i);
1836: log(fnd_message.get);
1837: ELSE
1838: log('Submitted request for Worker ' || TO_CHAR(I) );
1839: log('Request ID : ' || l_sub_requests(i));
1840: END IF;

Line 1931: log(fnd_message.get);

1927: to_char(sysdate,'DD-MON-YY HH24:MI:SS'), --bug 4641081
1928: TRUE, to_char(l_num_workers), TO_CHAR(I), l_command,l_continue);
1929: IF l_sub_requests(i) = 0 THEN
1930: log('Error submitting worker ' || i);
1931: log(fnd_message.get);
1932: ELSE
1933: log('Submitted request for Worker ' || TO_CHAR(I) );
1934: log('Request ID : ' || l_sub_requests(i));
1935: END IF;

Line 1953: log(fnd_message.get);

1949: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
1950: l_command, l_idx_mem, l_num_prll, l_index);
1951: IF l_req_id = 0 THEN
1952: log('Error submitting request');
1953: log(fnd_message.get);
1954: ELSE
1955: log('Submitted request ID for Party Index: ' || l_req_id );
1956: log('Request ID : ' || l_req_id);
1957: END IF;

Line 1972: log(fnd_message.get);

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

Line 1991: log(fnd_message.get);

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

Line 2010: log(fnd_message.get);

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

Line 2052: log(fnd_message.get);

2048: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2049: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2050: IF l_req_id = 0 THEN
2051: log('Error submitting request');
2052: log(fnd_message.get);
2053: ELSE
2054: log('Submitted request ID for Party Index: ' || l_req_id );
2055: log('Request ID : ' || l_req_id);
2056: END IF;

Line 2074: log(fnd_message.get);

2070: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2071: l_command, l_idx_mem, l_num_prll, 'HZ_PARTY_SITES');
2072: IF l_req_id = 0 THEN
2073: log('Error submitting request');
2074: log(fnd_message.get);
2075: ELSE
2076: log('Submitted request ID for Party Site Index: ' || l_req_id );
2077: log('Request ID : ' || l_req_id);
2078: END IF;

Line 2096: log(fnd_message.get);

2092: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2093: l_command, l_idx_mem, l_num_prll, 'HZ_ORG_CONTACTS');
2094: IF l_req_id = 0 THEN
2095: log('Error submitting request');
2096: log(fnd_message.get);
2097: ELSE
2098: log('Submitted request ID for Party Index: ' || l_req_id );
2099: log('Request ID : ' || l_req_id);
2100: END IF;

Line 2118: log(fnd_message.get);

2114: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2115: l_command, l_idx_mem, l_num_prll, 'HZ_CONTACT_POINTS');
2116: IF l_req_id = 0 THEN
2117: log('Error submitting request');
2118: log(fnd_message.get);
2119: ELSE
2120: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2121: log('Request ID : ' || l_req_id);
2122: END IF;

Line 2174: log(fnd_message.get);

2170: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2171: l_command, l_idx_mem, l_num_prll, 'HZ_PARTIES');
2172: IF l_req_id = 0 THEN
2173: log('Error submitting request');
2174: log(fnd_message.get);
2175: ELSE
2176: log('Submitted request ID for Party Index: ' || l_req_id );
2177: log('Request ID : ' || l_req_id);
2178: END IF;

Line 2214: log(fnd_message.get);

2210: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2211: l_command, l_idx_mem, l_num_prll, 'HZ_PARTY_SITES');
2212: IF l_req_id = 0 THEN
2213: log('Error submitting request');
2214: log(fnd_message.get);
2215: ELSE
2216: log('Submitted request ID for Party Index: ' || l_req_id );
2217: log('Request ID : ' || l_req_id);
2218: END IF;

Line 2254: log(fnd_message.get);

2250: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2251: l_command, l_idx_mem, l_num_prll, 'HZ_ORG_CONTACTS');
2252: IF l_req_id = 0 THEN
2253: log('Error submitting request');
2254: log(fnd_message.get);
2255: ELSE
2256: log('Submitted request ID for Contact Index: ' || l_req_id );
2257: log('Request ID : ' || l_req_id);
2258: END IF;

Line 2294: log(fnd_message.get);

2290: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2291: l_command, l_idx_mem, l_num_prll, 'HZ_CONTACT_POINTS');
2292: IF l_req_id = 0 THEN
2293: log('Error submitting request');
2294: log(fnd_message.get);
2295: ELSE
2296: log('Submitted request ID for Contact Point Index: ' || l_req_id );
2297: log('Request ID : ' || l_req_id);
2298: END IF;

Line 2317: log(fnd_message.get);

2313: to_char(l_sub_requests(9)), to_char(l_sub_requests(10)),
2314: l_command, l_idx_mem, l_num_prll, l_index);
2315: IF l_req_id = 0 THEN
2316: log('Error submitting request');
2317: log(fnd_message.get);
2318: ELSE
2319: log('Submitted request ID for Party Index: ' || l_req_id );
2320: log('Request ID : ' || l_req_id);
2321: END IF;

Line 2335: log(fnd_message.get);

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

Line 2353: log(fnd_message.get);

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

Line 2371: log(fnd_message.get);

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

Line 2428: log(fnd_message.get);

2424: argument2 => NULL /* p_indexes_only */
2425: );
2426: IF l_req_id = 0 THEN
2427: log('Error submitting sync request');
2428: log(fnd_message.get);
2429: ELSE
2430: log('Submitted request ID for Sync : ' || l_req_id );
2431: log('Request ID : ' || l_req_id);
2432: END IF;

Line 2454: log(fnd_message.get);

2450: retcode := 2;
2451: errbuf := errbuf || logerror || SQLERRM;
2452: FND_FILE.close;
2453: WHEN OTHERS THEN
2454: log(fnd_message.get);
2455: outandlog('Error: Aborting staging');
2456: retcode := 2;
2457: errbuf := errbuf || logerror || SQLERRM;
2458: FND_FILE.close;

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

2867: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
2868:
2869: EXCEPTION
2870: WHEN FND_API.G_EXC_ERROR THEN
2871: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2872: retcode := 2;
2873: errbuf := errbuf || logerror;
2874: FND_FILE.close;
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2872: retcode := 2;
2873: errbuf := errbuf || logerror;
2874: FND_FILE.close;
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: outandlog('Error: Aborting staging ' || FND_MESSAGE.GET);
2877: retcode := 2;
2878: errbuf := errbuf || logerror;
2879: FND_FILE.close;
2880: WHEN OTHERS THEN

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

3041: IF l_req1 <> 1 THEN
3042: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req1),
3043: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3044: IF dphase <> 'COMPLETE' THEN
3045: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3046: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3042: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req1),
3043: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3044: IF dphase <> 'COMPLETE' THEN
3045: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3046: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3050: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3046: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3050: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3051: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3052: FND_MSG_PUB.ADD;
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;

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

3047: FND_MSG_PUB.ADD;
3048: RAISE FND_API.G_EXC_ERROR;
3049: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3050: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3051: FND_MESSAGE.SET_TOKEN('ID' ,l_req1);
3052: FND_MSG_PUB.ADD;
3053: RAISE FND_API.G_EXC_ERROR;
3054: END IF;
3055: END IF;

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

3056: IF l_req2 <> 1 THEN
3057: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),
3058: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3059: IF dphase <> 'COMPLETE' THEN
3060: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3061: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3062: FND_MSG_PUB.ADD;
3063: RAISE FND_API.G_EXC_ERROR;
3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3057: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req2),
3058: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3059: IF dphase <> 'COMPLETE' THEN
3060: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3061: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3062: FND_MSG_PUB.ADD;
3063: RAISE FND_API.G_EXC_ERROR;
3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3061: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3062: FND_MSG_PUB.ADD;
3063: RAISE FND_API.G_EXC_ERROR;
3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3066: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3067: FND_MSG_PUB.ADD;
3068: RAISE FND_API.G_EXC_ERROR;
3069: END IF;

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

3062: FND_MSG_PUB.ADD;
3063: RAISE FND_API.G_EXC_ERROR;
3064: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3066: FND_MESSAGE.SET_TOKEN('ID' ,l_req2);
3067: FND_MSG_PUB.ADD;
3068: RAISE FND_API.G_EXC_ERROR;
3069: END IF;
3070: END IF;

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

3071: IF l_req3 <> 1 THEN
3072: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),
3073: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3074: IF dphase <> 'COMPLETE' THEN
3075: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3076: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3077: FND_MSG_PUB.ADD;
3078: RAISE FND_API.G_EXC_ERROR;
3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3072: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req3),
3073: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3074: IF dphase <> 'COMPLETE' THEN
3075: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3076: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3077: FND_MSG_PUB.ADD;
3078: RAISE FND_API.G_EXC_ERROR;
3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3080: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3076: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3077: FND_MSG_PUB.ADD;
3078: RAISE FND_API.G_EXC_ERROR;
3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3080: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3081: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;

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

3077: FND_MSG_PUB.ADD;
3078: RAISE FND_API.G_EXC_ERROR;
3079: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3080: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3081: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: END IF;
3085: END IF;

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

3086: IF l_req4 <> 1 THEN
3087: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),
3088: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3089: IF dphase <> 'COMPLETE' THEN
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3091: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3092: FND_MSG_PUB.ADD;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3087: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req4),
3088: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3089: IF dphase <> 'COMPLETE' THEN
3090: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3091: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3092: FND_MSG_PUB.ADD;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3095: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3091: FND_MESSAGE.SET_TOKEN('ID' ,l_req3);
3092: FND_MSG_PUB.ADD;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3095: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3096: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;

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

3092: FND_MSG_PUB.ADD;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3095: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3096: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3097: FND_MSG_PUB.ADD;
3098: RAISE FND_API.G_EXC_ERROR;
3099: END IF;
3100: END IF;

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

3101: IF l_req5 <> 1 THEN
3102: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),
3103: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3104: IF dphase <> 'COMPLETE' THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3106: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3107: FND_MSG_PUB.ADD;
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3102: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req5),
3103: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3104: IF dphase <> 'COMPLETE' THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3106: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3107: FND_MSG_PUB.ADD;
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3106: FND_MESSAGE.SET_TOKEN('ID' ,l_req4);
3107: FND_MSG_PUB.ADD;
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3111: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END IF;

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

3107: FND_MSG_PUB.ADD;
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3110: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3111: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3112: FND_MSG_PUB.ADD;
3113: RAISE FND_API.G_EXC_ERROR;
3114: END IF;
3115: END IF;

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

3116: IF l_req6 <> 1 THEN
3117: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),
3118: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3119: IF dphase <> 'COMPLETE' THEN
3120: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3121: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3117: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req6),
3118: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3119: IF dphase <> 'COMPLETE' THEN
3120: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3121: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3125: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3121: FND_MESSAGE.SET_TOKEN('ID' ,l_req5);
3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3125: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3126: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;

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

3122: FND_MSG_PUB.ADD;
3123: RAISE FND_API.G_EXC_ERROR;
3124: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3125: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3126: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3127: FND_MSG_PUB.ADD;
3128: RAISE FND_API.G_EXC_ERROR;
3129: END IF;
3130: END IF;

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

3131: IF l_req7 <> 1 THEN
3132: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),
3133: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3134: IF dphase <> 'COMPLETE' THEN
3135: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3136: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3132: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req7),
3133: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3134: IF dphase <> 'COMPLETE' THEN
3135: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3136: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3136: FND_MESSAGE.SET_TOKEN('ID' ,l_req6);
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3141: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: END IF;

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

3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3141: FND_MESSAGE.SET_TOKEN('ID' ,l_req7);
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_ERROR;
3144: END IF;
3145: END IF;

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

3146: IF l_req8 <> 1 THEN
3147: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),
3148: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3149: IF dphase <> 'COMPLETE' THEN
3150: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3151: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN

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

3147: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req8),
3148: 30, 144000, uphase, ustatus, dphase, dstatus, message);
3149: IF dphase <> 'COMPLETE' THEN
3150: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3151: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');

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

3151: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3156: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3157: FND_MSG_PUB.ADD;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;

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

3152: FND_MSG_PUB.ADD;
3153: RAISE FND_API.G_EXC_ERROR;
3154: ELSIF dphase = 'COMPLETE' and dstatus <> 'NORMAL' THEN
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_WORKER_ERROR');
3156: FND_MESSAGE.SET_TOKEN('ID' ,l_req8);
3157: FND_MSG_PUB.ADD;
3158: RAISE FND_API.G_EXC_ERROR;
3159: END IF;
3160: END IF;

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

3161: IF l_req9 <> 1 THEN
3162: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),
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_req9);
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_req9);

3162: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req9),
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_req9);
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_req9);
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_req9);
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174: END IF;

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

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_req9);
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_req10 <> 1 THEN
3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),
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_req10);
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_req10);

3177: l_bool := FND_CONCURRENT.wait_for_request(TO_NUMBER(l_req10),
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_req10);
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_req10);
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_req10);
3187: FND_MSG_PUB.ADD;
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;

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

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_req10);
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_SQL_ERROR');

3191: EXCEPTION
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN OTHERS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_ERROR;

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

3192: WHEN FND_API.G_EXC_ERROR THEN
3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN OTHERS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_ERROR;
3200: END;

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

3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN OTHERS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('PROC' ,'Index Creation Worker Completion Check');
3197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_ERROR;
3200: END;
3201:

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

3947: log('End Time : '|| TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
3948:
3949: EXCEPTION
3950: WHEN FND_API.G_EXC_ERROR THEN
3951: outandlog('Error: ' || FND_MESSAGE.GET);
3952: log('Error ' || SQLERRM);
3953: retcode := 2;
3954: errbuf := errbuf || logerror;
3955: outandlog('Aborting concurrent program execution');

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

3954: errbuf := errbuf || logerror;
3955: outandlog('Aborting concurrent program execution');
3956: FND_FILE.close;
3957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3958: outandlog('Error: ' || FND_MESSAGE.GET);
3959: log('Error ' || SQLERRM);
3960: retcode := 2;
3961: errbuf := errbuf || logerror;
3962: outandlog('Aborting concurrent program execution');

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

3961: errbuf := errbuf || logerror;
3962: outandlog('Aborting concurrent program execution');
3963: FND_FILE.close;
3964: WHEN OTHERS THEN
3965: outandlog('Error: ' || FND_MESSAGE.GET);
3966: log('SQL Error ' || SQLERRM);
3967: retcode := 2;
3968: errbuf := errbuf || logerror || SQLERRM;
3969: outandlog('Aborting concurrent program execution');

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

4092:
4093: l(' RETURN l_stage_rec;');
4094: l('EXCEPTION');
4095: l(' WHEN OTHERS THEN');
4096: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4097: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4098: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4099: l(' FND_MSG_PUB.ADD;');
4100: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

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

4093: l(' RETURN l_stage_rec;');
4094: l('EXCEPTION');
4095: l(' WHEN OTHERS THEN');
4096: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4097: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4098: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4099: l(' FND_MSG_PUB.ADD;');
4100: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4101:

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

4094: l('EXCEPTION');
4095: l(' WHEN OTHERS THEN');
4096: l(' FND_MESSAGE.SET_NAME(''AR'', ''HZ_MAP_PROC_ERROR'');');
4097: l(' FND_MESSAGE.SET_TOKEN(''PROC'' ,''' || p_proc_name||''');');
4098: l(' FND_MESSAGE.SET_TOKEN(''ERROR'' ,SQLERRM);');
4099: l(' FND_MSG_PUB.ADD;');
4100: l(' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
4101:
4102: l('END;');

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

4102: l('END;');
4103:
4104: EXCEPTION
4105: WHEN OTHERS THEN
4106: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4107: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;

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

4103:
4104: EXCEPTION
4105: WHEN OTHERS THEN
4106: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4107: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: END;

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

4104: EXCEPTION
4105: WHEN OTHERS THEN
4106: FND_MESSAGE.SET_NAME('AR', 'HZ_STAGE_SQL_ERROR');
4107: FND_MESSAGE.SET_TOKEN('PROC' ,'generate_transform_proc');
4108: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: END;
4112:

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

11467: '(:attrval,:lang,:attr,:entity) from dual';
11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);

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

11468: dbms_sql.parse(c,l_sql,2);
11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11476: FND_MSG_PUB.ADD;

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

11469: dbms_sql.close_cursor(c);
11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11476: FND_MSG_PUB.ADD;
11477: END;

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

11470: EXCEPTION WHEN OTHERS THEN
11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11476: FND_MSG_PUB.ADD;
11477: END;
11478: END LOOP;

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

11471: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANS_PROC_ERROR1');
11472: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11473: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11474: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11475: FND_MESSAGE.SET_TOKEN('TRANS' ,l_trans_name);
11476: FND_MSG_PUB.ADD;
11477: END;
11478: END LOOP;
11479: FOR FUNCS IN (SELECT custom_attribute_procedure, ENTITY_NAME, ATTRIBUTE_NAME

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

11494: '(:record_id,:entity,:attr) from dual';
11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11502: FND_MSG_PUB.ADD;

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

11495: dbms_sql.parse(c,l_sql,2);
11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11502: FND_MSG_PUB.ADD;
11503: END;

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

11496: dbms_sql.close_cursor(c);
11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11502: FND_MSG_PUB.ADD;
11503: END;
11504: END LOOP;

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

11497: EXCEPTION WHEN OTHERS THEN
11498: FND_MESSAGE.SET_NAME('AR', 'HZ_CUSTOM_PROC_ERROR1');
11499: FND_MESSAGE.SET_TOKEN('PROC' ,l_procedure);
11500: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_entity);
11501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE' ,l_attribute);
11502: FND_MSG_PUB.ADD;
11503: END;
11504: END LOOP;
11505: EXCEPTION