APPS.EGO_PUB_FWK_PK dependencies on FND_API

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
98: ,p_message => 'Enter EGO_PUB_FWK_PK.add_derived_entities ... '
99: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
100:
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: --check if der_bat_ent_objs is null
104: --return error message
105: IF ( der_bat_ent_objs.count() = 0 OR der_bat_ent_objs IS NULL ) THEN

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: ,x_msg_data => x_msg_data
119: );
120:
121: If (x_return_status = C_FAILED) THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: return;
124: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: End if;

Line 124: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

120:
121: If (x_return_status = C_FAILED) THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: return;
124: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: End if;
127:
128: /* IF ( l_batch_id IS NULL ) THEN

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: If (x_return_status = C_FAILED) THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: return;
124: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: End if;
127:
128: /* IF ( l_batch_id IS NULL ) THEN
129: RAISE EGO_PUB_BATCHID_NULL;

Line 220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

216: ,x_msg_count => x_msg_count
217: ,x_msg_data => x_msg_data);
218:
219: --we need to check return messages
220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;

Line 221: RAISE FND_API.G_EXC_ERROR;

217: ,x_msg_data => x_msg_data);
218:
219: --we need to check return messages
220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:

Line 222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

218:
219: --we need to check return messages
220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: delete from EGO_PUBLICATION_BATCH_GT;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: --we need to check return messages
220: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: delete from EGO_PUBLICATION_BATCH_GT;
227:

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
245: WHEN EGO_PUB_BATCHID_NULL THEN
246: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
254:
255: WHEN FND_API.G_EXC_ERROR THEN

Line 255: WHEN FND_API.G_EXC_ERROR THEN

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
257: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
258: ,p_message => 'Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
259:

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
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

Line 264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: WHEN OTHERS THEN
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;

Line 309: x_return_status := FND_API.G_RET_STS_SUCCESS;

305: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
306: ,p_message => 'Enter EGO_PUB_FWK_PK.process_entities ... '
307: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310:
311: -- Adding column for entity_type_id . Added for Metadata Sync
312:
313: l_stmt_num := 10;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

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
432: ,p_msg_data => x_msg_data );
433:

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: WHEN OTHERS THEN
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:

Line 493: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

489: ,x_msg_data =>x_msg_data);
490:
491: If (x_return_status = C_FAILED) THEN
492: return;
493: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: --revisit
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: End if;
497:

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: If (x_return_status = C_FAILED) THEN
492: return;
493: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: --revisit
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: End if;
497:
498: --debug statement to look at Input GT data
499: Select Batch_id

Line 560: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

556: ,x_msg_count => x_msg_count
557: ,x_msg_data => x_msg_data)
558: ;
559:
560: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
561: x_return_status := l_ret_status;
562: return;
563: END IF;
564:

Line 581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

577: When OTHERS Then
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:

Line 680: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

676: );
677:
678: If (x_return_status = C_FAILED) THEN
679: return;
680: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: End if;
683:
684: l_stmt_num := 20;

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677:
678: If (x_return_status = C_FAILED) THEN
679: return;
680: Elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: End if;
683:
684: l_stmt_num := 20;
685: -- 8773131 for mode validation, added mode C_BATCH_MODE

Line 698: When FND_API.G_EXC_UNEXPECTED_ERROR Then

694: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
695:
696: Exception
697:
698: When FND_API.G_EXC_UNEXPECTED_ERROR Then
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;

Line 702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

698: When FND_API.G_EXC_UNEXPECTED_ERROR Then
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:

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
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:

Line 1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1103: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
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;

Line 1173: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1169: ,x_msg_data => x_msg_data);
1170:
1171: IF (x_return_status = C_FAILED) THEN
1172: return;
1173: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: --revisit
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: End if;
1177:

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: IF (x_return_status = C_FAILED) THEN
1172: return;
1173: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: --revisit
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: End if;
1177:
1178: IF ( p_bat_status_in.count() = 0 OR p_bat_status_in IS NULL ) THEN
1179: RAISE EGO_NO_BAT_STS_IN; --!!!!!!!!! should I raise exception or put error message into GT

Line 1265: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1261: ,x_return_status => l_ret_status
1262: ,x_msg_count => x_msg_count
1263: ,x_msg_data => x_msg_data);
1264:
1265: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1266: x_return_status := l_ret_status;
1267: return;
1268: END IF;
1269: x_return_status := calc_return_status(p_batch_id=>p_batch_id);

Line 1359: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
1362: WHEN OTHERS THEN
1363: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED

Line 1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1364: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
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:

Line 1379: x_return_status := FND_API.G_RET_STS_SUCCESS;

1375: Procedure DeleteGTTableData(x_return_status OUT NOCOPY VARCHAR2)
1376: IS
1377:
1378: BEGIN
1379: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380:
1381: Delete from Ego_Publication_Batch_GT;
1382:
1383: EXCEPTION

Line 1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1385: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
1386: ,p_module => 'EGO_PUB_FWK_PK.DeleteGTTableData'
1387: ,p_message => 'sqlerrm=>' ||sqlerrm );
1388:
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: END DeleteGTTableData;
1391:
1392:
1393: -- public apis

Line 1425: x_return_status := FND_API.G_RET_STS_SUCCESS;

1421: l_system_name varchar2(100);
1422: l_system_code varchar2(30) ;
1423: l_valid boolean := true;
1424: begin
1425: x_return_status := FND_API.G_RET_STS_SUCCESS;
1426:
1427: for i in 1..p_target_systems.count loop
1428: l_system_name := p_target_systems(i).system_name;
1429: l_system_code := p_target_systems(i).system_code;

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR;

1464: -- check for duplicate
1465: if (l_target_systems.count > 0) then
1466: FOR j IN 1..l_target_systems.count loop
1467: IF (l_target_systems(j).system_code = l_system_code) THEN
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'

Line 1489: x_return_status := FND_API.G_RET_STS_ERROR;

1485: ,P_MESSAGE => ' system code: ' || l_system_code );
1486: end loop;
1487:
1488: if (not l_valid ) then
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'

Line 1568: x_return_status := FND_API.G_RET_STS_SUCCESS;

1564: EGO_PUB_PARAM_VALUE_INVL exception;
1565: EGO_PUB_PARAM_INVL exception;
1566: EGO_PUB_PARAM_REQ_EXPL_DATE exception;
1567: begin
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;
1569: l_pub_params := p_pub_params;
1570: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1571: ,p_module => l_module_name
1572: ,p_message => 'batch_type: ' || p_batch_type);

Line 1899: x_return_status := FND_API.G_RET_STS_ERROR;

1895: end if;
1896:
1897: exception
1898: when EGO_PUB_PARAM_VALUE_INVL then
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1901: ,p_module => l_module_name
1902: ,p_message => l_param_name || ' value is invalid');
1903: l_token(1).token_name := 'PARAM_NAME';

Line 1911: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1921: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1930: x_return_status := FND_API.G_RET_STS_ERROR;

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
1932: ,p_module => l_module_name
1933: ,p_message => 'unknown excpetion!!!' || sqlerrm);
1934: end validateBatchParams;

Line 1952: x_return_status := FND_API.G_RET_STS_SUCCESS;

1948: l_user_id number;
1949: l_resp_id number;
1950: l_resp_key varchar2(30);
1951: begin
1952: x_return_status := FND_API.G_RET_STS_SUCCESS;
1953: if (p_entity_type = C_BATCH_ENTITY_ICC) THEN
1954: l_func_name := 'EGO_ITEM_ADMINISTRATION';
1955: elsif (p_entity_type = C_BATCH_ENTITY_AG) THEN
1956: l_func_name := 'EGO_ITEM_USER_ATTRS';

Line 2000: x_return_status := FND_API.G_RET_STS_ERROR;

1996: and u.user_id = l_user_id
1997: and r.responsibility_id = l_resp_id) rdi;
1998: exception
1999: when no_data_found then
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'

Line 2018: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2028: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2029: ,p_module => l_module_name
2030: ,p_message => l_err_msg
2031: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: end hasPublishSyncPriv;
2034:
2035: -- refer to EgoItemPrivilegeQueryContext.hasPrivilege, the privileges is cached by the EgoPrivilegeQueryContext
2036: -- check item public api, does it has privilege check , FUNCTION

Line 2059: x_return_status := FND_API.G_RET_STS_SUCCESS;

2055: l_party_idstr varchar2(100) ;
2056: l_item_id number;
2057: l_org_id number;
2058: begin
2059: x_return_status := FND_API.G_RET_STS_SUCCESS;
2060:
2061: begin
2062: SELECT party_id INTO l_party_id from ego_user_v
2063: where user_id = p_user_id;

Line 2071: x_return_status := FND_API.G_RET_STS_ERROR;

2067: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
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 );

Line 2136: x_return_status := FND_API.G_RET_STS_ERROR;

2132: end if;
2133: end loop;
2134:
2135: IF (l_err_msg is not null) THEN
2136: x_return_status := FND_API.G_RET_STS_ERROR;
2137: if (p_privilege_name = 'EGO_PUBLISH_ITEM') then
2138: l_msg_name := 'EGO_NO_PUBLISH_PRIVILEGE';
2139: l_token(1).token_name := 'ITEM_LIST';
2140: l_token(1).token_value := l_item_list;

Line 2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2158: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2159: ,p_module => l_module_name
2160: ,p_message => l_err_msg
2161: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2163: end hasItemPriv;
2164:
2165: procedure hasItemsRevsImplExplValid(
2166: p_batch_entities IN TBL_OF_BAT_ENT_OBJ_TYPE,

Line 2200: x_return_status := FND_API.G_RET_STS_SUCCESS;

2196: AND effectivity_date <= c_expl_date
2197: AND implementation_date IS NOT NULL;
2198:
2199: begin
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201:
2202: FOR i IN p_batch_entities.FIRST..p_batch_entities.LAST LOOP
2203: l_item_id := to_number(p_batch_entities(i).pk1_value);
2204: l_org_id := to_number(p_batch_entities(i).pk2_value);

Line 2266: x_return_status := FND_API.G_RET_STS_ERROR;

2262: end if;
2263: END LOOP;
2264:
2265: IF (l_has_impl_err or l_has_expl_err) THEN
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'

Line 2316: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2312: ,p_module => l_module_name
2313: ,p_message => 'check item view privilege');
2314: hasItemPriv(p_user_id, p_batch_entities, 'EGO_VIEW_ITEM',
2315: x_return_status, x_msg_count, x_msg_data);
2316: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2317: return ;
2318: end if;
2319: -- check user has publish item priv 'EGO_PUBLISH_ITEM'
2320: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 2325: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2321: ,p_module => l_module_name
2322: ,p_message => 'check item publish privilege');
2323: hasItemPriv(p_user_id, p_batch_entities, 'EGO_PUBLISH_ITEM',
2324: x_return_status, x_msg_count, x_msg_data);
2325: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2326: return ;
2327: end if;
2328:
2329: -- check the selected item rev is implemented

Line 2336: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2332: ,p_message => 'check item rev implemented status, explosion date valid');
2333:
2334: hasItemsRevsImplExplValid(p_batch_entities, p_expl_date,
2335: x_return_status, x_msg_count, x_msg_data);
2336: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2337: return ;
2338: end if;
2339: else
2340: -- check user has pub/sync privileges of icc/ag/vs

Line 2346: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2342: ,p_module => l_module_name
2343: ,p_message => 'check icc/ag/vs access priv');
2344: hasPublishSyncPriv(p_user_id, p_batch_type,
2345: x_return_status, x_msg_count, x_msg_data);
2346: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2347: return ;
2348: end if;
2349: end if;
2350: end hasPublishPrivilege;

Line 2427: x_return_status := FND_API.G_RET_STS_SUCCESS;

2423: l_pk1_value number ;
2424: l_pk2_value number ;
2425: l_pk3_value number ;
2426: begin
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;
2428: for i in 1..p_batch_entities.count loop
2429: l_pk1_value := nvl(p_batch_entities(i).pk1_value, -1);
2430: l_pk2_value := nvl(p_batch_entities(i).pk2_value, -1);
2431: l_pk3_value := nvl(p_batch_entities(i).pk3_value, -1);

Line 2496: x_return_status := FND_API.G_RET_STS_ERROR;

2492: end;
2493: end if;
2494:
2495: if (not l_valid ) then
2496: x_return_status := FND_API.G_RET_STS_ERROR;
2497: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2498: ,p_module => l_module_name
2499: ,p_message => 'invalid entity data, ' || l_msg);
2500: end if;

Line 2503: if (x_return_status = FND_API.G_RET_STS_ERROR) then

2499: ,p_message => 'invalid entity data, ' || l_msg);
2500: end if;
2501: end loop;
2502:
2503: if (x_return_status = FND_API.G_RET_STS_ERROR) then
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'));

Line 2527: x_return_status := FND_API.G_RET_STS_SUCCESS;

2523: is
2524: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasMultiEntRev';
2525: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2526: begin
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_batch_entities := p_batch_entities;
2529: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2530: ,p_module => l_module_name
2531: ,p_message => 'check entity with multi-rev' );

Line 2546: x_return_status := FND_API.G_RET_STS_ERROR;

2542: ,p_message => 'item:' || l_batch_entities(i).pk1_value
2543: || ', org_id:' || l_batch_entities(i).pk2_value
2544: || ', rev_id:' || l_batch_entities(i).pk3_value
2545: || ' has another rev !!!' );
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: end if;
2548: if (p_batch_type = C_BATCH_ENTITY_VS
2549: and nvl(l_batch_entities(j).pk1_value, 0) = nvl(l_batch_entities(i).pk1_value, 0)
2550: and nvl(l_batch_entities(j).pk2_value, 0) <> nvl(l_batch_entities(i).pk2_value, 0)

Line 2557: x_return_status := FND_API.G_RET_STS_ERROR;

2553: ,p_module => l_module_name
2554: ,p_message => 'valueset:' || l_batch_entities(i).pk1_value
2555: || ', rev_id:' || l_batch_entities(i).pk2_value
2556: || ' has another rev !!!' );
2557: x_return_status := FND_API.G_RET_STS_ERROR;
2558: end if;
2559: end loop;
2560: end loop;
2561: end hasMultiEntRev;

Line 2623: x_return_status := FND_API.G_RET_STS_SUCCESS;

2619:
2620: BEGIN
2621: l_batch_id := p_batch_id;
2622: l_user_id := FND_GLOBAL.user_id;
2623: x_return_status := FND_API.G_RET_STS_SUCCESS;
2624:
2625: /*
2626: * check current user equals the batch creator, batch in draft status!!
2627: * check user has pub/sync privileges of icc/ag/vs

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

2635: from EGO_PUB_BAT_HDR_B
2636: where batch_id = p_batch_id and created_by = l_user_id;
2637: exception
2638: when no_data_found then
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'

Line 2655: x_return_status := FND_API.G_RET_STS_ERROR;

2651: from EGO_PUB_BAT_STATUS_B
2652: where batch_id = p_batch_id and STATUS_CODE = C_STATUS_DRAFT;
2653: exception
2654: when no_data_found then
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'

Line 2677: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2673: end;
2674:
2675: hasPublishPrivilege(l_user_id, p_batch_type, p_batch_entities,
2676: l_expl_date, x_return_status, x_msg_count, x_msg_data);
2677: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2678: return ;
2679: end if;
2680:
2681: end if;

Line 2887: x_return_status := FND_API.G_RET_STS_ERROR;

2883: ROLLBACK TO PUB_BAT_STATUS_CHANGE;
2884: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
2885: ,p_module => l_module_name
2886: ,p_message => ' publish failure: ' || sqlerrm);
2887: x_return_status := FND_API.G_RET_STS_ERROR;
2888: end;
2889:
2890: exception
2891: WHEN OTHERS THEN

Line 2893: x_return_status := FND_API.G_RET_STS_ERROR;

2889:
2890: exception
2891: WHEN OTHERS THEN
2892: ROLLBACK TO PUB_BAT_STATUS_CHANGE;
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
2895: ,p_module => l_module_name
2896: ,p_message => ' publish failure, general: ' || sqlerrm);
2897:

Line 2956: x_return_status := FND_API.G_RET_STS_SUCCESS;

2952: EGO_PUB_ENTITIES_NULL EXCEPTION;
2953: EGO_PUB_TARGET_SYS_NULL EXCEPTION;
2954: EGO_PUB_MUL_ENTITY_REVS EXCEPTION;
2955: BEGIN
2956: x_return_status := FND_API.G_RET_STS_SUCCESS;
2957: /*
2958: * check required parameters: name, type, work space name
2959: */
2960: if (p_batch_name is null) then

