DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PVT dependencies on FND_MSG_PUB

Line 847: -- FND_MSG_PUB.Add;

843: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
844: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
845: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
846: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
847: -- FND_MSG_PUB.Add;
848: l_pri_tbl.DELETE(i);
849: csi_gen_utility_pvt.put_line('Processing Next..');
850: RAISE Process_next;
851: END IF;

Line 1990: FND_MSG_PUB.initialize;

1986:
1987:
1988: -- Initialize message list if p_init_msg_list is set to TRUE.
1989: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993:
1994: -- Initialize API return status to success

Line 2229: FND_MSG_PUB.Add;

2225:
2226: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2227: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
2228: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
2229: FND_MSG_PUB.Add;
2230: ROLLBACK TO create_pricing_attribs;
2231: RETURN;
2232: END IF;
2233:

Line 2503: FND_MSG_PUB.Count_And_Get

2499: END IF;
2500:
2501:
2502: -- Standard call to get message count and if count is get message info.
2503: FND_MSG_PUB.Count_And_Get
2504: (p_count => x_msg_count ,
2505: p_data => x_msg_data
2506: );
2507:

Line 2513: FND_MSG_PUB.Count_And_Get

2509:
2510: WHEN FND_API.G_EXC_ERROR THEN
2511: ROLLBACK TO create_pricing_attribs;
2512: x_return_status := FND_API.G_RET_STS_ERROR ;
2513: FND_MSG_PUB.Count_And_Get
2514: ( p_count => x_msg_count,
2515: p_data => x_msg_data
2516: );
2517:

Line 2522: FND_MSG_PUB.Count_And_Get

2518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2519:
2520: ROLLBACK TO create_pricing_attribs;
2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2522: FND_MSG_PUB.Count_And_Get
2523: ( p_count => x_msg_count,
2524: p_data => x_msg_data
2525: );
2526:

Line 2531: IF FND_MSG_PUB.Check_Msg_Level

2527: WHEN OTHERS THEN
2528: ROLLBACK TO create_pricing_attribs;
2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2530:
2531: IF FND_MSG_PUB.Check_Msg_Level
2532: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2533: THEN
2534: FND_MSG_PUB.Add_Exc_Msg
2535: ( g_pkg_name,

Line 2532: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2528: ROLLBACK TO create_pricing_attribs;
2529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2530:
2531: IF FND_MSG_PUB.Check_Msg_Level
2532: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2533: THEN
2534: FND_MSG_PUB.Add_Exc_Msg
2535: ( g_pkg_name,
2536: l_api_name

Line 2534: FND_MSG_PUB.Add_Exc_Msg

2530:
2531: IF FND_MSG_PUB.Check_Msg_Level
2532: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2533: THEN
2534: FND_MSG_PUB.Add_Exc_Msg
2535: ( g_pkg_name,
2536: l_api_name
2537: );
2538: END IF;

Line 2540: FND_MSG_PUB.Count_And_Get

2536: l_api_name
2537: );
2538: END IF;
2539:
2540: FND_MSG_PUB.Count_And_Get
2541: (p_count => x_msg_count,
2542: p_data => x_msg_data
2543: );
2544:

Line 2605: FND_MSG_PUB.initialize;

2601:
2602:
2603: -- Initialize message list if p_init_msg_list is set to TRUE.
2604: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2605: FND_MSG_PUB.initialize;
2606: END IF;
2607:
2608:
2609: -- Initialize API return status to success

Line 2693: FND_MSG_PUB.ADD;

2689: IF ( p_pricing_attribs_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
2690: IF (p_pricing_attribs_rec.active_start_date <> l_pricing_attribs_rec.active_start_date) THEN
2691: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2692: FND_MESSAGE.Set_Token('COLUMN', 'PRICING ATTRIBUTE START_DATE');
2693: FND_MSG_PUB.ADD;
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: END IF;
2697:

Line 2871: x_msg_data := FND_MSG_PUB.GET

2867: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2868: l_msg_index := 1;
2869: l_msg_count := x_msg_count;
2870: WHILE l_msg_count > 0 LOOP
2871: x_msg_data := FND_MSG_PUB.GET
2872: (l_msg_index,
2873: FND_API.G_FALSE );
2874:
2875: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

Line 7291: FND_MSG_PUB.Count_And_Get

7287: COMMIT WORK;
7288: END IF;
7289:
7290: -- Standard call to get message count and if count is get message info.
7291: FND_MSG_PUB.Count_And_Get
7292: (p_count => x_msg_count ,
7293: p_data => x_msg_data
7294: );
7295:

Line 7302: FND_MSG_PUB.Count_And_Get

7298:
7299: WHEN FND_API.G_EXC_ERROR THEN
7300: ROLLBACK TO update_pricing_attribs;
7301: x_return_status := FND_API.G_RET_STS_ERROR ;
7302: FND_MSG_PUB.Count_And_Get
7303: ( p_count => x_msg_count,
7304: p_data => x_msg_data
7305: );
7306:

Line 7310: FND_MSG_PUB.Count_And_Get

7306:
7307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7308: ROLLBACK TO update_pricing_attribs;
7309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7310: FND_MSG_PUB.Count_And_Get
7311: (p_count => x_msg_count,
7312: p_data => x_msg_data
7313: );
7314:

Line 7319: IF FND_MSG_PUB.Check_Msg_Level

7315: WHEN OTHERS THEN
7316: ROLLBACK TO update_pricing_attribs;
7317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7318:
7319: IF FND_MSG_PUB.Check_Msg_Level
7320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7321: THEN
7322: FND_MSG_PUB.Add_Exc_Msg
7323: (g_pkg_name,

Line 7320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7316: ROLLBACK TO update_pricing_attribs;
7317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7318:
7319: IF FND_MSG_PUB.Check_Msg_Level
7320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7321: THEN
7322: FND_MSG_PUB.Add_Exc_Msg
7323: (g_pkg_name,
7324: l_api_name

Line 7322: FND_MSG_PUB.Add_Exc_Msg

7318:
7319: IF FND_MSG_PUB.Check_Msg_Level
7320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7321: THEN
7322: FND_MSG_PUB.Add_Exc_Msg
7323: (g_pkg_name,
7324: l_api_name
7325: );
7326: END IF;

Line 7328: FND_MSG_PUB.Count_And_Get

7324: l_api_name
7325: );
7326: END IF;
7327:
7328: FND_MSG_PUB.Count_And_Get
7329: (p_count => x_msg_count,
7330: p_data => x_msg_data
7331: );
7332:

Line 7383: FND_MSG_PUB.initialize;

7379:
7380:
7381: -- Initialize message list if p_init_msg_list is set to TRUE.
7382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7383: FND_MSG_PUB.initialize;
7384: END IF;
7385:
7386:
7387: -- Initialize API return status to success

Line 7564: x_msg_data := FND_MSG_PUB.GET

7560: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7561: l_msg_index := 1;
7562: l_msg_count := x_msg_count;
7563: WHILE l_msg_count > 0 LOOP
7564: x_msg_data := FND_MSG_PUB.GET
7565: ( l_msg_index,
7566: FND_API.G_FALSE );
7567:
7568: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

Line 7583: FND_MSG_PUB.Count_And_Get

7579: COMMIT WORK;
7580: END IF;
7581:
7582: -- Standard call to get message count and if count is get message info.
7583: FND_MSG_PUB.Count_And_Get
7584: (p_count => x_msg_count ,
7585: p_data => x_msg_data
7586: );
7587:

Line 7593: FND_MSG_PUB.Count_And_Get

7589: EXCEPTION
7590: WHEN FND_API.G_EXC_ERROR THEN
7591: ROLLBACK TO expire_pricing_attribs;
7592: x_return_status := FND_API.G_RET_STS_ERROR ;
7593: FND_MSG_PUB.Count_And_Get
7594: ( p_count => x_msg_count,
7595: p_data => x_msg_data
7596: );
7597:

Line 7601: FND_MSG_PUB.Count_And_Get

7597:
7598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7599: ROLLBACK TO expire_pricing_attribs;
7600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7601: FND_MSG_PUB.Count_And_Get
7602: (p_count => x_msg_count,
7603: p_data => x_msg_data
7604: );
7605:

Line 7610: IF FND_MSG_PUB.Check_Msg_Level

7606: WHEN OTHERS THEN
7607: ROLLBACK TO expire_pricing_attribs;
7608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7609:
7610: IF FND_MSG_PUB.Check_Msg_Level
7611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7612: THEN
7613: FND_MSG_PUB.Add_Exc_Msg
7614: ( g_pkg_name,

Line 7611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7607: ROLLBACK TO expire_pricing_attribs;
7608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7609:
7610: IF FND_MSG_PUB.Check_Msg_Level
7611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7612: THEN
7613: FND_MSG_PUB.Add_Exc_Msg
7614: ( g_pkg_name,
7615: l_api_name

Line 7613: FND_MSG_PUB.Add_Exc_Msg

7609:
7610: IF FND_MSG_PUB.Check_Msg_Level
7611: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7612: THEN
7613: FND_MSG_PUB.Add_Exc_Msg
7614: ( g_pkg_name,
7615: l_api_name
7616: );
7617: END IF;

Line 7619: FND_MSG_PUB.Count_And_Get

7615: l_api_name
7616: );
7617: END IF;
7618:
7619: FND_MSG_PUB.Count_And_Get
7620: ( p_count => x_msg_count,
7621: p_data => x_msg_data
7622: );
7623: