DBA Data[Home] [Help]

APPS.CSI_ORGANIZATION_UNIT_PVT dependencies on FND_MSG_PUB

Line 250: -- FND_MSG_PUB.Add;

246: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
247: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
248: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
249: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
250: -- FND_MSG_PUB.Add;
251: l_ou_tbl.DELETE(i);
252: RAISE Process_next;
253: END IF;
254: END IF;

Line 690: FND_MSG_PUB.initialize;

686:
687:
688: -- Initialize message list if p_init_msg_list is set to TRUE.
689: IF FND_API.to_Boolean( p_init_msg_list ) THEN
690: FND_MSG_PUB.initialize;
691: END IF;
692:
693:
694: -- Initialize API return status to success

Line 762: FND_MSG_PUB.Add;

758: --
759: IF l_valid_flag <> 'Y' THEN
760: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');
761: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_org_unit_rec.operating_unit_id);
762: FND_MSG_PUB.Add;
763: RAISE fnd_api.g_exc_error;
764: END IF;
765: END IF;
766: --

Line 781: FND_MSG_PUB.Add;

777: END IF;
778: ELSE
779: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');
780: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_org_unit_rec.operating_unit_id);
781: FND_MSG_PUB.Add;
782: RAISE fnd_api.g_exc_error;
783: END IF;
784: --
785: -- Check start effective date

Line 827: FND_MSG_PUB.Add;

823: --
824: if l_valid_flag <> 'Y' then
825: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REL_TYPE_CODE');
826: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_org_unit_rec.relationship_type_code);
827: FND_MSG_PUB.Add;
828: RAISE fnd_api.g_exc_error;
829: end if;
830: End if;
831: --

Line 894: x_msg_data := FND_MSG_PUB.GET

890: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
891: l_msg_index := 1;
892: l_msg_count := x_msg_count;
893: WHILE l_msg_count > 0 LOOP
894: x_msg_data := FND_MSG_PUB.GET
895: ( l_msg_index,
896: FND_API.G_FALSE );
897:
898: csi_gen_utility_pvt.put_line( ' Failed Pvt:update_organization_unit..');

Line 992: x_msg_data := FND_MSG_PUB.GET

988: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
989: l_msg_index := 1;
990: l_msg_count := x_msg_count;
991: WHILE l_msg_count > 0 LOOP
992: x_msg_data := FND_MSG_PUB.GET
993: (l_msg_index,
994: FND_API.G_FALSE );
995:
996: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

Line 1070: FND_MSG_PUB.Count_And_Get

1066: COMMIT WORK;
1067: END IF;
1068: -- End of API body
1069: -- Standard call to get message count and if count is get message info.
1070: FND_MSG_PUB.Count_And_Get
1071: (p_count => x_msg_count ,
1072: p_data => x_msg_data
1073: );
1074:

Line 1081: FND_MSG_PUB.Count_And_Get

