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.EGO_PUB_FWK_PK dependencies on EGO_UTIL_PK

Line 240: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

236: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
237: ,p_message => 'Exception EGO_NO_DERIVED_ENTITIES in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm);
238:
239:
240: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
241: ,p_message =>'EGO_NO_DERIVED_ENTITIES');
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
244: ,p_msg_data => x_msg_data );

Line 243: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

239:
240: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
241: ,p_message =>'EGO_NO_DERIVED_ENTITIES');
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
244: ,p_msg_data => x_msg_data );
245: WHEN EGO_PUB_BATCHID_NULL THEN
246: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
247: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

Line 249: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

245: WHEN EGO_PUB_BATCHID_NULL THEN
246: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
247: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
248: ,p_message => 'Exception EGO_PUB_BATCHID_NULL in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm );
249: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
250: ,p_message =>'EGO_PUB_BATCHID_NULL');
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
253: ,p_msg_data => x_msg_data );

Line 252: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

248: ,p_message => 'Exception EGO_PUB_BATCHID_NULL in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm );
249: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
250: ,p_message =>'EGO_PUB_BATCHID_NULL');
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
253: ,p_msg_data => x_msg_data );
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION

Line 261: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

257: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
258: ,p_message => 'Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
259:
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
262: ,p_msg_data => x_msg_data );
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED

Line 269: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

265: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
266: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
267: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
270: ,p_msg_data => x_msg_data );
271:
272: WHEN OTHERS THEN
273: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED

Line 277: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

273: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
274: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
275: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
278: ,p_msg_data => x_msg_data );
279:
280: END add_derived_entities;
281:

Line 427: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

423: WHEN EGO_NO_BATCH_SYSTEMS THEN
424: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
425: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
426: ,p_message => 'Exception EGO_NO_BATCH_SYSTEMS in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
427: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
428: ,p_message =>'EGO_NO_BATCH_SYSTEMS');
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: EGO_UTIL_PK.count_and_get
431: (p_msg_count => x_msg_count

Line 430: EGO_UTIL_PK.count_and_get

426: ,p_message => 'Exception EGO_NO_BATCH_SYSTEMS in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
427: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
428: ,p_message =>'EGO_NO_BATCH_SYSTEMS');
429: x_return_status := FND_API.G_RET_STS_ERROR;
430: EGO_UTIL_PK.count_and_get
431: (p_msg_count => x_msg_count
432: ,p_msg_data => x_msg_data );
433:
434: WHEN OTHERS THEN

Line 439: EGO_UTIL_PK.count_and_get

435: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
436: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
437: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: EGO_UTIL_PK.count_and_get
440: (p_msg_count => x_msg_count
441: ,p_msg_data => x_msg_data );
442:
443:

Line 582: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

578: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
579: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
580: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
583: ,p_msg_data => x_msg_data );
584:
585:
586: END Update_Pub_Status_Thru_AIA;

Line 703: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

699: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
700: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'
701: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
704: ,p_msg_data => x_msg_data );
705:
706:
707: When EGO_INVALID_MODE Then

Line 720: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

716: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_MODE'),
717: ret_err_msg_lang = USERENV('LANG')
718: where batch_id = p_batch_id;
719:
720: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
721: ,p_message =>'EGO_INVALID_MODE');
722: EGO_UTIL_PK.count_and_get
723: (p_msg_count => x_msg_count
724: ,p_msg_data => x_msg_data );

Line 722: EGO_UTIL_PK.count_and_get

718: where batch_id = p_batch_id;
719:
720: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
721: ,p_message =>'EGO_INVALID_MODE');
722: EGO_UTIL_PK.count_and_get
723: (p_msg_count => x_msg_count
724: ,p_msg_data => x_msg_data );
725:
726:

Line 794: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

790: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_PUB_BATCHID_NULL'),
791: ret_err_msg_lang = USERENV('LANG')
792: where batch_id =p_batch_id;
793:
794: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
795: ,p_message =>'EGO_PUB_BATCHID_NULL');
796: EGO_UTIL_PK.count_and_get
797: (p_msg_count => x_msg_count
798: ,p_msg_data => x_msg_data );

