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

Line 70: FND_MSG_PUB.initialize;

66: END IF;
67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize;
71: END IF;
72:
73: IF (lc_proc_level >= lc_debug_level) THEN
74: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 355: FND_MSG_PUB.Count_And_Get

351: COMMIT WORK;
352: END IF;
353:
354: -- Standard call to get message count and IF count is get message info.
355: FND_MSG_PUB.Count_And_Get
356: (p_count => x_msg_count,
357: p_data => x_msg_data );
358:
359: IF (lc_proc_level >= lc_debug_level) THEN

Line 378: FND_MSG_PUB.Add;

374: 'Adding message CSD_SCW_ENTITY_EXISTS to FND_MSG stack');
375: end if;
376: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
377: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);
378: FND_MSG_PUB.Add;
379:
380: FND_MSG_PUB.Count_And_Get
381: (p_count => x_msg_count,
382: p_data => x_msg_data );

Line 380: FND_MSG_PUB.Count_And_Get

376: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
377: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);
378: FND_MSG_PUB.Add;
379:
380: FND_MSG_PUB.Count_And_Get
381: (p_count => x_msg_count,
382: p_data => x_msg_data );
383:
384: -- save message in debug log

Line 403: FND_MSG_PUB.Add;

399: 'Adding message CSD_SCW_INVALID_ORGANIZATION to FND_MSG stack');
400: end if;
401: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
402: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);
403: FND_MSG_PUB.Add;
404:
405: FND_MSG_PUB.Count_And_Get
406: (p_count => x_msg_count,
407: p_data => x_msg_data );

Line 405: FND_MSG_PUB.Count_And_Get

401: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
402: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);
403: FND_MSG_PUB.Add;
404:
405: FND_MSG_PUB.Count_And_Get
406: (p_count => x_msg_count,
407: p_data => x_msg_data );
408:
409: -- save message in debug log

Line 428: FND_MSG_PUB.Add;

424: 'Adding message CSD_SCW_INVALID_BILL_SEQUENCE to FND_MSG stack');
425: end if;
426: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
427: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);
428: FND_MSG_PUB.Add;
429:
430: FND_MSG_PUB.Count_And_Get
431: (p_count => x_msg_count,
432: p_data => x_msg_data );

Line 430: FND_MSG_PUB.Count_And_Get

426: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
427: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);
428: FND_MSG_PUB.Add;
429:
430: FND_MSG_PUB.Count_And_Get
431: (p_count => x_msg_count,
432: p_data => x_msg_data );
433:
434: -- save message in debug log

Line 453: FND_MSG_PUB.Add;

449: 'Adding message CSD_SCW_INVALID_ROUTE_SEQUENCE to FND_MSG stack');
450: end if;
451: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
452: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);
453: FND_MSG_PUB.Add;
454:
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count,
457: p_data => x_msg_data );

Line 455: FND_MSG_PUB.Count_And_Get

451: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
452: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);
453: FND_MSG_PUB.Add;
454:
455: FND_MSG_PUB.Count_And_Get
456: (p_count => x_msg_count,
457: p_data => x_msg_data );
458:
459: -- save message in debug log

Line 478: FND_MSG_PUB.Add;

474: 'Adding message CSD_SCW_INVALID_TASK_TEMP_GRP to FND_MSG stack');
475: end if;
476: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
477: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);
478: FND_MSG_PUB.Add;
479:
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data );

Line 480: FND_MSG_PUB.Count_And_Get

476: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
477: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);
478: FND_MSG_PUB.Add;
479:
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data );
483:
484: -- save message in debug log

Line 495: FND_MSG_PUB.Count_And_Get

491: ROLLBACK TO Create_SC_Work_Entity;
492:
493: x_return_status := FND_API.G_RET_STS_ERROR;
494:
495: FND_MSG_PUB.Count_And_Get
496: (p_count => x_msg_count,
497: p_data => x_msg_data );
498:
499: -- save message in debug log

Line 510: IF FND_MSG_PUB.Check_Msg_Level

