DBA Data[Home] [Help]

APPS.CS_TM_LABOR_SCHEDULE_PVT dependencies on FND_MSG_PUB

Line 96: FND_MSG_PUB.Initialize;

92:
93:
94: /**-- Initialize the message list if p_init_msg_list is set to TRUE
95: IF FND_API.To_Boolean(p_init_msg_list) THEN
96: FND_MSG_PUB.Initialize;
97: END IF;**/
98:
99:
100: -- Initialize API return status to success

Line 286: FND_MSG_PUB.add;

282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
283: FND_MESSAGE.set_token('API_NAME', l_api_name);
284: FND_MESSAGE.set_token('VALUE', 'Regular');
285: FND_MESSAGE.set_token('DAY', 'MONDAY');
286: FND_MSG_PUB.add;
287: RAISE FND_API.g_exc_error;
288: ELSE ---Call Function To validate Monday Table
289: VALIDATE_OVERLAP
290: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,

Line 305: FND_MSG_PUB.add;

301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
302: FND_MESSAGE.set_token('API_NAME', l_api_name);
303: FND_MESSAGE.set_token ('VALUE', 'Regular');
304: FND_MESSAGE.set_token('DAY', 'TUESDAY');
305: FND_MSG_PUB.add;
306: RAISE FND_API.g_exc_error;
307: ELSE ---Call Function To validate Tuesday Table
308: VALIDATE_OVERLAP
309: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,

Line 324: FND_MSG_PUB.add;

320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
321: FND_MESSAGE.set_token('API_NAME', l_api_name);
322: FND_MESSAGE.set_token ('VALUE', 'Regular');
323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
324: FND_MSG_PUB.add;
325: RAISE FND_API.g_exc_error;
326: ELSE ---Call Function To validate Wednesday Table
327: VALIDATE_OVERLAP
328: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,

Line 343: FND_MSG_PUB.add;

339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
340: FND_MESSAGE.set_token('API_NAME', l_api_name);
341: FND_MESSAGE.set_token ('VALUE', 'Regular');
342: FND_MESSAGE.set_token('DAY', 'THURSDAY');
343: FND_MSG_PUB.add;
344: RAISE FND_API.g_exc_error;
345: ELSE ---Call Function To validate Thursday Table
346: VALIDATE_OVERLAP
347: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,

Line 362: FND_MSG_PUB.add;

358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
359: FND_MESSAGE.set_token('API_NAME', l_api_name);
360: FND_MESSAGE.set_token ('VALUE', 'Regular');
361: FND_MESSAGE.set_token('DAY', 'FRIDAY');
362: FND_MSG_PUB.add;
363: RAISE FND_API.g_exc_error;
364: ELSE ---Call Function To validate Friday Table
365: VALIDATE_OVERLAP
366: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,

Line 381: FND_MSG_PUB.add;

377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
378: FND_MESSAGE.set_token('API_NAME', l_api_name);
379: FND_MESSAGE.set_token ('VALUE', 'Regular');
380: FND_MESSAGE.set_token('DAY', 'SATURDAY');
381: FND_MSG_PUB.add;
382: RAISE FND_API.g_exc_error;
383: ELSE ---Call Function To validate Saturday Table
384: VALIDATE_OVERLAP
385: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,

Line 400: FND_MSG_PUB.add;

396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
397: FND_MESSAGE.set_token('API_NAME', l_api_name);
398: FND_MESSAGE.set_token ('VALUE', 'Regular');
399: FND_MESSAGE.set_token('DAY', 'SUNDAY');
400: FND_MSG_PUB.add;
401: RAISE FND_API.g_exc_error;
402: ELSE ---Call Function To validate Sunday Table
403: VALIDATE_OVERLAP
404: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,

Line 420: FND_MSG_PUB.add;

416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
417: FND_MESSAGE.set_token('API_NAME', l_api_name);
418: FND_MESSAGE.set_token ('VALUE', 'Holiday');
419: FND_MESSAGE.set_token('DAY', 'MONDAY');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_error;
422: ELSE ---Call Function To validate Monday Holiday Table
423: VALIDATE_OVERLAP
424: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,

Line 439: FND_MSG_PUB.add;

435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
436: FND_MESSAGE.set_token('API_NAME', l_api_name);
437: FND_MESSAGE.set_token ('VALUE', 'Holiday');
438: FND_MESSAGE.set_token('DAY', 'TUESDAY');
439: FND_MSG_PUB.add;
440: RAISE FND_API.g_exc_error;
441: ELSE ---Call Function To validate Tuesday Holiday Table
442: VALIDATE_OVERLAP
443: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,

Line 458: FND_MSG_PUB.add;

454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
455: FND_MESSAGE.set_token('API_NAME', l_api_name);
456: FND_MESSAGE.set_token ('VALUE', 'Holiday');
457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
458: FND_MSG_PUB.add;
459: RAISE FND_API.g_exc_error;
460: ELSE ---Call Function To validate Wednesday Holiday Table
461: VALIDATE_OVERLAP
462: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,

Line 477: FND_MSG_PUB.add;

473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
474: FND_MESSAGE.set_token('API_NAME', l_api_name);
475: FND_MESSAGE.set_token ('VALUE', 'Holiday');
476: FND_MESSAGE.set_token('DAY', 'THURSDAY');
477: FND_MSG_PUB.add;
478: RAISE FND_API.g_exc_error;
479: ELSE ---Call Function To validate Thursday Holiday Table
480: VALIDATE_OVERLAP
481: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,

Line 496: FND_MSG_PUB.add;

492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
493: FND_MESSAGE.set_token('API_NAME', l_api_name);
494: FND_MESSAGE.set_token ('VALUE', 'Holiday');
495: FND_MESSAGE.set_token('DAY', 'FRIDAY');
496: FND_MSG_PUB.add;
497: RAISE FND_API.g_exc_error;
498: ELSE ---Call Function To validate Friday Holiday Table
499: VALIDATE_OVERLAP
500: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,

Line 515: FND_MSG_PUB.add;

511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
512: FND_MESSAGE.set_token('API_NAME', l_api_name);
513: FND_MESSAGE.set_token ('VALUE', 'Holiday');
514: FND_MESSAGE.set_token('DAY', 'SATURDAY');
515: FND_MSG_PUB.add;
516: RAISE FND_API.g_exc_error;
517: ELSE ---Call Function To validate Saturday Holiday Table
518: VALIDATE_OVERLAP
519: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,

Line 534: FND_MSG_PUB.add;

530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
531: FND_MESSAGE.set_token('API_NAME', l_api_name);
532: FND_MESSAGE.set_token ('VALUE', 'Holiday');
533: FND_MESSAGE.set_token('DAY', 'SUNDAY');
534: FND_MSG_PUB.add;
535: RAISE FND_API.g_exc_error;
536: ELSE ---Call Function To validate Friday Holiday Table
537: VALIDATE_OVERLAP
538: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,

Line 552: x_msg_data := fnd_msg_pub.get;

548: EXCEPTION
549:
550: WHEN fnd_api.g_exc_error THEN
551: x_return_status := fnd_api.g_ret_sts_error;
552: x_msg_data := fnd_msg_pub.get;
553:
554:
555: WHEN OTHERS THEN
556: x_return_status := fnd_api.g_ret_sts_error;

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:
635: -- Initialize API return status to success

Line 818: FND_MSG_PUB.add;

814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
815: FND_MESSAGE.set_token('API_NAME', l_api_name);
816: FND_MESSAGE.set_token('VALUE', 'Regular');
817: FND_MESSAGE.set_token('DAY', 'MONDAY');
818: FND_MSG_PUB.add;
819: RAISE FND_API.g_exc_error;
820: ELSE ---Call Function To validate Monday Table
821: VALIDATE_COMPLETE_CHECK
822: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,

Line 837: FND_MSG_PUB.add;

833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
834: FND_MESSAGE.set_token('API_NAME', l_api_name);
835: FND_MESSAGE.set_token('VALUE', 'Regular');
836: FND_MESSAGE.set_token('DAY', 'TUESDAY');
837: FND_MSG_PUB.add;
838: RAISE FND_API.g_exc_error;
839: ELSE -- Call Function to validate the Tuesday Table
840: VALIDATE_COMPLETE_CHECK
841: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,