Line 796: EGO_UTIL_PK.count_and_get

792: where batch_id =p_batch_id;
793:
794: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
795: ,p_message =>'EGO_PUB_BATCHID_NULL');
796: EGO_UTIL_PK.count_and_get
797: (p_msg_count => x_msg_count
798: ,p_msg_data => x_msg_data );
799:
800: x_return_status := C_FAILED;

Line 817: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

813: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_NO_HEADER'),
814: ret_err_msg_lang = USERENV('LANG')
815: where batch_id =p_batch_id;
816:
817: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
818: ,p_message =>'EGO_NO_HEADER');
819: EGO_UTIL_PK.count_and_get
820: (p_msg_count => x_msg_count
821: ,p_msg_data => x_msg_data );

Line 819: EGO_UTIL_PK.count_and_get

815: where batch_id =p_batch_id;
816:
817: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
818: ,p_message =>'EGO_NO_HEADER');
819: EGO_UTIL_PK.count_and_get
820: (p_msg_count => x_msg_count
821: ,p_msg_data => x_msg_data );
822:
823:

Line 834: EGO_UTIL_PK.count_and_get

830: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
831:
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: EGO_UTIL_PK.count_and_get
835: (p_msg_count => x_msg_count
836: ,p_msg_data => x_msg_data );
837:
838: END validate_batch_id;

Line 1108: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1104: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1105: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
1106:
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1109: ,p_msg_data => x_msg_data );
1110:
1111: END Process_Pub_Status;
1112:

Line 1357: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1353: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1354: ,p_message => 'Exception EGO_NO_BAT_STS_IN in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm);
1355:
1356:
1357: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1358: ,p_message =>'EGO_NO_BAT_STS_IN');
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1361: ,p_msg_data => x_msg_data );

Line 1360: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1356:
1357: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1358: ,p_message =>'EGO_NO_BAT_STS_IN');
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1361: ,p_msg_data => x_msg_data );
1362: WHEN OTHERS THEN
1363: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
1364: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

Line 1369: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1365: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
1366:
1367:
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1370: ,p_msg_data => x_msg_data );
1371:
1372:
1373: END Update_Pub_Status;

Line 1472: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1470: ,p_module => l_module_name
1471: ,p_message => 'target systems have duplicate, ' || l_system_code);
1472: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1473: ,p_message =>'SELECT_DIFFERENT_SYSTEM');
1474: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1475: ,p_msg_data => x_msg_data );
1476: return ;

Line 1474: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1470: ,p_module => l_module_name
1471: ,p_message => 'target systems have duplicate, ' || l_system_code);
1472: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1473: ,p_message =>'SELECT_DIFFERENT_SYSTEM');
1474: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1475: ,p_msg_data => x_msg_data );
1476: return ;
1477: end if;
1478: END loop;

Line 1493: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1491: ,p_module => l_module_name
1492: ,p_message => 'target systems have invalid');
1493: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1494: ,p_message =>'ADD_TARGET_SYSTEMS');
1495: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1496: ,p_msg_data => x_msg_data );
1497: end if;

Line 1495: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1491: ,p_module => l_module_name
1492: ,p_message => 'target systems have invalid');
1493: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1494: ,p_message =>'ADD_TARGET_SYSTEMS');
1495: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1496: ,p_msg_data => x_msg_data );
1497: end if;
1498: end validateSystems;
1499:

Line 1563: l_token EGO_UTIL_PK.token_tbl;

1559: l_param_date_val date;
1560: l_param_num_val number;
1561: l_icc_id number;
1562: l_counter number;
1563: l_token EGO_UTIL_PK.token_tbl;
1564: EGO_PUB_PARAM_VALUE_INVL exception;
1565: EGO_PUB_PARAM_INVL exception;
1566: EGO_PUB_PARAM_REQ_EXPL_DATE exception;
1567: begin

Line 1905: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1901: ,p_module => l_module_name
1902: ,p_message => l_param_name || ' value is invalid');
1903: l_token(1).token_name := 'PARAM_NAME';
1904: l_token(1).token_value := l_param_name;
1905: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1906: , p_message => 'EGO_PUB_PARAM_VALUE_INVL'
1907: , p_token => l_token);
1908: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1909: ,p_msg_data => x_msg_data );