506: ROLLBACK TO Create_SC_Work_Entity;
507:
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509:
510: IF FND_MSG_PUB.Check_Msg_Level
511: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: if (lc_stat_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 511: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

507:
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509:
510: IF FND_MSG_PUB.Check_Msg_Level
511: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: if (lc_stat_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_stat_level, lc_mod_name,
515: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 515: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

511: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: if (lc_stat_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_stat_level, lc_mod_name,
515: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
516: end if;
517: FND_MSG_PUB.Add_Exc_Msg
518: (G_PKG_NAME ,
519: lc_api_name );

Line 517: FND_MSG_PUB.Add_Exc_Msg

513: if (lc_stat_level >= lc_debug_level) then
514: FND_LOG.STRING(lc_stat_level, lc_mod_name,
515: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
516: end if;
517: FND_MSG_PUB.Add_Exc_Msg
518: (G_PKG_NAME ,
519: lc_api_name );
520: END IF;
521:

Line 522: FND_MSG_PUB.Count_And_Get

518: (G_PKG_NAME ,
519: lc_api_name );
520: END IF;
521:
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count,
524: p_data => x_msg_data );
525:
526: -- save message in debug log

Line 538: IF FND_MSG_PUB.Check_Msg_Level

534:
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536:
537: -- save message in fnd stack
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536:
537: -- save message in fnd stack
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,
543: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 543: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,
543: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
544: end if;
545: FND_MSG_PUB.Add_Exc_Msg
546: (G_PKG_NAME ,
547: lc_api_name );

Line 545: FND_MSG_PUB.Add_Exc_Msg

541: if (lc_stat_level >= lc_debug_level) then
542: FND_LOG.STRING(lc_stat_level, lc_mod_name,
543: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
544: end if;
545: FND_MSG_PUB.Add_Exc_Msg
546: (G_PKG_NAME ,
547: lc_api_name );
548: END IF;
549:

Line 550: FND_MSG_PUB.Count_And_Get

546: (G_PKG_NAME ,
547: lc_api_name );
548: END IF;
549:
550: FND_MSG_PUB.Count_And_Get
551: (p_count => x_msg_count,
552: p_data => x_msg_data );
553:
554: -- save message in debug log

Line 631: FND_MSG_PUB.initialize;

627: END IF;
628:
629: -- Initialize message list if p_init_msg_list is set to TRUE.
630: IF FND_API.to_Boolean( p_init_msg_list ) THEN
631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: IF (lc_proc_level >= lc_debug_level) THEN
635: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 1008: FND_MSG_PUB.Count_And_Get

1004: COMMIT WORK;
1005: END IF;
1006:
1007: -- Standard call to get message count and IF count is get message info.
1008: FND_MSG_PUB.Count_And_Get
1009: (p_count => x_msg_count,
1010: p_data => x_msg_data );
1011:
1012: IF (lc_proc_level >= lc_debug_level) THEN

Line 1032: FND_MSG_PUB.Add;

1028: end if;
1029: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1030: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1031: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','SERVICE_CODE_ID');
1032: FND_MSG_PUB.Add;
1033:
1034: FND_MSG_PUB.Count_And_Get
1035: (p_count => x_msg_count,
1036: p_data => x_msg_data );

Line 1034: FND_MSG_PUB.Count_And_Get

1030: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1031: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','SERVICE_CODE_ID');
1032: FND_MSG_PUB.Add;
1033:
1034: FND_MSG_PUB.Count_And_Get
1035: (p_count => x_msg_count,
1036: p_data => x_msg_data );
1037:
1038: -- save message in debug log

Line 1058: FND_MSG_PUB.Add;

1054: end if;
1055: FND_MESSAGE.SET_NAME('CSD','CSD_API_MISSING_PARAM');
1056: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1057: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','WORK_ENTITY_TYPE_CODE');
1058: FND_MSG_PUB.Add;
1059:
1060: FND_MSG_PUB.Count_And_Get
1061: (p_count => x_msg_count,
1062: p_data => x_msg_data );

Line 1060: FND_MSG_PUB.Count_And_Get

1056: FND_MESSAGE.SET_TOKEN('API_NAME',lc_api_name);
1057: FND_MESSAGE.SET_TOKEN('MISSING_PARAM','WORK_ENTITY_TYPE_CODE');
1058: FND_MSG_PUB.Add;
1059:
1060: FND_MSG_PUB.Count_And_Get
1061: (p_count => x_msg_count,
1062: p_data => x_msg_data );
1063:
1064: -- save message in debug log

Line 1083: FND_MSG_PUB.Add;

1079: 'Adding message CSD_SCW_INVALID_ID to FND_MSG stack');
1080: end if;
1081: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ID');
1082: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1083: FND_MSG_PUB.Add;
1084:
1085: FND_MSG_PUB.Count_And_Get
1086: (p_count => x_msg_count,
1087: p_data => x_msg_data );

Line 1085: FND_MSG_PUB.Count_And_Get

1081: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ID');
1082: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1083: FND_MSG_PUB.Add;
1084:
1085: FND_MSG_PUB.Count_And_Get
1086: (p_count => x_msg_count,
1087: p_data => x_msg_data );
1088:
1089: -- save message in debug log

Line 1108: FND_MSG_PUB.Add;

1104: 'Adding message CSD_SCW_GET_OVN_ERROR to FND_MSG stack');
1105: end if;
1106: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_GET_OVN_ERROR');
1107: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1108: FND_MSG_PUB.Add;
1109:
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count,
1112: p_data => x_msg_data );

Line 1110: FND_MSG_PUB.Count_And_Get

1106: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_GET_OVN_ERROR');
1107: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1108: FND_MSG_PUB.Add;
1109:
1110: FND_MSG_PUB.Count_And_Get
1111: (p_count => x_msg_count,
1112: p_data => x_msg_data );
1113:
1114: -- save message in debug log

Line 1133: FND_MSG_PUB.Add;

1129: 'Adding message CSD_SCW_OVN_MISMATCH to FND_MSG stack');
1130: end if;
1131: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_OVN_MISMATCH');
1132: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1133: FND_MSG_PUB.Add;
1134:
1135: FND_MSG_PUB.Count_And_Get
1136: (p_count => x_msg_count,
1137: p_data => x_msg_data );