Line 3016: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3012: -- check batch parameters
3013: /*l_pub_params := p_pub_params;*/
3014: validateBatchParams(p_batch_type, p_batch_name, p_pub_params,
3015: l_pub_params, x_return_status, x_msg_count, x_msg_data);
3016: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3017: return ;
3018: end if;
3019:
3020: -- check target system valid or not

Line 3023: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3019:
3020: -- check target system valid or not
3021: validateSystems(p_target_systems, l_target_systems,
3022: x_return_status, x_msg_count, x_msg_data);
3023: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3024: return ;
3025: end if;
3026:
3027: -- initialize these local varialbes

Line 3037: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3033: l_batch_entities := removeDupEntities(p_batch_type, p_batch_entities);
3034: -- entities should be valid
3035: validateEntities(p_batch_type, l_batch_entities,
3036: x_return_status, x_msg_count, x_msg_data);
3037: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3038: return ;
3039: end if;
3040: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3041: ,P_MODULE => L_MODULE_NAME

Line 3047: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3043:
3044: -- entities with same id and different version are exception case
3045: hasMultiEntRev(p_batch_type, l_batch_entities,
3046: x_return_status, x_msg_count, x_msg_data);
3047: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3048: raise EGO_PUB_MUL_ENTITY_REVS;
3049: end if;
3050: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3051: ,p_module => l_module_name

Line 3057: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3053:
3054: l_expl_date := getExplosionDate(l_pub_params);
3055: hasPublishPrivilege(l_user_id, p_batch_type, p_batch_entities,
3056: l_expl_date, x_return_status, x_msg_count, x_msg_data);
3057: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3058: return ;
3059: end if;
3060: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3061: ,P_MODULE => L_MODULE_NAME

Line 3078: x_return_status := FND_API.G_RET_STS_SUCCESS;

3074: l_party_id := null;
3075: l_submit_date := null;
3076: end if;
3077:
3078: x_return_status := FND_API.G_RET_STS_SUCCESS;
3079: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3080: ,P_MODULE => L_MODULE_NAME
3081: ,p_message => 'x_return_status ' || x_return_status);
3082:

Line 3273: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3269: begin
3270: publish_pvt(l_batch_id, p_batch_type, p_batch_entities,
3271: l_pub_type, false, x_return_status, x_msg_count, x_msg_data);
3272:
3273: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3274: raise EGO_PUB_PUBLISH_FAILED;
3275: end if;
3276: exception
3277: when others then

Line 3283: x_return_status := FND_API.G_RET_STS_ERROR;

3279: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3280: ,p_module => l_module_name
3281: ,p_message => l_err_msg
3282: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3283: x_return_status := FND_API.G_RET_STS_ERROR;
3284: x_msg_data := l_err_msg;
3285: raise EGO_PUB_PUBLISH_FAILED;
3286: end;
3287: end if;

Line 3295: x_return_status := FND_API.G_RET_STS_ERROR;

3291:
3292: exception
3293: -- EGO_INVALID_RESPONSIBILITY_ID
3294: when EGO_PUB_BATCHNAME_NULL then
3295: x_return_status := FND_API.G_RET_STS_ERROR;
3296: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3297: ,p_module => l_module_name
3298: ,p_message => ' batch name is null'
3299: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 3308: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3319: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3320: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3321: ,p_module => l_module_name
3322: ,p_message => ' batch type is null'
3323: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 3333: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3344: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3345: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3346: ,p_module => l_module_name
3347: ,p_message => ' batch param is null'
3348: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 3358: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3369: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3380: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3391: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3403: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3404: ,p_module => l_module_name
3405: ,p_message => l_err_msg
3406: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3408: x_msg_data := l_err_msg;
3409:
3410: END Create_batch;
3411:

Line 3453: x_return_status := FND_API.G_RET_STS_SUCCESS;

3449: EGO_PUB_BATCH_NAMEIDS_INVL EXCEPTION;
3450: EGO_PUB_BATCH_NOT_CREATOR EXCEPTION;
3451: EGO_PUB_BATCH_NOT_DRAFT EXCEPTION;
3452: BEGIN
3453: x_return_status := FND_API.G_RET_STS_SUCCESS;
3454:
3455: if (p_batch_names.count = 0 and p_batch_ids.count = 0) then
3456: raise EGO_PUB_BATCH_NAMEIDS_NULL;
3457: end if;

Line 3535: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3531:
3532: publish_pvt(l_batch_id, l_batch_type, l_batch_entities,
3533: l_pub_type, true, x_return_status, x_msg_count, x_msg_data);
3534:
3535: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3536: l_failed_count := l_failed_count + 1;
3537: end if;
3538: exception
3539: when no_data_found then

Line 3554: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3557: l_invl_count := l_invl_count + 1;
3558:

Line 3566: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3569: l_invl_count := l_invl_count + 1;
3570:

Line 3600: x_return_status := FND_API.G_RET_STS_ERROR;

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
3602: ,p_msg_data => x_msg_data );
3603:
3604: when EGO_PUB_BATCH_NAMEIDS_INVL then

Line 3610: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3613:
3614: when EGO_PUB_PUBLISH_FAILED then

Line 3621: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3624:
3625: end publish_batch;

Line 3673: x_return_status := FND_API.G_RET_STS_SUCCESS;

3669: * check user has view item priv
3670: * check user has publish item priv
3671: * check the selected item rev is implemented
3672: */
3673: x_return_status := FND_API.G_RET_STS_SUCCESS;
3674:
3675: if (p_batch_id is null and p_batch_name is null) then
3676: raise EGO_PUB_BATCHNAMEID_NULL;
3677: end if;

Line 3764: x_return_status := FND_API.G_RET_STS_ERROR;

3760: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3761: ,p_module => l_module_name
3762: ,p_message => ' batch_name & id are null '
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'

Line 3778: x_return_status := FND_API.G_RET_STS_ERROR;

3774: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
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 );

Line 3789: x_return_status := FND_API.G_RET_STS_ERROR;

3785: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
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 );

Line 3801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3797: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3798: ,p_module => l_module_name
3799: ,p_message => l_err_msg
3800: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
3801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3802: x_msg_data := l_err_msg;
3803: end copy_batch;
3804:
3805: PROCEDURE delete_batch (p_api_version IN NUMBER,

Line 3834: x_return_status := FND_API.G_RET_STS_SUCCESS;

3830: begin
3831: /*
3832: * check parameter valid: names, ids
3833: */
3834: x_return_status := FND_API.G_RET_STS_SUCCESS;
3835:
3836: if (p_batch_names.count = 0
3837: and p_batch_ids.count = 0
3838: and p_purge_days is null) then

Line 3918: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3914: -- the publish history use attribute group's function name
3915: l_user_id := FND_GLOBAL.user_id;
3916: hasPublishSyncPriv(l_user_id, C_BATCH_ENTITY_AG,
3917: x_return_status, x_msg_count, x_msg_data);
3918: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3919: return ;
3920: end if;
3921:
3922: -- call purge concurrent request

Line 3952: x_return_status := FND_API.G_RET_STS_ERROR;

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
3954: ,p_msg_data => x_msg_data );
3955:
3956: when EGO_PUB_BATCH_NAMEIDS_INVL then

Line 3962: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3965:
3966: when EGO_PUB_BATCH_PURGE_CP_FAIL then

Line 3972: x_return_status := FND_API.G_RET_STS_ERROR;

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 );
3975:
3976: when others then

Line 3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3977: l_err_msg := l_err_msg || ' others error ' || sqlerrm ;
3978: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
3979: ,p_module => l_module_name
3980: ,p_message => l_err_msg);
3981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3982: x_msg_data := l_err_msg;
3983:
3984: end delete_batch;
3985: -- end of public apis