Line 856: FND_MSG_PUB.add;

852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
853: FND_MESSAGE.set_token('API_NAME', l_api_name);
854: FND_MESSAGE.set_token('VALUE', 'Regular');
855: FND_MESSAGE.set_token('DAY', 'Wednesday');
856: FND_MSG_PUB.add;
857: RAISE FND_API.g_exc_error;
858:
859: ELSE -- Call Function to validate
860: VALIDATE_COMPLETE_CHECK

Line 876: FND_MSG_PUB.add;

872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
873: FND_MESSAGE.set_token('API_NAME', l_api_name);
874: FND_MESSAGE.set_token('VALUE', 'Regular');
875: FND_MESSAGE.set_token('DAY', 'THURSDAY');
876: FND_MSG_PUB.add;
877: RAISE FND_API.g_exc_error;
878: ELSE -- Call Function to validate
879: VALIDATE_COMPLETE_CHECK
880: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,

Line 895: FND_MSG_PUB.add;

891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
892: FND_MESSAGE.set_token('API_NAME', l_api_name);
893: FND_MESSAGE.set_token('VALUE', 'Regular');
894: FND_MESSAGE.set_token('DAY', 'FRIDAY');
895: FND_MSG_PUB.add;
896: RAISE FND_API.g_exc_error;
897: ELSE -- Call Function to validate
898: VALIDATE_COMPLETE_CHECK
899: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,

Line 914: FND_MSG_PUB.add;

910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
911: FND_MESSAGE.set_token('API_NAME', l_api_name);
912: FND_MESSAGE.set_token('VALUE', 'Regular');
913: FND_MESSAGE.set_token('DAY', 'SATURDAY');
914: FND_MSG_PUB.add;
915: RAISE FND_API.g_exc_error;
916: ELSE -- Call Function to validate
917: VALIDATE_COMPLETE_CHECK
918: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,

Line 933: FND_MSG_PUB.add;

929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
930: FND_MESSAGE.set_token('API_NAME', l_api_name);
931: FND_MESSAGE.set_token('VALUE', 'Regular');
932: FND_MESSAGE.set_token('DAY', 'SUNDAY');
933: FND_MSG_PUB.add;
934: RAISE FND_API.g_exc_error;
935: ELSE -- Call Function to validate
936: VALIDATE_COMPLETE_CHECK
937: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,

Line 953: FND_MSG_PUB.add;

949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
950: FND_MESSAGE.set_token('API_NAME', l_api_name);
951: FND_MESSAGE.set_token('VALUE', 'Holiday');
952: FND_MESSAGE.set_token('DAY', 'MONDAY');
953: FND_MSG_PUB.add;
954: RAISE FND_API.g_exc_error;
955: ELSE ---Call Function To validate Monday Holiday Table
956: VALIDATE_COMPLETE_CHECK
957: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,

Line 972: FND_MSG_PUB.add;

968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
969: FND_MESSAGE.set_token('API_NAME', l_api_name);
970: FND_MESSAGE.set_token('VALUE', 'Holiday');
971: FND_MESSAGE.set_token('DAY', 'TUESDAY');
972: FND_MSG_PUB.add;
973: RAISE FND_API.g_exc_error;
974: ELSE ---Call Function To validate Tuesday Holiday Table
975: VALIDATE_COMPLETE_CHECK
976: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,

Line 991: FND_MSG_PUB.add;

987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
988: FND_MESSAGE.set_token('API_NAME', l_api_name);
989: FND_MESSAGE.set_token('VALUE', 'Holiday');
990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
991: FND_MSG_PUB.add;
992: RAISE FND_API.g_exc_error;
993: ELSE ---Call Function To validate Wednesday Holiday Table
994: VALIDATE_COMPLETE_CHECK
995: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,

Line 1010: FND_MSG_PUB.add;

1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1007: FND_MESSAGE.set_token('API_NAME', l_api_name);
1008: FND_MESSAGE.set_token('VALUE', 'Holiday');
1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');
1010: FND_MSG_PUB.add;
1011: RAISE FND_API.g_exc_error;
1012: ELSE ---Call Function To validate Thursday Holiday Table
1013: VALIDATE_COMPLETE_CHECK
1014: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,

Line 1029: FND_MSG_PUB.add;

1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1026: FND_MESSAGE.set_token('API_NAME', l_api_name);
1027: FND_MESSAGE.set_token('VALUE', 'Holiday');
1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');
1029: FND_MSG_PUB.add;
1030: RAISE FND_API.g_exc_error;
1031: ELSE ---Call Function To validate Friday Holiday Table
1032: VALIDATE_COMPLETE_CHECK
1033: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,

Line 1048: FND_MSG_PUB.add;

1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1045: FND_MESSAGE.set_token('API_NAME', l_api_name);
1046: FND_MESSAGE.set_token('VALUE', 'Holiday');
1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');
1048: FND_MSG_PUB.add;
1049: RAISE FND_API.g_exc_error;
1050: ELSE ---Call Function To validate Saturday Holiday Table
1051: VALIDATE_COMPLETE_CHECK
1052: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,

Line 1068: FND_MSG_PUB.add;

1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1065: FND_MESSAGE.set_token('API_NAME', l_api_name);
1066: FND_MESSAGE.set_token('VALUE', 'Holiday');
1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');
1068: FND_MSG_PUB.add;
1069: RAISE FND_API.g_exc_error;
1070: ELSE ---Call Function To validate Friday Holiday Table
1071: VALIDATE_COMPLETE_CHECK
1072: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,

Line 1085: x_msg_data := fnd_msg_pub.get;

1081: EXCEPTION
1082:
1083: WHEN fnd_api.g_exc_error THEN
1084: x_return_status := fnd_api.g_ret_sts_error;
1085: x_msg_data := fnd_msg_pub.get;
1086:
1087: WHEN OTHERS THEN
1088:
1089: l_errm := SQLERRM;

Line 1167: FND_MSG_PUB.Initialize;

1163: END IF;
1164:
1165: -- Initialize the message list if p_init_msg_list is set to TRUE
1166: IF FND_API.To_Boolean(p_init_msg_list) THEN
1167: FND_MSG_PUB.Initialize;
1168: END IF;
1169:
1170: -- Initialize the API Return Success to TRUE
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1188: FND_MSG_PUB.Add;

1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);
1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');
1188: FND_MSG_PUB.Add;
1189: RAISE FND_API.g_exc_error;
1190:
1191: END IF;
1192: CLOSE tm_validate_csr;

Line 1201: FND_MSG_PUB.Add;

1197: --raise error
1198: FND_MESSAGE.Set_Name('CS', 'CS_CHG_API_TM_SCHED_INCOMPLETE');
1199: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1200: FND_MESSAGE.Set_Token('BUSINESS_PROC_ID', p_business_process_id);
1201: FND_MSG_PUB.Add;
1202: RAISE FND_API.g_exc_error;
1203: END IF;
1204:
1205: -- Check to see if activity occurs in the same day

Line 1362: fnd_msg_pub.add;

1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1362: fnd_msg_pub.add;
1363: RAISE fnd_api.g_exc_error;
1364: ELSE
1365: lv_sum := lv_sum + (P_TM_TBL_TYPE(lv_index).end_time - P_TM_TBL_TYPE(lv_index).start_time);
1366: END IF;

Line 1379: fnd_msg_pub.add;

1375: --error
1376: --RAISE e_comp_chk_failure;
1377: fnd_message.set_name('CS','CS_CHG_API_COMPLETE_CHECK_FAIL');
1378: fnd_message.set_token('API_NAME', l_api_name);
1379: fnd_msg_pub.add;
1380: RAISE fnd_api.g_exc_error;
1381:
1382: END IF;
1383:

Line 1428: fnd_msg_pub.add;

1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1428: fnd_msg_pub.add;
1429: RAISE fnd_api.g_exc_error;
1430: ELSE
1431: null;
1432: END IF;