Line 1135: FND_MSG_PUB.Count_And_Get

1131: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_OVN_MISMATCH');
1132: FND_MESSAGE.SET_TOKEN('SC_WORK_ENTITY_ID',p_sc_work_entity_rec.sc_work_entity_id);
1133: FND_MSG_PUB.Add;
1134:
1135: FND_MSG_PUB.Count_And_Get
1136: (p_count => x_msg_count,
1137: p_data => x_msg_data );
1138:
1139: -- save message in debug log

Line 1158: FND_MSG_PUB.Add;

1154: 'Adding message CSD_SCW_ENTITY_EXISTS to FND_MSG stack');
1155: end if;
1156: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
1157: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);
1158: FND_MSG_PUB.Add;
1159:
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count,
1162: p_data => x_msg_data );

Line 1160: FND_MSG_PUB.Count_And_Get

1156: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_ENTITY_EXISTS');
1157: FND_MESSAGE.SET_TOKEN('SERVICE_CODE_ID',p_sc_work_entity_rec.service_code_id);
1158: FND_MSG_PUB.Add;
1159:
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count,
1162: p_data => x_msg_data );
1163:
1164: -- save message in debug log

Line 1183: FND_MSG_PUB.Add;

1179: 'Adding message CSD_SCW_INVALID_ORGANIZATION to FND_MSG stack');
1180: end if;
1181: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
1182: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);
1183: FND_MSG_PUB.Add;
1184:
1185: FND_MSG_PUB.Count_And_Get
1186: (p_count => x_msg_count,
1187: p_data => x_msg_data );

Line 1185: FND_MSG_PUB.Count_And_Get

1181: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ORGANIZATION');
1182: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_sc_work_entity_rec.work_entity_id3);
1183: FND_MSG_PUB.Add;
1184:
1185: FND_MSG_PUB.Count_And_Get
1186: (p_count => x_msg_count,
1187: p_data => x_msg_data );
1188:
1189: -- save message in debug log

Line 1208: FND_MSG_PUB.Add;

1204: 'Adding message CSD_SCW_INVALID_BILL_SEQUENCE to FND_MSG stack');
1205: end if;
1206: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
1207: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);
1208: FND_MSG_PUB.Add;
1209:
1210: FND_MSG_PUB.Count_And_Get
1211: (p_count => x_msg_count,
1212: p_data => x_msg_data );

Line 1210: FND_MSG_PUB.Count_And_Get

1206: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_BILL_SEQUENCE');
1207: FND_MESSAGE.SET_TOKEN('BILL_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id1);
1208: FND_MSG_PUB.Add;
1209:
1210: FND_MSG_PUB.Count_And_Get
1211: (p_count => x_msg_count,
1212: p_data => x_msg_data );
1213:
1214: -- save message in debug log

Line 1233: FND_MSG_PUB.Add;

1229: 'Adding message CSD_SCW_INVALID_ROUTE_SEQUENCE to FND_MSG stack');
1230: end if;
1231: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
1232: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);
1233: FND_MSG_PUB.Add;
1234:
1235: FND_MSG_PUB.Count_And_Get
1236: (p_count => x_msg_count,
1237: p_data => x_msg_data );

Line 1235: FND_MSG_PUB.Count_And_Get

1231: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_ROUTE_SEQUENCE');
1232: FND_MESSAGE.SET_TOKEN('ROUTING_SEQUENCE_ID',p_sc_work_entity_rec.work_entity_id2);
1233: FND_MSG_PUB.Add;
1234:
1235: FND_MSG_PUB.Count_And_Get
1236: (p_count => x_msg_count,
1237: p_data => x_msg_data );
1238:
1239: -- save message in debug log

Line 1258: FND_MSG_PUB.Add;

1254: 'Adding message CSD_SCW_INVALID_TASK_TEMP_GRP to FND_MSG stack');
1255: end if;
1256: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
1257: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);
1258: FND_MSG_PUB.Add;
1259:
1260: FND_MSG_PUB.Count_And_Get
1261: (p_count => x_msg_count,
1262: p_data => x_msg_data );

Line 1260: FND_MSG_PUB.Count_And_Get

1256: FND_MESSAGE.SET_NAME('CSD','CSD_SCW_INVALID_TASK_TEMP_GRP');
1257: FND_MESSAGE.SET_TOKEN('TASK_TEMP_GROUP_ID',p_sc_work_entity_rec.work_entity_id1);
1258: FND_MSG_PUB.Add;
1259:
1260: FND_MSG_PUB.Count_And_Get
1261: (p_count => x_msg_count,
1262: p_data => x_msg_data );
1263:
1264: -- save message in debug log

Line 1275: FND_MSG_PUB.Count_And_Get

1271: ROLLBACK TO Update_SC_Work_Entity;
1272:
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274:
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data );
1278:
1279: -- save message in debug log

Line 1290: IF FND_MSG_PUB.Check_Msg_Level

1286: ROLLBACK TO Update_SC_Work_Entity;
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289:
1290: IF FND_MSG_PUB.Check_Msg_Level
1291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: if (lc_stat_level >= lc_debug_level) then
1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289:
1290: IF FND_MSG_PUB.Check_Msg_Level
1291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: if (lc_stat_level >= lc_debug_level) then
1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1295: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1295: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: if (lc_stat_level >= lc_debug_level) then
1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1295: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1296: end if;
1297: FND_MSG_PUB.Add_Exc_Msg
1298: (G_PKG_NAME ,
1299: lc_api_name );

Line 1297: FND_MSG_PUB.Add_Exc_Msg

1293: if (lc_stat_level >= lc_debug_level) then
1294: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1295: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1296: end if;
1297: FND_MSG_PUB.Add_Exc_Msg
1298: (G_PKG_NAME ,
1299: lc_api_name );
1300: END IF;
1301:

Line 1302: FND_MSG_PUB.Count_And_Get

1298: (G_PKG_NAME ,
1299: lc_api_name );
1300: END IF;
1301:
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count,
1304: p_data => x_msg_data );
1305:
1306: -- save message in debug log

Line 1318: IF FND_MSG_PUB.Check_Msg_Level

1314:
1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316:
1317: -- save message in fnd stack
1318: IF FND_MSG_PUB.Check_Msg_Level
1319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: if (lc_stat_level >= lc_debug_level) then
1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1316:
1317: -- save message in fnd stack
1318: IF FND_MSG_PUB.Check_Msg_Level
1319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: if (lc_stat_level >= lc_debug_level) then
1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1323: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1323: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1320: THEN
1321: if (lc_stat_level >= lc_debug_level) then
1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1323: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1324: end if;
1325: FND_MSG_PUB.Add_Exc_Msg
1326: (G_PKG_NAME ,
1327: lc_api_name );

Line 1325: FND_MSG_PUB.Add_Exc_Msg