Line 1908: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1904: l_token(1).token_value := l_param_name;
1905: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1906: , p_message => 'EGO_PUB_PARAM_VALUE_INVL'
1907: , p_token => l_token);
1908: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1909: ,p_msg_data => x_msg_data );
1910: when EGO_PUB_PARAM_INVL then
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 1915: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1913: ,p_module => l_module_name
1914: ,p_message => 'the type should not has ' || l_param_name);
1915: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1916: , p_message => 'EGO_PUB_PARAM_INVL'
1917: , p_token => l_token);
1918: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1919: ,p_msg_data => x_msg_data );

Line 1918: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1914: ,p_message => 'the type should not has ' || l_param_name);
1915: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1916: , p_message => 'EGO_PUB_PARAM_INVL'
1917: , p_token => l_token);
1918: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1919: ,p_msg_data => x_msg_data );
1920: when EGO_PUB_PARAM_REQ_EXPL_DATE then
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 1925: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1923: ,p_module => l_module_name
1924: ,p_message => ' struct_name is not null, explosion date is required');
1925: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1926: ,p_message => 'EGO_PUB_PARAM_REQ_EXPL_DATE');
1927: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1928: ,p_msg_data => x_msg_data );
1929: when others then

Line 1927: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

1923: ,p_module => l_module_name
1924: ,p_message => ' struct_name is not null, explosion date is required');
1925: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
1926: ,p_message => 'EGO_PUB_PARAM_REQ_EXPL_DATE');
1927: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1928: ,p_msg_data => x_msg_data );
1929: when others then
1930: x_return_status := FND_API.G_RET_STS_ERROR;
1931: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 2004: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2000: x_return_status := FND_API.G_RET_STS_ERROR;
2001: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2002: ,p_module => l_module_name
2003: ,p_message => 'user doesnot has the resp');
2004: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2005: ,p_message =>'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
2006: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2007: ,p_msg_data => x_msg_data );
2008: return ;

Line 2006: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2002: ,p_module => l_module_name
2003: ,p_message => 'user doesnot has the resp');
2004: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2005: ,p_message =>'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
2006: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2007: ,p_msg_data => x_msg_data );
2008: return ;
2009: end;
2010:

Line 2019: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2015: if fnd_function.test(function_name => l_func_name) then
2016: return ;
2017: else
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2020: ,p_message =>'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
2021: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2022: ,p_msg_data => x_msg_data );
2023: return ;

Line 2021: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2017: else
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2020: ,p_message =>'EGO_NO_FUNC_PRIVILEGE_FOR_USER');
2021: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2022: ,p_msg_data => x_msg_data );
2023: return ;
2024: end if;
2025: exception

Line 2051: l_token EGO_UTIL_PK.token_tbl;

2047: l_has_prv varchar2(1) ;
2048:
2049: l_item_number varchar2(500);
2050: l_item_list varchar2(6000);
2051: l_token EGO_UTIL_PK.token_tbl;
2052: l_err_msg varchar2(2000) := null;
2053: l_msg_name varchar2(50) ;
2054: l_party_id number ;
2055: l_party_idstr varchar2(100) ;

Line 2072: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2068: ,p_module => l_module_name
2069: ,p_message => l_err_msg
2070: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2071: x_return_status := FND_API.G_RET_STS_ERROR;
2072: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2073: ,p_message =>'EGO_PERSON_INVALID');
2074: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2075: ,p_msg_data => x_msg_data );
2076: return;

Line 2074: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2070: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2071: x_return_status := FND_API.G_RET_STS_ERROR;
2072: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2073: ,p_message =>'EGO_PERSON_INVALID');
2074: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2075: ,p_msg_data => x_msg_data );
2076: return;
2077: end ;
2078:

Line 2145: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2141: else
2142: l_msg_name := 'EGO_NO_VIEW_PRIVILEGE';
2143: end if;
2144:
2145: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2146: , p_message => l_msg_name
2147: , p_token => l_token);
2148: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2149: ,p_msg_data => x_msg_data );

Line 2148: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2144:
2145: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2146: , p_message => l_msg_name
2147: , p_token => l_token);
2148: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2149: ,p_msg_data => x_msg_data );
2150: END IF;
2151: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2152: ,P_MODULE => L_MODULE_NAME

Line 2178: l_token EGO_UTIL_PK.token_tbl;

2174: l_item_id number;
2175: l_org_id number;
2176: l_item_number VARCHAR2(500);
2177: l_item_list varchar2(6000);
2178: l_token EGO_UTIL_PK.token_tbl;
2179: l_err_msg varchar2(2000) ;
2180: l_rev_id number;
2181: l_impl varchar2(1);
2182: l_valid_expl varchar2(1);

Line 2270: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2266: x_return_status := FND_API.G_RET_STS_ERROR;
2267: if (l_has_impl_err ) then
2268: l_token(1).token_name := 'ITEM_LIST';
2269: l_token(1).token_value := l_item_list;
2270: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2271: , p_message => 'EGO_UNIMP_REV_NO_PUB'
2272: , p_token => l_token);
2273: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2274: ,p_msg_data => x_msg_data );

Line 2273: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2269: l_token(1).token_value := l_item_list;
2270: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2271: , p_message => 'EGO_UNIMP_REV_NO_PUB'
2272: , p_token => l_token);
2273: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2274: ,p_msg_data => x_msg_data );
2275: end if;
2276: if (l_has_expl_err) then
2277: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

Line 2277: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2273: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2274: ,p_msg_data => x_msg_data );
2275: end if;
2276: if (l_has_expl_err) then
2277: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2278: , p_message => 'EGO_PUBLISH_DATE_INVALID'
2279: , p_token => l_token);
2280: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2281: ,p_msg_data => x_msg_data );

Line 2280: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2276: if (l_has_expl_err) then
2277: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2278: , p_message => 'EGO_PUBLISH_DATE_INVALID'
2279: , p_token => l_token);
2280: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2281: ,p_msg_data => x_msg_data );
2282: end if;
2283: END IF;
2284: END hasItemsRevsImplExplValid;

Line 2421: l_token EGO_UTIL_PK.token_tbl;

2417: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2418: l_entity_id number;
2419: l_valid boolean := true;
2420: l_msg varchar2(300);
2421: l_token EGO_UTIL_PK.token_tbl;
2422:
2423: l_pk1_value number ;
2424: l_pk2_value number ;
2425: l_pk3_value number ;

Line 2508: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2504: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2505: ,p_module => l_module_name
2506: ,p_message => ' entities have invalid '
2507: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2508: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2509: ,p_message =>'EGO_PUB_ENTITY_INVL');
2510: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2511: ,p_msg_data => x_msg_data );
2512: end if;

Line 2510: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2506: ,p_message => ' entities have invalid '
2507: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2508: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2509: ,p_message =>'EGO_PUB_ENTITY_INVL');
2510: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2511: ,p_msg_data => x_msg_data );
2512: end if;
2513:
2514: end validateEntities;

Line 2643: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2641: ,p_module => l_module_name
2642: ,p_message => to_char(p_batch_id) || ', not batch creator');
2643: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2644: ,p_message =>'EGO_PUB_USR_NOT_OWNER');
2645: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2646: ,p_msg_data => x_msg_data );
2647: return ;

Line 2645: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2641: ,p_module => l_module_name
2642: ,p_message => to_char(p_batch_id) || ', not batch creator');
2643: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2644: ,p_message =>'EGO_PUB_USR_NOT_OWNER');
2645: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2646: ,p_msg_data => x_msg_data );
2647: return ;
2648: end;
2649: begin

Line 2659: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

2655: x_return_status := FND_API.G_RET_STS_ERROR;
2656: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2657: ,p_module => l_module_name
2658: ,p_message => to_char(p_batch_id) || ', not draft batch');
2659: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2660: ,p_message =>'EGO_PUB_STATUS_NOT_DRAFT');
2661: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2662: ,p_msg_data => x_msg_data );
2663: return ;

Line 2661: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