1077:
1078: WHEN FND_API.G_EXC_ERROR THEN
1079: ROLLBACK TO create_organization_unit;
1080: x_return_status := FND_API.G_RET_STS_ERROR ;
1081: FND_MSG_PUB.Count_And_Get
1082: ( p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085:

Line 1089: FND_MSG_PUB.Count_And_Get

1085:
1086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1087: ROLLBACK TO create_organization_unit;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: FND_MSG_PUB.Count_And_Get
1090: ( p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:

Line 1098: IF FND_MSG_PUB.Check_Msg_Level

1094: WHEN OTHERS THEN
1095: ROLLBACK TO create_organization_unit;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097:
1098: IF FND_MSG_PUB.Check_Msg_Level
1099: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: THEN
1101: FND_MSG_PUB.Add_Exc_Msg
1102: ( g_pkg_name ,

Line 1099: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1095: ROLLBACK TO create_organization_unit;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097:
1098: IF FND_MSG_PUB.Check_Msg_Level
1099: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: THEN
1101: FND_MSG_PUB.Add_Exc_Msg
1102: ( g_pkg_name ,
1103: l_api_name

Line 1101: FND_MSG_PUB.Add_Exc_Msg

1097:
1098: IF FND_MSG_PUB.Check_Msg_Level
1099: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: THEN
1101: FND_MSG_PUB.Add_Exc_Msg
1102: ( g_pkg_name ,
1103: l_api_name
1104: );
1105: END IF;

Line 1107: FND_MSG_PUB.Count_And_Get

1103: l_api_name
1104: );
1105: END IF;
1106:
1107: FND_MSG_PUB.Count_And_Get
1108: ( p_count => x_msg_count,
1109: p_data => x_msg_data
1110: );
1111:

Line 1226: FND_MSG_PUB.initialize;

1222: END IF;
1223:
1224: -- Initialize message list if p_init_msg_list is set to TRUE.
1225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1226: FND_MSG_PUB.initialize;
1227: END IF;
1228:
1229: -- Initialize API return status to success
1230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1331: FND_MSG_PUB.Add;

1327: --
1328: IF l_valid_flag <> 'Y' THEN
1329: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OPERATING_UNIT');
1330: FND_MESSAGE.SET_TOKEN('OPERATING_UNIT',p_org_unit_rec.operating_unit_id);
1331: FND_MSG_PUB.Add;
1332: RAISE fnd_api.g_exc_error;
1333: END IF;
1334: END IF;
1335: --

Line 1369: FND_MSG_PUB.Add;

1365: --
1366: IF l_valid_flag <> 'Y' THEN
1367: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_REL_TYPE_CODE');
1368: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_org_unit_rec.relationship_type_code);
1369: FND_MSG_PUB.Add;
1370: RAISE fnd_api.g_exc_error;
1371: END IF;
1372: END IF;
1373: --

Line 1524: x_msg_data := FND_MSG_PUB.GET

1520: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1521: l_msg_index := 1;
1522: l_msg_count := x_msg_count;
1523: WHILE l_msg_count > 0 LOOP
1524: x_msg_data := FND_MSG_PUB.GET
1525: (l_msg_index,
1526: FND_API.G_FALSE );
1527:
1528: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

Line 2376: FND_MSG_PUB.Count_And_Get

2372: IF FND_API.To_Boolean( p_commit ) THEN
2373: COMMIT WORK;
2374: END IF;
2375:
2376: FND_MSG_PUB.Count_And_Get
2377: (p_count => x_msg_count ,
2378: p_data => x_msg_data
2379: );
2380:

Line 2387: FND_MSG_PUB.Count_And_Get

2383:
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: ROLLBACK TO update_organization_unit;
2386: x_return_status := FND_API.G_RET_STS_ERROR ;
2387: FND_MSG_PUB.Count_And_Get
2388: ( p_count => x_msg_count,
2389: p_data => x_msg_data
2390: );
2391:

Line 2395: FND_MSG_PUB.Count_And_Get

2391:
2392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2393: ROLLBACK TO update_organization_unit;
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2395: FND_MSG_PUB.Count_And_Get
2396: ( p_count => x_msg_count,
2397: p_data => x_msg_data
2398: );
2399:

Line 2404: IF FND_MSG_PUB.Check_Msg_Level

2400: WHEN OTHERS THEN
2401: ROLLBACK TO update_organization_unit;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2403:
2404: IF FND_MSG_PUB.Check_Msg_Level
2405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: FND_MSG_PUB.Add_Exc_Msg
2408: ( g_pkg_name ,

Line 2405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2401: ROLLBACK TO update_organization_unit;
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2403:
2404: IF FND_MSG_PUB.Check_Msg_Level
2405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: FND_MSG_PUB.Add_Exc_Msg
2408: ( g_pkg_name ,
2409: l_api_name

Line 2407: FND_MSG_PUB.Add_Exc_Msg

2403:
2404: IF FND_MSG_PUB.Check_Msg_Level
2405: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: FND_MSG_PUB.Add_Exc_Msg
2408: ( g_pkg_name ,
2409: l_api_name
2410: );
2411: END IF;

Line 2413: FND_MSG_PUB.Count_And_Get

2409: l_api_name
2410: );
2411: END IF;
2412:
2413: FND_MSG_PUB.Count_And_Get
2414: ( p_count => x_msg_count,
2415: p_data => x_msg_data
2416: );
2417:

Line 2470: FND_MSG_PUB.initialize;

2466:
2467:
2468: -- Initialize message list if p_init_msg_list is set to TRUE.
2469: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2470: FND_MSG_PUB.initialize;
2471: END IF;
2472:
2473:
2474: -- Initialize API return status to success

Line 2557: x_msg_data := FND_MSG_PUB.GET

2553: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2554: l_msg_index := 1;
2555: l_msg_count := x_msg_count;
2556: WHILE l_msg_count > 0 LOOP
2557: x_msg_data := FND_MSG_PUB.GET
2558: (l_msg_index,
2559: FND_API.G_FALSE );
2560:
2561: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

Line 2578: FND_MSG_PUB.Count_And_Get

2574: END IF;
2575:
2576:
2577: -- Standard call to get message count and if count is get message info.
2578: FND_MSG_PUB.Count_And_Get
2579: (p_count => x_msg_count ,
2580: p_data => x_msg_data
2581: );
2582:

Line 2590: FND_MSG_PUB.Count_And_Get

2586: WHEN FND_API.G_EXC_ERROR THEN
2587:
2588: ROLLBACK TO expire_organization_unit;
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: FND_MSG_PUB.Count_And_Get
2591: ( p_count => x_msg_count,
2592: p_data => x_msg_data
2593: );
2594:

Line 2599: FND_MSG_PUB.Count_And_Get

2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596:
2597: ROLLBACK TO expire_organization_unit;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2599: FND_MSG_PUB.Count_And_Get
2600: ( p_count => x_msg_count,
2601: p_data => x_msg_data
2602: );
2603:

Line 2609: IF FND_MSG_PUB.Check_Msg_Level

2605:
2606: ROLLBACK TO expire_organization_unit;
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2608:
2609: IF FND_MSG_PUB.Check_Msg_Level
2610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2611: THEN
2612: FND_MSG_PUB.Add_Exc_Msg
2613: ( g_pkg_name,

Line 2610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2606: ROLLBACK TO expire_organization_unit;
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2608:
2609: IF FND_MSG_PUB.Check_Msg_Level
2610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2611: THEN
2612: FND_MSG_PUB.Add_Exc_Msg
2613: ( g_pkg_name,
2614: l_api_name

Line 2612: FND_MSG_PUB.Add_Exc_Msg

2608:
2609: IF FND_MSG_PUB.Check_Msg_Level
2610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2611: THEN
2612: FND_MSG_PUB.Add_Exc_Msg
2613: ( g_pkg_name,
2614: l_api_name
2615: );
2616: END IF;

Line 2618: FND_MSG_PUB.Count_And_Get

2614: l_api_name
2615: );
2616: END IF;
2617:
2618: FND_MSG_PUB.Count_And_Get
2619: ( p_count => x_msg_count,
2620: p_data => x_msg_data
2621: );
2622:

Line 2719: FND_MSG_PUB.initialize;

2715: END IF;
2716:
2717: -- Initialize message list if p_init_msg_list is set to TRUE.
2718: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2719: FND_MSG_PUB.initialize;
2720: END IF;
2721:
2722: -- Initialize API return status to success
2723: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2832: FND_MSG_PUB.Count_And_Get

2828: */
2829:
2830:
2831: -- Standard call to get message count and if count is get message info.
2832: FND_MSG_PUB.Count_And_Get
2833: (p_count => x_msg_count,
2834: p_data => x_msg_data
2835: );
2836:

Line 2844: FND_MSG_PUB.Count_And_Get

2840: WHEN FND_API.G_EXC_ERROR THEN
2841:
2842: -- ROLLBACK TO get_org_unit_history;
2843: x_return_status := FND_API.G_RET_STS_ERROR;
2844: FND_MSG_PUB.Count_And_Get
2845: ( p_count => x_msg_count,
2846: p_data => x_msg_data
2847: );
2848:

Line 2853: FND_MSG_PUB.Count_And_Get

2849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2850:
2851: -- ROLLBACK TO get_org_unit_history;
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853: FND_MSG_PUB.Count_And_Get
2854: ( p_count => x_msg_count,
2855: p_data => x_msg_data
2856: );
2857:

Line 2863: IF FND_MSG_PUB.Check_Msg_Level

2859:
2860: -- ROLLBACK TO get_org_unit_history;
2861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2862:
2863: IF FND_MSG_PUB.Check_Msg_Level
2864: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg
2867: ( g_pkg_name,

Line 2864: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2860: -- ROLLBACK TO get_org_unit_history;
2861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2862:
2863: IF FND_MSG_PUB.Check_Msg_Level
2864: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg
2867: ( g_pkg_name,
2868: l_api_name

Line 2866: FND_MSG_PUB.Add_Exc_Msg

2862:
2863: IF FND_MSG_PUB.Check_Msg_Level
2864: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: FND_MSG_PUB.Add_Exc_Msg
2867: ( g_pkg_name,
2868: l_api_name
2869: );
2870: END IF;

Line 2872: FND_MSG_PUB.Count_And_Get

2868: l_api_name
2869: );
2870: END IF;
2871:
2872: FND_MSG_PUB.Count_And_Get
2873: ( p_count => x_msg_count,
2874: p_data => x_msg_data
2875: );
2876: