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.PSB_WRHR_EXTRACT_PROCESS dependencies on FND_MSG_PUB

Line 130: FND_MSG_PUB.initialize;

126:
127: -- Initialize message list if p_init_msg_list is set to TRUE.
128:
129: if FND_API.to_Boolean (p_init_msg_list) then
130: FND_MSG_PUB.initialize;
131: end if;
132:
133: -- Initialize API return status to success
134:

Line 197: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

193:
194: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
195: l_userid := FND_GLOBAL.USER_ID;
196:
197: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
198: p_data => l_msg_data );
199: IF l_msg_count > 0 THEN
200:
201: l_msg_data := FND_MSG_PUB.Get

Line 201: l_msg_data := FND_MSG_PUB.Get

197: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
198: p_data => l_msg_data );
199: IF l_msg_count > 0 THEN
200:
201: l_msg_data := FND_MSG_PUB.Get
202: (p_msg_index => FND_MSG_PUB.G_NEXT,
203: p_encoded => FND_API.G_FALSE);
204:
205: PSB_MESSAGE_S.INSERT_ERROR

Line 202: (p_msg_index => FND_MSG_PUB.G_NEXT,

198: p_data => l_msg_data );
199: IF l_msg_count > 0 THEN
200:
201: l_msg_data := FND_MSG_PUB.Get
202: (p_msg_index => FND_MSG_PUB.G_NEXT,
203: p_encoded => FND_API.G_FALSE);
204:
205: PSB_MESSAGE_S.INSERT_ERROR
206: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 244: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

240: end if;
241:
242: -- Standard call to get message count and if count is 1, get message info.
243:
244: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
245: p_data => p_msg_data);
246:
247: EXCEPTION
248:

Line 253: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

249: when FND_API.G_EXC_ERROR then
250:
251: p_return_status := FND_API.G_RET_STS_ERROR;
252:
253: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
254: p_data => p_msg_data);
255:
256:
257: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 261: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

257: when FND_API.G_EXC_UNEXPECTED_ERROR then
258:
259: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260:
261: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
262: p_data => p_msg_data);
263:
264:
265: when OTHERS then

Line 269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

265: when OTHERS then
266:
267: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268:
269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
270:
271: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
272: l_api_name);
273: end if;

Line 271: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

267: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268:
269: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
270:
271: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
272: l_api_name);
273: end if;
274:
275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

271: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
272: l_api_name);
273: end if;
274:
275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
276: p_data => p_msg_data);
277:
278: END Perform_Data_Extract;
279:

Line 348: FND_MSG_PUB.initialize;

344:
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346:
347: if FND_API.to_Boolean (p_init_msg_list) then
348: FND_MSG_PUB.initialize;
349: end if;
350:
351: -- Initialize API return status to success
352:

Line 435: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

431: End Loop;
432:
433: -- Standard call to get message count and if count is 1, get message info.
434:
435: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
436: p_data => p_msg_data);
437:
438: EXCEPTION
439:

Line 444: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

440: when FND_API.G_EXC_ERROR then
441:
442: p_return_status := FND_API.G_RET_STS_ERROR;
443:
444: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
445: p_data => p_msg_data);
446:
447:
448: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 452: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

448: when FND_API.G_EXC_UNEXPECTED_ERROR then
449:
450: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
453: p_data => p_msg_data);
454:
455:
456: when OTHERS then

Line 460: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

456: when OTHERS then
457:
458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
461:
462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
463: l_api_name);
464: end if;

Line 462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459:
460: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
461:
462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
463: l_api_name);
464: end if;
465:
466: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 466: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
463: l_api_name);
464: end if;
465:
466: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
467: p_data => p_msg_data);
468:
469:
470: End Interface_Purge;

Line 518: FND_MSG_PUB.initialize;

514:
515: -- Initialize message list if p_init_msg_list is set to TRUE.
516:
517: if FND_API.to_Boolean (p_init_msg_list) then
518: FND_MSG_PUB.initialize;
519: end if;
520:
521: -- Initialize API return status to success
522:

Line 576: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

572: END IF;
573:
574: -- Standard call to get message count and if count is 1, get message info.
575:
576: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
577: p_data => p_msg_data);
578: COMMIT WORK;
579:
580: EXCEPTION

Line 585: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

581: when FND_API.G_EXC_ERROR then
582:
583: p_return_status := FND_API.G_RET_STS_ERROR;
584:
585: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
586: p_data => p_msg_data);
587:
588:
589: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 593: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

589: when FND_API.G_EXC_UNEXPECTED_ERROR then
590:
591: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592:
593: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
594: p_data => p_msg_data);
595:
596:
597: when OTHERS then

Line 601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

597: when OTHERS then
598:
599: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
602:
603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: end if;

Line 603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

599: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
602:
603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: end if;
606:
607: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 607: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

603: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
604: l_api_name);
605: end if;
606:
607: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
608: p_data => p_msg_data);
609:
610:
611: End insert_organizations;

Line 751: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

747: p_concurrency_entity_name => 'DATA_EXTRACT',
748: p_concurrency_entity_id => p_data_extract_id);
749:
750: --
751: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
752: --
753: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
754: l_api_name ) ;
755: END IF ;

Line 753: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

749:
750: --
751: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
752: --
753: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
754: l_api_name ) ;
755: END IF ;
756: --
757: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,

Line 928: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

924: p_concurrency_entity_name => 'DATA_EXTRACT',
925: p_concurrency_entity_id => p_data_extract_id);
926:
927: --
928: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
929: --
930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
931: l_api_name ) ;
932: END IF ;

Line 930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

926:
927: --
928: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
929: --
930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
931: l_api_name ) ;
932: END IF ;
933: --
934: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.LOG,

Line 988: FND_MSG_PUB.Add;

984: end loop;
985:
986: end if;
987:
988: FND_MSG_PUB.Add;
989:
990: end if;
991:
992: -- Clear Message Token stack

Line 1104: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1100: when FND_API.G_EXC_ERROR then
1101:
1102: p_return_status := FND_API.G_RET_STS_ERROR;
1103:
1104: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1105: p_data => p_msg_data);
1106:
1107:
1108: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1112: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1108: when FND_API.G_EXC_UNEXPECTED_ERROR then
1109:
1110: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1111:
1112: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1113: p_data => p_msg_data);
1114:
1115:
1116: when OTHERS then

Line 1120: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1116: when OTHERS then
1117:
1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119:
1120: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1121:
1122: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1123: l_api_name);
1124: end if;

Line 1122: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119:
1120: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1121:
1122: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1123: l_api_name);
1124: end if;
1125:
1126: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1126: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1122: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1123: l_api_name);
1124: end if;
1125:
1126: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1127: p_data => p_msg_data);
1128:
1129: --
1130: End Pre_Create_Data_Extract;

Line 1166: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1162: end if;
1163:
1164: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
1165:
1166: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1167: p_data => l_msg_data );
1168: IF l_msg_count > 0 THEN
1169:
1170: l_msg_data := FND_MSG_PUB.Get

Line 1170: l_msg_data := FND_MSG_PUB.Get

1166: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1167: p_data => l_msg_data );
1168: IF l_msg_count > 0 THEN
1169:
1170: l_msg_data := FND_MSG_PUB.Get
1171: (p_msg_index => FND_MSG_PUB.G_NEXT,
1172: p_encoded => FND_API.G_FALSE);
1173:
1174: PSB_MESSAGE_S.INSERT_ERROR

Line 1171: (p_msg_index => FND_MSG_PUB.G_NEXT,

1167: p_data => l_msg_data );
1168: IF l_msg_count > 0 THEN
1169:
1170: l_msg_data := FND_MSG_PUB.Get
1171: (p_msg_index => FND_MSG_PUB.G_NEXT,
1172: p_encoded => FND_API.G_FALSE);
1173:
1174: PSB_MESSAGE_S.INSERT_ERROR
1175: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1202: --
1203: WHEN OTHERS THEN
1204:
1205: --
1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1207: --
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1209: l_api_name ) ;
1210: END IF ;

Line 1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1204:
1205: --
1206: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1207: --
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1209: l_api_name ) ;
1210: END IF ;
1211: --
1212: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1299: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1295:
1296: end if;
1297: end if;
1298:
1299: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1300: p_data => l_msg_data );
1301: IF l_msg_count > 0 THEN
1302:
1303: l_msg_data := FND_MSG_PUB.Get

Line 1303: l_msg_data := FND_MSG_PUB.Get

1299: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1300: p_data => l_msg_data );
1301: IF l_msg_count > 0 THEN
1302:
1303: l_msg_data := FND_MSG_PUB.Get
1304: (p_msg_index => FND_MSG_PUB.G_NEXT,
1305: p_encoded => FND_API.G_FALSE);
1306:
1307: PSB_MESSAGE_S.INSERT_ERROR

Line 1304: (p_msg_index => FND_MSG_PUB.G_NEXT,

1300: p_data => l_msg_data );
1301: IF l_msg_count > 0 THEN
1302:
1303: l_msg_data := FND_MSG_PUB.Get
1304: (p_msg_index => FND_MSG_PUB.G_NEXT,
1305: p_encoded => FND_API.G_FALSE);
1306:
1307: PSB_MESSAGE_S.INSERT_ERROR
1308: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1336: --
1337: WHEN OTHERS THEN
1338:
1339: --
1340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1341: --
1342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1343: l_api_name ) ;
1344: END IF ;

Line 1342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1338:
1339: --
1340: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1341: --
1342: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1343: l_api_name ) ;
1344: END IF ;
1345: --
1346: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1426: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1422:
1423: end if;
1424: end if;
1425:
1426: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1427: p_data => l_msg_data );
1428: IF l_msg_count > 0 THEN
1429:
1430: l_msg_data := FND_MSG_PUB.Get

Line 1430: l_msg_data := FND_MSG_PUB.Get

1426: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1427: p_data => l_msg_data );
1428: IF l_msg_count > 0 THEN
1429:
1430: l_msg_data := FND_MSG_PUB.Get
1431: (p_msg_index => FND_MSG_PUB.G_NEXT,
1432: p_encoded => FND_API.G_FALSE);
1433:
1434: PSB_MESSAGE_S.INSERT_ERROR

Line 1431: (p_msg_index => FND_MSG_PUB.G_NEXT,

1427: p_data => l_msg_data );
1428: IF l_msg_count > 0 THEN
1429:
1430: l_msg_data := FND_MSG_PUB.Get
1431: (p_msg_index => FND_MSG_PUB.G_NEXT,
1432: p_encoded => FND_API.G_FALSE);
1433:
1434: PSB_MESSAGE_S.INSERT_ERROR
1435: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1464: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1460: --
1461: WHEN OTHERS THEN
1462:
1463: --
1464: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1465: --
1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1467: l_api_name ) ;
1468: END IF ;

Line 1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1462:
1463: --
1464: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1465: --
1466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1467: l_api_name ) ;
1468: END IF ;
1469: --
1470: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1548: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1544:
1545: end if;
1546: end if;
1547:
1548: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1549: p_data => l_msg_data );
1550: IF l_msg_count > 0 THEN
1551:
1552: l_msg_data := FND_MSG_PUB.Get

Line 1552: l_msg_data := FND_MSG_PUB.Get

1548: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1549: p_data => l_msg_data );
1550: IF l_msg_count > 0 THEN
1551:
1552: l_msg_data := FND_MSG_PUB.Get
1553: (p_msg_index => FND_MSG_PUB.G_NEXT,
1554: p_encoded => FND_API.G_FALSE);
1555:
1556: PSB_MESSAGE_S.INSERT_ERROR

Line 1553: (p_msg_index => FND_MSG_PUB.G_NEXT,

1549: p_data => l_msg_data );
1550: IF l_msg_count > 0 THEN
1551:
1552: l_msg_data := FND_MSG_PUB.Get
1553: (p_msg_index => FND_MSG_PUB.G_NEXT,
1554: p_encoded => FND_API.G_FALSE);
1555:
1556: PSB_MESSAGE_S.INSERT_ERROR
1557: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1582: --
1583: WHEN OTHERS THEN
1584:
1585: --
1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1587: --
1588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1589: l_api_name ) ;
1590: END IF ;

Line 1588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1584:
1585: --
1586: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1587: --
1588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1589: l_api_name ) ;
1590: END IF ;
1591: --
1592: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1670: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1666: end if;
1667: end if;
1668: end if;
1669:
1670: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1671: p_data => l_msg_data );
1672: IF l_msg_count > 0 THEN
1673:
1674: l_msg_data := FND_MSG_PUB.Get

Line 1674: l_msg_data := FND_MSG_PUB.Get

1670: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1671: p_data => l_msg_data );
1672: IF l_msg_count > 0 THEN
1673:
1674: l_msg_data := FND_MSG_PUB.Get
1675: (p_msg_index => FND_MSG_PUB.G_NEXT,
1676: p_encoded => FND_API.G_FALSE);
1677:
1678: PSB_MESSAGE_S.INSERT_ERROR

Line 1675: (p_msg_index => FND_MSG_PUB.G_NEXT,

1671: p_data => l_msg_data );
1672: IF l_msg_count > 0 THEN
1673:
1674: l_msg_data := FND_MSG_PUB.Get
1675: (p_msg_index => FND_MSG_PUB.G_NEXT,
1676: p_encoded => FND_API.G_FALSE);
1677:
1678: PSB_MESSAGE_S.INSERT_ERROR
1679: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1703: --
1704: WHEN OTHERS THEN
1705:
1706: --
1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1708: --
1709: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1710: l_api_name ) ;
1711: END IF ;

Line 1709: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1705:
1706: --
1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1708: --
1709: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1710: l_api_name ) ;
1711: END IF ;
1712: --
1713: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1851: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

1847: end if;
1848:
1849: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
1850:
1851: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1852: p_data => l_msg_data );
1853: IF l_msg_count > 0 THEN
1854:
1855: l_msg_data := FND_MSG_PUB.Get

Line 1855: l_msg_data := FND_MSG_PUB.Get

1851: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
1852: p_data => l_msg_data );
1853: IF l_msg_count > 0 THEN
1854:
1855: l_msg_data := FND_MSG_PUB.Get
1856: (p_msg_index => FND_MSG_PUB.G_NEXT,
1857: p_encoded => FND_API.G_FALSE);
1858:
1859: PSB_MESSAGE_S.INSERT_ERROR

Line 1856: (p_msg_index => FND_MSG_PUB.G_NEXT,

1852: p_data => l_msg_data );
1853: IF l_msg_count > 0 THEN
1854:
1855: l_msg_data := FND_MSG_PUB.Get
1856: (p_msg_index => FND_MSG_PUB.G_NEXT,
1857: p_encoded => FND_API.G_FALSE);
1858:
1859: PSB_MESSAGE_S.INSERT_ERROR
1860: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 1890: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1886: --
1887: WHEN OTHERS THEN
1888:
1889: --
1890: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1891: --
1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1893: l_api_name ) ;
1894: END IF ;

Line 1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1888:
1889: --
1890: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1891: --
1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1893: l_api_name ) ;
1894: END IF ;
1895: --
1896:

Line 2034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2030: end if;
2031:
2032:
2033: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2035: p_data => l_msg_data );
2036: IF l_msg_count > 0 THEN
2037:
2038: l_msg_data := FND_MSG_PUB.Get

Line 2038: l_msg_data := FND_MSG_PUB.Get

2034: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2035: p_data => l_msg_data );
2036: IF l_msg_count > 0 THEN
2037:
2038: l_msg_data := FND_MSG_PUB.Get
2039: (p_msg_index => FND_MSG_PUB.G_NEXT,
2040: p_encoded => FND_API.G_FALSE);
2041:
2042: PSB_MESSAGE_S.INSERT_ERROR

Line 2039: (p_msg_index => FND_MSG_PUB.G_NEXT,

2035: p_data => l_msg_data );
2036: IF l_msg_count > 0 THEN
2037:
2038: l_msg_data := FND_MSG_PUB.Get
2039: (p_msg_index => FND_MSG_PUB.G_NEXT,
2040: p_encoded => FND_API.G_FALSE);
2041:
2042: PSB_MESSAGE_S.INSERT_ERROR
2043: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2058: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2054: EXCEPTION
2055:
2056: WHEN FND_API.G_EXC_ERROR THEN
2057: --
2058: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2059: p_data => l_msg_data );
2060: IF l_msg_count > 0 THEN
2061:
2062: l_msg_data := FND_MSG_PUB.Get

Line 2062: l_msg_data := FND_MSG_PUB.Get

2058: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2059: p_data => l_msg_data );
2060: IF l_msg_count > 0 THEN
2061:
2062: l_msg_data := FND_MSG_PUB.Get
2063: (p_msg_index => FND_MSG_PUB.G_NEXT,
2064: p_encoded => FND_API.G_FALSE);
2065:
2066: PSB_MESSAGE_S.INSERT_ERROR

Line 2063: (p_msg_index => FND_MSG_PUB.G_NEXT,

2059: p_data => l_msg_data );
2060: IF l_msg_count > 0 THEN
2061:
2062: l_msg_data := FND_MSG_PUB.Get
2063: (p_msg_index => FND_MSG_PUB.G_NEXT,
2064: p_encoded => FND_API.G_FALSE);
2065:
2066: PSB_MESSAGE_S.INSERT_ERROR
2067: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2089: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2085: --
2086: WHEN OTHERS THEN
2087:
2088: --
2089: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2090: --
2091: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2092: l_api_name ) ;
2093: END IF ;

Line 2091: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2087:
2088: --
2089: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2090: --
2091: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2092: l_api_name ) ;
2093: END IF ;
2094: --
2095:

Line 2233: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2229: end if;
2230:
2231:
2232: PSB_HR_EXTRACT_DATA_PVT.Final_Process;
2233: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2234: p_data => l_msg_data );
2235: IF l_msg_count > 0 THEN
2236:
2237: l_msg_data := FND_MSG_PUB.Get

Line 2237: l_msg_data := FND_MSG_PUB.Get

2233: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2234: p_data => l_msg_data );
2235: IF l_msg_count > 0 THEN
2236:
2237: l_msg_data := FND_MSG_PUB.Get
2238: (p_msg_index => FND_MSG_PUB.G_NEXT,
2239: p_encoded => FND_API.G_FALSE);
2240:
2241: PSB_MESSAGE_S.INSERT_ERROR

Line 2238: (p_msg_index => FND_MSG_PUB.G_NEXT,

2234: p_data => l_msg_data );
2235: IF l_msg_count > 0 THEN
2236:
2237: l_msg_data := FND_MSG_PUB.Get
2238: (p_msg_index => FND_MSG_PUB.G_NEXT,
2239: p_encoded => FND_API.G_FALSE);
2240:
2241: PSB_MESSAGE_S.INSERT_ERROR
2242: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2271: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2267: --
2268: WHEN OTHERS THEN
2269:
2270: --
2271: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2272: --
2273: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2274: l_api_name ) ;
2275: END IF ;

Line 2273: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2269:
2270: --
2271: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2272: --
2273: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2274: l_api_name ) ;
2275: END IF ;
2276: --
2277:

Line 2415: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2411: end if;
2412: end if;
2413: end if;
2414:
2415: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2416: p_data => l_msg_data );
2417: IF l_msg_count > 0 THEN
2418:
2419: l_msg_data := FND_MSG_PUB.Get

Line 2419: l_msg_data := FND_MSG_PUB.Get

2415: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2416: p_data => l_msg_data );
2417: IF l_msg_count > 0 THEN
2418:
2419: l_msg_data := FND_MSG_PUB.Get
2420: (p_msg_index => FND_MSG_PUB.G_NEXT,
2421: p_encoded => FND_API.G_FALSE);
2422:
2423: PSB_MESSAGE_S.INSERT_ERROR

Line 2420: (p_msg_index => FND_MSG_PUB.G_NEXT,

2416: p_data => l_msg_data );
2417: IF l_msg_count > 0 THEN
2418:
2419: l_msg_data := FND_MSG_PUB.Get
2420: (p_msg_index => FND_MSG_PUB.G_NEXT,
2421: p_encoded => FND_API.G_FALSE);
2422:
2423: PSB_MESSAGE_S.INSERT_ERROR
2424: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2440: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2436: EXCEPTION
2437:
2438: WHEN FND_API.G_EXC_ERROR THEN
2439: --
2440: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2441: p_data => l_msg_data );
2442: IF l_msg_count > 0 THEN
2443:
2444: l_msg_data := FND_MSG_PUB.Get

Line 2444: l_msg_data := FND_MSG_PUB.Get

2440: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2441: p_data => l_msg_data );
2442: IF l_msg_count > 0 THEN
2443:
2444: l_msg_data := FND_MSG_PUB.Get
2445: (p_msg_index => FND_MSG_PUB.G_NEXT,
2446: p_encoded => FND_API.G_FALSE);
2447:
2448: PSB_MESSAGE_S.INSERT_ERROR

Line 2445: (p_msg_index => FND_MSG_PUB.G_NEXT,

2441: p_data => l_msg_data );
2442: IF l_msg_count > 0 THEN
2443:
2444: l_msg_data := FND_MSG_PUB.Get
2445: (p_msg_index => FND_MSG_PUB.G_NEXT,
2446: p_encoded => FND_API.G_FALSE);
2447:
2448: PSB_MESSAGE_S.INSERT_ERROR
2449: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2466: --
2467: WHEN OTHERS THEN
2468:
2469: --
2470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2471: --
2472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2473: l_api_name ) ;
2474: END IF ;

Line 2472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2468:
2469: --
2470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2471: --
2472: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2473: l_api_name ) ;
2474: END IF ;
2475: --
2476:

Line 2545: FND_MSG_PUB.Initialize;

2541: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2542: p_print_header => FND_API.G_TRUE );
2543: /* Bug 3677529 End */
2544: FND_FILE.put_line(FND_FILE.LOG,'Get Cost Distributions Failed');
2545: FND_MSG_PUB.Initialize;
2546: end if;
2547:
2548: PSB_DE_Client_Extensions_Pub.Run_Client_Extension_Pub
2549: ( p_api_version => 1.0,

Line 2613: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2609: end if;
2610: end if;
2611: end if;
2612:
2613: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2614: p_data => l_msg_data );
2615: IF l_msg_count > 0 THEN
2616:
2617: l_msg_data := FND_MSG_PUB.Get

Line 2617: l_msg_data := FND_MSG_PUB.Get

2613: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2614: p_data => l_msg_data );
2615: IF l_msg_count > 0 THEN
2616:
2617: l_msg_data := FND_MSG_PUB.Get
2618: (p_msg_index => FND_MSG_PUB.G_NEXT,
2619: p_encoded => FND_API.G_FALSE);
2620:
2621: PSB_MESSAGE_S.INSERT_ERROR

Line 2618: (p_msg_index => FND_MSG_PUB.G_NEXT,

2614: p_data => l_msg_data );
2615: IF l_msg_count > 0 THEN
2616:
2617: l_msg_data := FND_MSG_PUB.Get
2618: (p_msg_index => FND_MSG_PUB.G_NEXT,
2619: p_encoded => FND_API.G_FALSE);
2620:
2621: PSB_MESSAGE_S.INSERT_ERROR
2622: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2650: --
2651: WHEN OTHERS THEN
2652:
2653: --
2654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2655: --
2656: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2657: l_api_name ) ;
2658: END IF ;

Line 2656: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2652:
2653: --
2654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2655: --
2656: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2657: l_api_name ) ;
2658: END IF ;
2659: --
2660:

Line 2791: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2787: end if;
2788: end if;
2789:
2790:
2791: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2792: p_data => l_msg_data );
2793: IF l_msg_count > 0 THEN
2794:
2795: l_msg_data := FND_MSG_PUB.Get

Line 2795: l_msg_data := FND_MSG_PUB.Get

2791: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2792: p_data => l_msg_data );
2793: IF l_msg_count > 0 THEN
2794:
2795: l_msg_data := FND_MSG_PUB.Get
2796: (p_msg_index => FND_MSG_PUB.G_NEXT,
2797: p_encoded => FND_API.G_FALSE);
2798:
2799: PSB_MESSAGE_S.INSERT_ERROR

Line 2796: (p_msg_index => FND_MSG_PUB.G_NEXT,

2792: p_data => l_msg_data );
2793: IF l_msg_count > 0 THEN
2794:
2795: l_msg_data := FND_MSG_PUB.Get
2796: (p_msg_index => FND_MSG_PUB.G_NEXT,
2797: p_encoded => FND_API.G_FALSE);
2798:
2799: PSB_MESSAGE_S.INSERT_ERROR
2800: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2831: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2827: --
2828: WHEN OTHERS THEN
2829:
2830: --
2831: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2832: --
2833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2834: l_api_name ) ;
2835: END IF ;

Line 2833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2829:
2830: --
2831: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2832: --
2833: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2834: l_api_name ) ;
2835: END IF ;
2836: --
2837:

Line 2912: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2908: FND_FILE.put_line(FND_FILE.LOG,'Validate Data Extract failed');
2909: end if;
2910: end if;
2911:
2912: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2913: p_data => l_msg_data );
2914: IF l_msg_count > 0 THEN
2915:
2916: l_msg_data := FND_MSG_PUB.Get

Line 2916: l_msg_data := FND_MSG_PUB.Get

2912: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2913: p_data => l_msg_data );
2914: IF l_msg_count > 0 THEN
2915:
2916: l_msg_data := FND_MSG_PUB.Get
2917: (p_msg_index => FND_MSG_PUB.G_NEXT,
2918: p_encoded => FND_API.G_FALSE);
2919:
2920: PSB_MESSAGE_S.INSERT_ERROR

Line 2917: (p_msg_index => FND_MSG_PUB.G_NEXT,

2913: p_data => l_msg_data );
2914: IF l_msg_count > 0 THEN
2915:
2916: l_msg_data := FND_MSG_PUB.Get
2917: (p_msg_index => FND_MSG_PUB.G_NEXT,
2918: p_encoded => FND_API.G_FALSE);
2919:
2920: PSB_MESSAGE_S.INSERT_ERROR
2921: (p_source_process => 'DATA_EXTRACT_VALIDATION',

Line 2977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2973: --
2974: WHEN OTHERS THEN
2975:
2976: --
2977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2978: --
2979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2980: l_api_name ) ;
2981: END IF ;

Line 2979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

2975:
2976: --
2977: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2978: --
2979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
2980: l_api_name ) ;
2981: END IF ;
2982: --
2983:

Line 3278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3274: --
3275: WHEN OTHERS THEN
3276:
3277: --
3278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3279: --
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3281: l_api_name ) ;
3282: END IF ;

Line 3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

3276:
3277: --
3278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3279: --
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
3281: l_api_name ) ;
3282: END IF ;
3283: --
3284:

Line 3360: FND_MSG_PUB.initialize ;

3356: p_request_id := 0; -- Bug #4451621
3357:
3358: IF FND_API.to_Boolean ( p_init_msg_list )
3359: THEN
3360: FND_MSG_PUB.initialize ;
3361: END IF;
3362:
3363: FOR c_data_extract_org_rec IN c_data_extract_org LOOP
3364: l_extract_by_org := c_data_extract_org_rec.extract_by_org;

Line 3373: FND_MSG_PUB.Add;