2657: ,p_module => l_module_name
2658: ,p_message => to_char(p_batch_id) || ', not draft batch');
2659: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
2660: ,p_message =>'EGO_PUB_STATUS_NOT_DRAFT');
2661: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
2662: ,p_msg_data => x_msg_data );
2663: return ;
2664: end;
2665:

Line 2932: l_token EGO_UTIL_PK.token_tbl;

2928: l_batch_entity_obj_ids dbms_sql.number_table;
2929: l_pub_type varchar2(10);
2930: l_expl_date date;
2931:
2932: l_token EGO_UTIL_PK.token_tbl;
2933: l_err_msg varchar2(2000) := null;
2934: l_msg_name varchar2(50) ;
2935: l_has_priv BOOLEAN ;
2936:

Line 3302: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3298: ,p_message => ' batch name is null'
3299: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3300: l_token(1).token_name := 'PARAM';
3301: l_token(1).token_value := 'p_batch_name';
3302: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3303: , p_message =>'EGO_PUB_API_PARAM_NULL'
3304: , p_token => l_token);
3305: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3306: ,p_msg_data => x_msg_data );

Line 3305: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3301: l_token(1).token_value := 'p_batch_name';
3302: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3303: , p_message =>'EGO_PUB_API_PARAM_NULL'
3304: , p_token => l_token);
3305: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3306: ,p_msg_data => x_msg_data );
3307: when EGO_PUB_BATCHNAME_DUP then
3308: x_return_status := FND_API.G_RET_STS_ERROR;
3309: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3313: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3309: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3310: ,p_module => l_module_name
3311: ,p_message => p_batch_name || ', batch name is duplicated '
3312: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3313: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3314: ,p_message =>'EGO_BATCH_DUP_NAME');
3315: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3316: ,p_msg_data => x_msg_data );
3317:

Line 3315: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3311: ,p_message => p_batch_name || ', batch name is duplicated '
3312: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3313: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3314: ,p_message =>'EGO_BATCH_DUP_NAME');
3315: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3316: ,p_msg_data => x_msg_data );
3317:
3318: when EGO_PUB_BATCHTYPE_NULL then
3319: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3326: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3322: ,p_message => ' batch type is null'
3323: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3324: l_token(1).token_name := 'PARAM';
3325: l_token(1).token_value := 'p_batch_type';
3326: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3327: , p_message =>'EGO_PUB_API_PARAM_NULL'
3328: , p_token => l_token);
3329: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3330: ,p_msg_data => x_msg_data );

Line 3329: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3325: l_token(1).token_value := 'p_batch_type';
3326: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3327: , p_message =>'EGO_PUB_API_PARAM_NULL'
3328: , p_token => l_token);
3329: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3330: ,p_msg_data => x_msg_data );
3331:
3332: when EGO_PUB_BATCHTYPE_INVL then
3333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3338: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3334: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3335: ,p_module => l_module_name
3336: ,p_message => ' batch type is invalid'
3337: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3338: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3339: ,p_message =>'EGO_INVALID_BATCH_TYPE');
3340: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3341: ,p_msg_data => x_msg_data );
3342:

Line 3340: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3336: ,p_message => ' batch type is invalid'
3337: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3338: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3339: ,p_message =>'EGO_INVALID_BATCH_TYPE');
3340: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3341: ,p_msg_data => x_msg_data );
3342:
3343: when EGO_PUB_PARAMS_NULL then
3344: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3351: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3347: ,p_message => ' batch param is null'
3348: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3349: l_token(1).token_name := 'PARAM';
3350: l_token(1).token_value := 'p_pub_params';
3351: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3352: , p_message =>'EGO_PUB_API_PARAM_NULL'
3353: , p_token => l_token);
3354: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3355: ,p_msg_data => x_msg_data );

Line 3354: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3350: l_token(1).token_value := 'p_pub_params';
3351: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3352: , p_message =>'EGO_PUB_API_PARAM_NULL'
3353: , p_token => l_token);
3354: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3355: ,p_msg_data => x_msg_data );
3356:
3357: when EGO_PUB_ENTITIES_NULL then
3358: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3363: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3359: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3360: ,p_module => l_module_name
3361: ,p_message => ' EGO_NO_ITEMS_TO_PUBLISH'
3362: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3363: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3364: ,p_message =>'EGO_NO_ITEMS_TO_PUBLISH');
3365: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3366: ,p_msg_data => x_msg_data );
3367:

Line 3365: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3361: ,p_message => ' EGO_NO_ITEMS_TO_PUBLISH'
3362: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3363: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3364: ,p_message =>'EGO_NO_ITEMS_TO_PUBLISH');
3365: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3366: ,p_msg_data => x_msg_data );
3367:
3368: when EGO_PUB_TARGET_SYS_NULL then
3369: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3374: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3370: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3371: ,p_module => l_module_name
3372: ,p_message => ' target system is null'
3373: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3374: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3375: ,p_message =>'ADD_TARGET_SYSTEMS');
3376: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3377: ,p_msg_data => x_msg_data );
3378:

Line 3376: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3372: ,p_message => ' target system is null'
3373: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3374: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3375: ,p_message =>'ADD_TARGET_SYSTEMS');
3376: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3377: ,p_msg_data => x_msg_data );
3378:
3379: when EGO_PUB_MUL_ENTITY_REVS then
3380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3385: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3381: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3382: ,p_module => l_module_name
3383: ,p_message => ' it has entities with multi-rev '
3384: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3385: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3386: ,p_message =>'EGO_PUB_MUL_ENTITY_REVS');
3387: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3388: ,p_msg_data => x_msg_data );
3389:

Line 3387: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3383: ,p_message => ' it has entities with multi-rev '
3384: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3385: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3386: ,p_message =>'EGO_PUB_MUL_ENTITY_REVS');
3387: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3388: ,p_msg_data => x_msg_data );
3389:
3390: when EGO_PUB_PUBLISH_FAILED then
3391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3396: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3392: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3393: ,p_module => l_module_name
3394: ,p_message => ' raise event failed'
3395: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3396: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3397: ,p_message =>'EGO_PUBLISH_EVENT_FAILED');
3398: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3399: ,p_msg_data => x_msg_data );
3400:

Line 3398: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3394: ,p_message => ' raise event failed'
3395: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3396: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3397: ,p_message =>'EGO_PUBLISH_EVENT_FAILED');
3398: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3399: ,p_msg_data => x_msg_data );
3400:
3401: when others then
3402: l_err_msg := ' others error ' ||sqlerrm ;

Line 3445: l_token EGO_UTIL_PK.token_tbl;

3441: l_params_count number;
3442:
3443: l_invl_count number := 0;
3444: l_failed_count number := 0;
3445: l_token EGO_UTIL_PK.token_tbl;
3446: l_err_msg varchar2(2000) := null;
3447:
3448: EGO_PUB_BATCH_NAMEIDS_NULL EXCEPTION;
3449: EGO_PUB_BATCH_NAMEIDS_INVL EXCEPTION;

Line 3552: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3548: l_err_msg := ' the user is not batch creator ';
3549: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3550: ,p_module => l_module_name
3551: ,p_message => l_err_msg);
3552: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3553: ,p_message =>'EGO_PUB_BATCH_NOT_CREATOR');
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3556: ,p_msg_data => x_msg_data );

Line 3555: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3551: ,p_message => l_err_msg);
3552: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3553: ,p_message =>'EGO_PUB_BATCH_NOT_CREATOR');
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3556: ,p_msg_data => x_msg_data );
3557: l_invl_count := l_invl_count + 1;
3558:
3559: when EGO_PUB_BATCH_NOT_DRAFT then

Line 3564: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3560: l_err_msg := ' the batch status is not draft ';
3561: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3562: ,p_module => l_module_name
3563: ,p_message => l_err_msg);
3564: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3565: ,p_message =>'EGO_PUB_BATCH_NOT_DRAFT');
3566: x_return_status := FND_API.G_RET_STS_ERROR;
3567: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3568: ,p_msg_data => x_msg_data );

Line 3567: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3563: ,p_message => l_err_msg);
3564: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3565: ,p_message =>'EGO_PUB_BATCH_NOT_DRAFT');
3566: x_return_status := FND_API.G_RET_STS_ERROR;
3567: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3568: ,p_msg_data => x_msg_data );
3569: l_invl_count := l_invl_count + 1;
3570:
3571: when others then

Line 3597: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3593: ,p_module => l_module_name
3594: ,p_message => ' names & ids are null ');
3595: l_token(1).token_name := 'PARAM';
3596: l_token(1).token_value := 'p_batch_ids & p_batch_names';
3597: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3598: , p_message =>'EGO_PUB_API_PARAM_NULL'
3599: , p_token => l_token);
3600: x_return_status := FND_API.G_RET_STS_ERROR;
3601: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

Line 3601: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3597: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3598: , p_message =>'EGO_PUB_API_PARAM_NULL'
3599: , p_token => l_token);
3600: x_return_status := FND_API.G_RET_STS_ERROR;
3601: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3602: ,p_msg_data => x_msg_data );
3603:
3604: when EGO_PUB_BATCH_NAMEIDS_INVL then
3605: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3608: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3604: when EGO_PUB_BATCH_NAMEIDS_INVL then
3605: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3606: ,p_module => l_module_name
3607: ,p_message => ' names, ids length not match, no valid pair');
3608: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3609: ,p_message =>'EGO_PUB_BATCH_NAMEIDS_INVL');
3610: x_return_status := FND_API.G_RET_STS_ERROR;
3611: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3612: ,p_msg_data => x_msg_data );

Line 3611: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3607: ,p_message => ' names, ids length not match, no valid pair');
3608: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3609: ,p_message =>'EGO_PUB_BATCH_NAMEIDS_INVL');
3610: x_return_status := FND_API.G_RET_STS_ERROR;
3611: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3612: ,p_msg_data => x_msg_data );
3613:
3614: when EGO_PUB_PUBLISH_FAILED then
3615: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3619: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3615: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3616: ,p_module => l_module_name
3617: ,p_message => ' it has failed publish batches'
3618: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3619: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3620: ,p_message =>'EGO_PUBLISH_EVENT_FAILED');
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3623: ,p_msg_data => x_msg_data );

Line 3622: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3618: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3619: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3620: ,p_message =>'EGO_PUBLISH_EVENT_FAILED');
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3623: ,p_msg_data => x_msg_data );
3624:
3625: end publish_batch;
3626:

Line 3660: l_token EGO_UTIL_PK.token_tbl;

3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;
3658: l_counter number;
3659:
3660: l_token EGO_UTIL_PK.token_tbl;
3661: l_err_msg varchar2(2000) := null;
3662: EGO_PUB_BATCHNAMEID_NULL EXCEPTION;
3663: EGO_PUB_BATCHNAMEID_INVL EXCEPTION;
3664: EGO_PUB_BATCHNAMEID_DUP EXCEPTION;

Line 3767: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3763: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3764: x_return_status := FND_API.G_RET_STS_ERROR;
3765: l_token(1).token_name := 'PARAM';
3766: l_token(1).token_value := 'p_batch_name & p_batch_id';
3767: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3768: , p_message =>'EGO_PUB_API_PARAM_NULL'
3769: , p_token => l_token);
3770: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3771: ,p_msg_data => x_msg_data );

Line 3770: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3766: l_token(1).token_value := 'p_batch_name & p_batch_id';
3767: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3768: , p_message =>'EGO_PUB_API_PARAM_NULL'
3769: , p_token => l_token);
3770: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3771: ,p_msg_data => x_msg_data );
3772:
3773: when EGO_PUB_BATCHNAMEID_DUP then
3774: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3779: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3775: ,p_module => l_module_name
3776: ,p_message => ' batch_name, id pair has dup '
3777: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3778: x_return_status := FND_API.G_RET_STS_ERROR;
3779: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3780: ,p_message =>'EGO_PUB_BATCHNAMEID_DUP');
3781: ego_util_pk.count_and_get (p_msg_count => x_msg_count
3782: ,p_msg_data => x_msg_data );
3783:

Line 3781: ego_util_pk.count_and_get (p_msg_count => x_msg_count

3777: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3778: x_return_status := FND_API.G_RET_STS_ERROR;
3779: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3780: ,p_message =>'EGO_PUB_BATCHNAMEID_DUP');
3781: ego_util_pk.count_and_get (p_msg_count => x_msg_count
3782: ,p_msg_data => x_msg_data );
3783:
3784: when EGO_PUB_BATCHNAMEID_INVL then
3785: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3790: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3786: ,p_module => l_module_name
3787: ,p_message => ' batch_name, id pair is invalid '
3788: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3789: x_return_status := FND_API.G_RET_STS_ERROR;
3790: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3791: ,p_message =>'EGO_PUB_BATCHNAMEID_INVL');
3792: ego_util_pk.count_and_get (p_msg_count => x_msg_count
3793: ,p_msg_data => x_msg_data );
3794:

Line 3792: ego_util_pk.count_and_get (p_msg_count => x_msg_count

3788: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3789: x_return_status := FND_API.G_RET_STS_ERROR;
3790: ego_util_pk.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3791: ,p_message =>'EGO_PUB_BATCHNAMEID_INVL');
3792: ego_util_pk.count_and_get (p_msg_count => x_msg_count
3793: ,p_msg_data => x_msg_data );
3794:
3795: when others then
3796: l_err_msg := ' others error ' ||sqlerrm ;

Line 3824: l_token EGO_UTIL_PK.token_tbl;

3820: l_has_priv boolean;
3821: l_params_count number;
3822:
3823: l_con_req_id number := -1;
3824: l_token EGO_UTIL_PK.token_tbl;
3825: l_err_msg varchar2(2000) := null;
3826:
3827: EGO_PUB_BATCH_PARAMS_NULL EXCEPTION;
3828: EGO_PUB_BATCH_NAMEIDS_INVL EXCEPTION;

Line 3949: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3945: ,p_module => l_module_name
3946: ,p_message => ' params are null');
3947: l_token(1).token_name := 'PARAM';
3948: l_token(1).token_value := 'p_batch_names, p_batch_ids & p_purge_days';
3949: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3950: , p_message =>'EGO_PUB_API_PARAM_NULL'
3951: , p_token => l_token);
3952: x_return_status := FND_API.G_RET_STS_ERROR;
3953: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

Line 3953: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3949: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3950: , p_message =>'EGO_PUB_API_PARAM_NULL'
3951: , p_token => l_token);
3952: x_return_status := FND_API.G_RET_STS_ERROR;
3953: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3954: ,p_msg_data => x_msg_data );
3955:
3956: when EGO_PUB_BATCH_NAMEIDS_INVL then
3957: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3960: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3956: when EGO_PUB_BATCH_NAMEIDS_INVL then
3957: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3958: ,p_module => l_module_name
3959: ,p_message => ' names/ids length not match, or invalid pair ');
3960: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3961: ,p_message =>'EGO_PUB_BATCH_NAMEIDS_INVL');
3962: x_return_status := FND_API.G_RET_STS_ERROR;
3963: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3964: ,p_msg_data => x_msg_data );

Line 3963: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3959: ,p_message => ' names/ids length not match, or invalid pair ');
3960: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3961: ,p_message =>'EGO_PUB_BATCH_NAMEIDS_INVL');
3962: x_return_status := FND_API.G_RET_STS_ERROR;
3963: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3964: ,p_msg_data => x_msg_data );
3965:
3966: when EGO_PUB_BATCH_PURGE_CP_FAIL then
3967: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 3970: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

3966: when EGO_PUB_BATCH_PURGE_CP_FAIL then
3967: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3968: ,p_module => l_module_name
3969: ,p_message => ' cannot launch the purge cp, pls contact admin ');
3970: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3971: ,p_message =>'EGO_PUB_BATCH_PURGE_CP_FAIL');
3972: x_return_status := FND_API.G_RET_STS_ERROR;
3973: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3974: ,p_msg_data => x_msg_data );

Line 3973: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

3969: ,p_message => ' cannot launch the purge cp, pls contact admin ');
3970: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
3971: ,p_message =>'EGO_PUB_BATCH_PURGE_CP_FAIL');
3972: x_return_status := FND_API.G_RET_STS_ERROR;
3973: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
3974: ,p_msg_data => x_msg_data );
3975:
3976: when others then
3977: l_err_msg := l_err_msg || ' others error ' || sqlerrm ;