1321: if (lc_stat_level >= lc_debug_level) then
1322: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1323: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1324: end if;
1325: FND_MSG_PUB.Add_Exc_Msg
1326: (G_PKG_NAME ,
1327: lc_api_name );
1328: END IF;
1329:

Line 1330: FND_MSG_PUB.Count_And_Get

1326: (G_PKG_NAME ,
1327: lc_api_name );
1328: END IF;
1329:
1330: FND_MSG_PUB.Count_And_Get
1331: (p_count => x_msg_count,
1332: p_data => x_msg_data );
1333:
1334: -- save message in debug log

Line 1393: FND_MSG_PUB.initialize;

1389: END IF;
1390:
1391: -- Initialize message list if p_init_msg_list is set to TRUE.
1392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1393: FND_MSG_PUB.initialize;
1394: END IF;
1395:
1396: IF (lc_proc_level >= lc_debug_level) THEN
1397: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 1455: FND_MSG_PUB.Count_And_Get

1451: COMMIT WORK;
1452: END IF;
1453:
1454: -- Standard call to get message count and IF count is get message info.
1455: FND_MSG_PUB.Count_And_Get
1456: (p_count => x_msg_count,
1457: p_data => x_msg_data );
1458:
1459: IF (lc_proc_level >= lc_debug_level) THEN

Line 1471: FND_MSG_PUB.Count_And_Get

1467: ROLLBACK TO Delete_SC_Work_Entity;
1468:
1469: x_return_status := FND_API.G_RET_STS_ERROR;
1470:
1471: FND_MSG_PUB.Count_And_Get
1472: (p_count => x_msg_count,
1473: p_data => x_msg_data );
1474:
1475: -- save message in debug log

Line 1486: IF FND_MSG_PUB.Check_Msg_Level

1482: ROLLBACK TO Delete_SC_Work_Entity;
1483:
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485:
1486: IF FND_MSG_PUB.Check_Msg_Level
1487: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1488: THEN
1489: if (lc_stat_level >= lc_debug_level) then
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1487: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1483:
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485:
1486: IF FND_MSG_PUB.Check_Msg_Level
1487: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1488: THEN
1489: if (lc_stat_level >= lc_debug_level) then
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1491: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1491: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1487: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1488: THEN
1489: if (lc_stat_level >= lc_debug_level) then
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1491: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1492: end if;
1493: FND_MSG_PUB.Add_Exc_Msg
1494: (G_PKG_NAME ,
1495: lc_api_name );

Line 1493: FND_MSG_PUB.Add_Exc_Msg

1489: if (lc_stat_level >= lc_debug_level) then
1490: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1491: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1492: end if;
1493: FND_MSG_PUB.Add_Exc_Msg
1494: (G_PKG_NAME ,
1495: lc_api_name );
1496: END IF;
1497:

Line 1498: FND_MSG_PUB.Count_And_Get

1494: (G_PKG_NAME ,
1495: lc_api_name );
1496: END IF;
1497:
1498: FND_MSG_PUB.Count_And_Get
1499: ( p_count => x_msg_count,
1500: p_data => x_msg_data );
1501:
1502: -- save message in debug log

Line 1514: IF FND_MSG_PUB.Check_Msg_Level

1510:
1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512:
1513: -- save message in fnd stack
1514: IF FND_MSG_PUB.Check_Msg_Level
1515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1516: THEN
1517: if (lc_stat_level >= lc_debug_level) then
1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512:
1513: -- save message in fnd stack
1514: IF FND_MSG_PUB.Check_Msg_Level
1515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1516: THEN
1517: if (lc_stat_level >= lc_debug_level) then
1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1519: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1519: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1516: THEN
1517: if (lc_stat_level >= lc_debug_level) then
1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1519: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1520: end if;
1521: FND_MSG_PUB.Add_Exc_Msg
1522: (G_PKG_NAME ,
1523: lc_api_name );

Line 1521: FND_MSG_PUB.Add_Exc_Msg

1517: if (lc_stat_level >= lc_debug_level) then
1518: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1519: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1520: end if;
1521: FND_MSG_PUB.Add_Exc_Msg
1522: (G_PKG_NAME ,
1523: lc_api_name );
1524: END IF;
1525:

Line 1526: FND_MSG_PUB.Count_And_Get