3369: IF NOT(l_success)
3370: THEN
3371: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3372: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set_Request_Set Failed');
3373: FND_MSG_PUB.Add;
3374:
3375: RAISE FND_API.G_EXC_ERROR; -- Bug #4451621
3376: END IF;
3377:

Line 3394: FND_MSG_PUB.Add;

3390: IF ( NOT l_success )
3391: THEN
3392: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3393: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 1 failed');
3394: FND_MSG_PUB.Add;
3395: END IF;
3396:
3397: /* submit program PSBCPCDA which is in stage ST2 */
3398: l_success := fnd_submit.submit_program

Line 3414: FND_MSG_PUB.Add;

3410: IF ( NOT l_success )
3411: THEN
3412: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3413: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 2 failed');
3414: FND_MSG_PUB.Add;
3415: END IF;
3416:
3417: /* submit program PSBCPCDE which is in stage ST2 */
3418: l_success := fnd_submit.submit_program

Line 3434: FND_MSG_PUB.Add;

3430:
3431: IF ( NOT l_success ) THEN
3432: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3433: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 2 failed');
3434: FND_MSG_PUB.Add;
3435: END IF;
3436:
3437: /* submit program PSBCPCPS which is in stage ST3 */
3438: l_success := fnd_submit.submit_program

Line 3454: FND_MSG_PUB.Add;

3450: IF ( NOT l_success )
3451: THEN
3452: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3453: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 3 failed');
3454: FND_MSG_PUB.Add;
3455: END IF;
3456:
3457: /* submit program PSBCPSAL which is in stage ST5 */
3458: l_success := fnd_submit.submit_program

Line 3478: FND_MSG_PUB.Add;

3474: IF ( NOT l_success )
3475: THEN
3476: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3477: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 5 failed');
3478: FND_MSG_PUB.Add;
3479: END IF;
3480:
3481: /* submit program PSBCPATT which is in stage ST5 */
3482: l_success := fnd_submit.submit_program

Line 3502: FND_MSG_PUB.Add;

3498: IF ( NOT l_success )
3499: THEN
3500: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3501: FND_MESSAGE.SET_TOKEN('MESSAGE', '2ndprogram in Stage 5 failed');
3502: FND_MSG_PUB.Add;
3503: END IF;
3504:
3505: /* submit program PSBCPPOS which is in stage ST5 */
3506: l_success := fnd_submit.submit_program

Line 3528: FND_MSG_PUB.Add;

3524: IF ( NOT l_success )
3525: THEN
3526: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3527: FND_MESSAGE.SET_TOKEN('MESSAGE', '3rd program in Stage 5 failed');
3528: FND_MSG_PUB.Add;
3529: END IF;
3530:
3531: /* submit program PSBCPEMP which is in stage ST6 */
3532: l_success := fnd_submit.submit_program

Line 3556: FND_MSG_PUB.Add;

3552: IF ( NOT l_success )
3553: THEN
3554: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3555: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 6 failed');
3556: FND_MSG_PUB.Add;
3557: END IF;
3558:
3559: /* submit program PSBCPDIS which is in stage ST7 */
3560: l_success := fnd_submit.submit_program

Line 3581: FND_MSG_PUB.Add;

3577: IF ( NOT l_success )
3578: THEN
3579: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3580: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 7 failed');
3581: FND_MSG_PUB.Add;
3582: END IF;
3583:
3584:
3585: /* submit program PSBCPEAA which is in stage ST7 */

Line 3607: FND_MSG_PUB.Add;

3603: IF ( NOT l_success )
3604: THEN
3605: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3606: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 7 failed');
3607: FND_MSG_PUB.Add;
3608: END IF;
3609:
3610: /* Bug 4179764 Start */
3611: /* submit program PSBCPCDR which is in stage ST4 */

Line 3628: FND_MSG_PUB.Add;

3624: IF ( NOT l_success )
3625: THEN
3626: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3627: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 4 failed');
3628: FND_MSG_PUB.Add;
3629: END IF;
3630:
3631: /* Bug 4179764 End */
3632: /* submit program PSBCPVDE which is in stage ST8 */

Line 3650: FND_MSG_PUB.Add;

3646: IF ( NOT l_success )
3647: THEN
3648: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3649: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 8 failed');
3650: FND_MSG_PUB.Add;
3651: END IF;
3652:
3653:
3654: -- Bug 4683895: Always call Assign_Position_Defaults_CP.

Line 3672: FND_MSG_PUB.Add;

3668: IF ( NOT l_success )
3669: THEN
3670: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3671: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 9 failed');
3672: FND_MSG_PUB.Add;
3673: END IF;
3674:
3675: /* submit program PSBCPFPD which is in stage ST10 */
3676: l_success := fnd_submit.submit_program