1522: (G_PKG_NAME ,
1523: lc_api_name );
1524: END IF;
1525:
1526: FND_MSG_PUB.Count_And_Get
1527: (p_count => x_msg_count,
1528: p_data => x_msg_data );
1529:
1530: -- save message in debug log

Line 1589: FND_MSG_PUB.initialize;

1585: END IF;
1586:
1587: -- Initialize message list if p_init_msg_list is set to TRUE.
1588: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1589: FND_MSG_PUB.initialize;
1590: END IF;
1591:
1592: IF (lc_proc_level >= lc_debug_level) THEN
1593: FND_LOG.STRING(lc_proc_level, lc_mod_name || '.BEGIN',

Line 1690: FND_MSG_PUB.Count_And_Get

1686: COMMIT WORK;
1687: END IF;
1688:
1689: -- Standard call to get message count and IF count is get message info.
1690: FND_MSG_PUB.Count_And_Get
1691: (p_count => x_msg_count,
1692: p_data => x_msg_data );
1693:
1694: IF (lc_proc_level >= lc_debug_level) THEN

Line 1706: FND_MSG_PUB.Count_And_Get

1702: ROLLBACK TO Lock_SC_Work_Entity;
1703:
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: FND_MSG_PUB.Count_And_Get
1707: (p_count => x_msg_count,
1708: p_data => x_msg_data );
1709:
1710: -- save message in debug log

Line 1721: IF FND_MSG_PUB.Check_Msg_Level

1717: ROLLBACK TO Lock_SC_Work_Entity;
1718:
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: IF FND_MSG_PUB.Check_Msg_Level
1722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: if (lc_stat_level >= lc_debug_level) then
1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1718:
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: IF FND_MSG_PUB.Check_Msg_Level
1722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: if (lc_stat_level >= lc_debug_level) then
1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1726: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1726: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1722: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1723: THEN
1724: if (lc_stat_level >= lc_debug_level) then
1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1726: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1727: end if;
1728: FND_MSG_PUB.Add_Exc_Msg
1729: (G_PKG_NAME ,
1730: lc_api_name );

Line 1728: FND_MSG_PUB.Add_Exc_Msg

1724: if (lc_stat_level >= lc_debug_level) then
1725: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1726: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1727: end if;
1728: FND_MSG_PUB.Add_Exc_Msg
1729: (G_PKG_NAME ,
1730: lc_api_name );
1731: END IF;
1732:

Line 1733: FND_MSG_PUB.Count_And_Get

1729: (G_PKG_NAME ,
1730: lc_api_name );
1731: END IF;
1732:
1733: FND_MSG_PUB.Count_And_Get
1734: ( p_count => x_msg_count,
1735: p_data => x_msg_data );
1736:
1737: -- save message in debug log

Line 1749: IF FND_MSG_PUB.Check_Msg_Level

1745:
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747:
1748: -- save message in fnd stack
1749: IF FND_MSG_PUB.Check_Msg_Level
1750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: if (lc_stat_level >= lc_debug_level) then
1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,

Line 1750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747:
1748: -- save message in fnd stack
1749: IF FND_MSG_PUB.Check_Msg_Level
1750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: if (lc_stat_level >= lc_debug_level) then
1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1754: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

Line 1754: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');

1750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: if (lc_stat_level >= lc_debug_level) then
1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1754: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1755: end if;
1756: FND_MSG_PUB.Add_Exc_Msg
1757: (G_PKG_NAME ,
1758: lc_api_name );

Line 1756: FND_MSG_PUB.Add_Exc_Msg

1752: if (lc_stat_level >= lc_debug_level) then
1753: FND_LOG.STRING(lc_stat_level, lc_mod_name,
1754: 'Adding message using FND_MSG_PUB.Add_Exc_Msg to FND_MSG stack');
1755: end if;
1756: FND_MSG_PUB.Add_Exc_Msg
1757: (G_PKG_NAME ,
1758: lc_api_name );
1759: END IF;
1760:

Line 1761: FND_MSG_PUB.Count_And_Get

1757: (G_PKG_NAME ,
1758: lc_api_name );
1759: END IF;
1760:
1761: FND_MSG_PUB.Count_And_Get
1762: (p_count => x_msg_count,
1763: p_data => x_msg_data );
1764:
1765: -- save message in debug log