Line 3692: FND_MSG_PUB.Add;

3688: IF ( NOT l_success )
3689: THEN
3690: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3691: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 10 failed');
3692: FND_MSG_PUB.Add;
3693: END IF;
3694:
3695: /* Submit the Request set */
3696: l_request_id := fnd_submit.submit_set(NULL, FALSE);

Line 3703: FND_MSG_PUB.Add;

3699: IF (l_request_id = 0)
3700: THEN
3701: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3702: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set Submission Failed');
3703: FND_MSG_PUB.Add;
3704: END IF;
3705:
3706: END IF; -- SET_REQUEST_SET Successful.
3707:

Line 3712: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,

3708: EXCEPTION
3709:
3710: WHEN FND_API.G_EXC_ERROR THEN
3711: P_return_status := FND_API.G_RET_STS_ERROR;
3712: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,
3713: p_data => P_msg_data);
3714:
3715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3716: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3717: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,

3713: p_data => P_msg_data);
3714:
3715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3716: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3717: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,
3718: p_data => P_msg_data);
3719:
3720: WHEN OTHERS THEN
3721:

Line 3724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3720: WHEN OTHERS THEN
3721:
3722: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3723:
3724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3725: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3726: l_api_name);
3727: END IF;
3728:

Line 3725: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

3721:
3722: P_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3723:
3724: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3725: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3726: l_api_name);
3727: END IF;
3728:
3729: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,

Line 3729: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,

3725: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3726: l_api_name);
3727: END IF;
3728:
3729: FND_MSG_PUB.Count_And_Get (p_count => P_msg_count,
3730: p_data => P_msg_data);
3731:
3732: END Submit_Data_Extract;
3733:

Line 3782: FND_MSG_PUB.initialize;

3778: END IF;
3779:
3780: -- check whether we need to initialize message list
3781: IF FND_API.to_boolean(x_msg_init_list) THEN
3782: FND_MSG_PUB.initialize;
3783: END IF;
3784:
3785: SAVEPOINT create_default_rule_set;
3786:

Line 3802: FND_MSG_PUB.ADD;

3798: --in case the name is already in use, abort the process and report the
3799: --user through the logs generated
3800: IF l_name_already_exist > 0 THEN
3801: FND_MESSAGE.SET_NAME('PSB', 'PSB_DUPLICATE_NAME');
3802: FND_MSG_PUB.ADD;
3803: RAISE FND_API.G_EXC_ERROR;
3804: END IF;
3805:
3806: --get a new PSB_ENTITY_SET_ID for the new rule set

Line 3900: FND_MSG_PUB.Count_And_Get

3896: EXCEPTION
3897: WHEN FND_API.G_EXC_ERROR THEN
3898: ROLLBACK TO create_default_rule_set;
3899: x_return_status := FND_API.G_RET_STS_ERROR;
3900: FND_MSG_PUB.Count_And_Get
3901: ( p_count => x_msg_count,
3902: p_data => x_msg_data
3903: );
3904:

Line 3908: FND_MSG_PUB.Count_And_Get

3904:
3905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3906: ROLLBACK TO create_default_rule_set;
3907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3908: FND_MSG_PUB.Count_And_Get
3909: ( p_count => x_msg_count,
3910: p_data => x_msg_data
3911: );
3912:

Line 3916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3912:
3913: WHEN OTHERS THEN
3914: ROLLBACK TO create_default_rule_set;
3915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3917: FND_MSG_PUB.Add_Exc_Msg
3918: ( G_PKG_NAME,
3919: l_api_name
3920: );

Line 3917: FND_MSG_PUB.Add_Exc_Msg

3913: WHEN OTHERS THEN
3914: ROLLBACK TO create_default_rule_set;
3915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3917: FND_MSG_PUB.Add_Exc_Msg
3918: ( G_PKG_NAME,
3919: l_api_name
3920: );
3921: END IF;

Line 3923: FND_MSG_PUB.Count_And_Get

3919: l_api_name
3920: );
3921: END IF;
3922:
3923: FND_MSG_PUB.Count_And_Get
3924: ( p_count => x_msg_count,
3925: p_data => x_msg_data
3926: );
3927: END Create_Default_Rule_Set;

Line 3978: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

3974: );
3975: retcode := 2;
3976:
3977: WHEN OTHERS THEN
3978: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3979: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3980: end if;
3981:
3982: PSB_MESSAGE_S.Print_Error

Line 3979: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3975: retcode := 2;
3976:
3977: WHEN OTHERS THEN
3978: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3979: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3980: end if;
3981:
3982: PSB_MESSAGE_S.Print_Error
3983: ( p_mode => FND_FILE.LOG,