APPS.OKC_MANAGE_DELIVERABLES_GRP dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.Count_And_Get(

78: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
80: END IF;
81: x_return_status := G_RET_STS_ERROR;
82: FND_MSG_PUB.Count_And_Get(
83: p_count => x_msg_count,
84: p_data => x_msg_data
85: );
86:

Line 92: FND_MSG_PUB.Count_And_Get(

88: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
90: END IF;
91: x_return_status := G_RET_STS_UNEXP_ERROR;
92: FND_MSG_PUB.Count_And_Get(
93: p_count => x_msg_count,
94: p_data => x_msg_data
95: );
96:

Line 102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

98: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
99: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
100: END IF;
101: x_return_status := G_RET_STS_UNEXP_ERROR;
102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
103: END IF;
104: FND_MSG_PUB.Count_And_Get(
105: p_count => x_msg_count,
106: p_data => x_msg_data

Line 104: FND_MSG_PUB.Count_And_Get(

100: END IF;
101: x_return_status := G_RET_STS_UNEXP_ERROR;
102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
103: END IF;
104: FND_MSG_PUB.Count_And_Get(
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: END; -- checkAndCreateStatusHistory

Line 815: FND_MSG_PUB.initialize;

811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success
819: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

913: COMMIT WORK;
914: END IF;
915:
916: -- Standard call to get message count and if count is 1, get message info.
917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
918:
919: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
920: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1100: Leaving activateDeliverables');
921: END IF;

Line 930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

926: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1200: Leaving activateDeliverables Unexpected ERROR');
927: END IF;
928: ROLLBACK TO g_activate_del_GRP;
929: x_return_status := G_RET_STS_ERROR ;
930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1300: Leaving activateDeliverables Unexpected ERROR');

Line 938: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

934: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1300: Leaving activateDeliverables Unexpected ERROR');
935: END IF;
936: ROLLBACK TO g_activate_del_GRP;
937: x_return_status := G_RET_STS_UNEXP_ERROR ;
938: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
939:
940: WHEN OTHERS THEN
941: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1400: Leaving activateDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

942: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1400: Leaving activateDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
943: END IF;
944: ROLLBACK TO g_activate_del_GRP;
945: x_return_status := G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
948: END IF;
949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
950:

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

943: END IF;
944: ROLLBACK TO g_activate_del_GRP;
945: x_return_status := G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
948: END IF;
949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
950:
951: END; -- activateDeliverables

Line 949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

945: x_return_status := G_RET_STS_UNEXP_ERROR ;
946: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
947: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
948: END IF;
949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
950:
951: END; -- activateDeliverables
952:
953:

Line 1181: FND_MSG_PUB.initialize;

1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.
1180: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Initialize API return status to success
1185: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1868: END IF;
1869:
1870: ROLLBACK TO g_resolve_del_GRP;
1871: x_return_status := G_RET_STS_ERROR ;
1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving resolveDeliverables Unexpected ERROR');

Line 1887: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1883: END IF;
1884:
1885: ROLLBACK TO g_resolve_del_GRP;
1886: x_return_status := G_RET_STS_UNEXP_ERROR ;
1887: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1888:
1889: WHEN OTHERS THEN
1890: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1891: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving resolveDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

1898: END IF;
1899:
1900: ROLLBACK TO g_resolve_del_GRP;
1901: x_return_status := G_RET_STS_UNEXP_ERROR ;
1902: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1904: END IF;
1905: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1906:

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

1899:
1900: ROLLBACK TO g_resolve_del_GRP;
1901: x_return_status := G_RET_STS_UNEXP_ERROR ;
1902: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1904: END IF;
1905: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1906:
1907: END; -- resolveDeliverables

Line 1905: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1901: x_return_status := G_RET_STS_UNEXP_ERROR ;
1902: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1903: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1904: END IF;
1905: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1906:
1907: END; -- resolveDeliverables
1908:
1909: /**

Line 2032: FND_MSG_PUB.initialize;

2028: END IF;
2029:
2030: -- Initialize message list if p_init_msg_list is set to TRUE.
2031: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2032: FND_MSG_PUB.initialize;
2033: END IF;
2034:
2035: -- Initialize API return status to success
2036: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2635: END IF;
2636:
2637: ROLLBACK TO g_update_del_GRP;
2638: x_return_status := G_RET_STS_ERROR ;
2639: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2640:
2641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2642: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2643: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');

Line 2657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2653: END IF;
2654:
2655: ROLLBACK TO g_update_del_GRP;
2656: x_return_status := G_RET_STS_UNEXP_ERROR ;
2657: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2658:
2659: WHEN OTHERS THEN
2660: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2661: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

2671: END IF;
2672:
2673: ROLLBACK TO g_update_del_GRP;
2674: x_return_status := G_RET_STS_UNEXP_ERROR ;
2675: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2679:

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

2672:
2673: ROLLBACK TO g_update_del_GRP;
2674: x_return_status := G_RET_STS_UNEXP_ERROR ;
2675: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2679:
2680: END; -- updateDeliverables

Line 2678: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2674: x_return_status := G_RET_STS_UNEXP_ERROR ;
2675: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2676: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2677: END IF;
2678: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2679:
2680: END; -- updateDeliverables
2681:
2682: /**

Line 2717: FND_MSG_PUB.initialize;

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

Line 2744: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2740: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving enableNotifications Unexpected ERROR');
2741: END IF;
2742: ROLLBACK TO g_enable_del_ntf_GRP;
2743: x_return_status := G_RET_STS_ERROR ;
2744: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2745:
2746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2747: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving enableNotifications Unexpected ERROR');

Line 2752: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2748: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving enableNotifications Unexpected ERROR');
2749: END IF;
2750: ROLLBACK TO g_enable_del_ntf_GRP;
2751: x_return_status := G_RET_STS_UNEXP_ERROR ;
2752: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2753:
2754: WHEN OTHERS THEN
2755: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2756: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving enableNotifications because of EXCEPTION: '||substr(sqlerrm,1,200));

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

2756: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving enableNotifications because of EXCEPTION: '||substr(sqlerrm,1,200));
2757: END IF;
2758: ROLLBACK TO g_enable_del_ntf_GRP;
2759: x_return_status := G_RET_STS_UNEXP_ERROR ;
2760: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2764:

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

2757: END IF;
2758: ROLLBACK TO g_enable_del_ntf_GRP;
2759: x_return_status := G_RET_STS_UNEXP_ERROR ;
2760: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2764:
2765: END; -- enableNotifications

Line 2763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2759: x_return_status := G_RET_STS_UNEXP_ERROR ;
2760: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2762: END IF;
2763: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2764:
2765: END; -- enableNotifications
2766:
2767: /**

Line 2802: FND_MSG_PUB.initialize;

2798: END IF;
2799:
2800: -- Initialize message list if p_init_msg_list is set to TRUE.
2801: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2802: FND_MSG_PUB.initialize;
2803: END IF;
2804:
2805: -- Initialize API return status to success
2806: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2846: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2842: COMMIT WORK;
2843: END IF;
2844:
2845: -- Standard call to get message count and if count is 1, get message info.
2846: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2847:
2848: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');
2850: END IF;

Line 2860: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2856: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
2857: END IF;
2858: ROLLBACK TO g_cancel_del_GRP;
2859: x_return_status := G_RET_STS_ERROR ;
2860: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2861:
2862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2863: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2864: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');

Line 2868: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2864: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
2865: END IF;
2866: ROLLBACK TO g_cancel_del_GRP;
2867: x_return_status := G_RET_STS_UNEXP_ERROR ;
2868: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2869:
2870: WHEN OTHERS THEN
2871: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2872: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving cancelDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

2872: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving cancelDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
2873: END IF;
2874: ROLLBACK TO g_cancel_del_GRP;
2875: x_return_status := G_RET_STS_UNEXP_ERROR ;
2876: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2877: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2878: END IF;
2879: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2880:

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

2873: END IF;
2874: ROLLBACK TO g_cancel_del_GRP;
2875: x_return_status := G_RET_STS_UNEXP_ERROR ;
2876: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2877: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2878: END IF;
2879: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2880:
2881: END;

Line 2879: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

2875: x_return_status := G_RET_STS_UNEXP_ERROR ;
2876: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2877: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2878: END IF;
2879: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2880:
2881: END;
2882:
2883: /**

Line 2921: FND_MSG_PUB.initialize;

2917: END IF;
2918:
2919: -- Initialize message list if p_init_msg_list is set to TRUE.
2920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2921: FND_MSG_PUB.initialize;
2922: END IF;
2923:
2924: -- Initialize API return status to success
2925: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3031: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3027: COMMIT WORK;
3028: END IF;
3029:
3030: -- Standard call to get message count and if count is 1, get message info.
3031: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3032:
3033: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3034: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving cancelDeliverables');
3035: END IF;

Line 3045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3041: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving cancelDeliverables Unexpected ERROR');
3042: END IF;
3043: ROLLBACK TO g_cancel2_del_GRP;
3044: x_return_status := G_RET_STS_ERROR ;
3045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3046:
3047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3048:
3049: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3054: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3050: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving cancelDeliverables Unexpected ERROR');
3051: END IF;
3052: ROLLBACK TO g_cancel2_del_GRP;
3053: x_return_status := G_RET_STS_UNEXP_ERROR ;
3054: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3055:
3056: WHEN OTHERS THEN
3057: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving cancelDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3058: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving cancelDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3059: END IF;
3060: ROLLBACK TO g_cancel2_del_GRP;
3061: x_return_status := G_RET_STS_UNEXP_ERROR ;
3062: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3064: END IF;
3065: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3066:

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

3059: END IF;
3060: ROLLBACK TO g_cancel2_del_GRP;
3061: x_return_status := G_RET_STS_UNEXP_ERROR ;
3062: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3064: END IF;
3065: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3066:
3067: END; -- cancelDeliverables

Line 3065: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3061: x_return_status := G_RET_STS_UNEXP_ERROR ;
3062: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3064: END IF;
3065: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3066:
3067: END; -- cancelDeliverables
3068:
3069:

Line 3106: FND_MSG_PUB.initialize;

3102: END IF;
3103:
3104: -- Initialize message list if p_init_msg_list is set to TRUE.
3105: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3106: FND_MSG_PUB.initialize;
3107: END IF;
3108:
3109: -- Initialize API return status to success
3110: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3123: COMMIT WORK;
3124: END IF;
3125:
3126: -- Standard call to get message count and if count is 1, get message info.
3127: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3128:
3129: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3130: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateDeliverables');
3131: END IF;

Line 3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3137: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateDeliverables Unexpected ERROR');
3138: END IF;
3139: ROLLBACK TO g_update_del_GRP;
3140: x_return_status := G_RET_STS_ERROR ;
3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3142:
3143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3144: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3145: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');

Line 3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3145: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateDeliverables Unexpected ERROR');
3146: END IF;
3147: ROLLBACK TO g_update_del_GRP;
3148: x_return_status := G_RET_STS_UNEXP_ERROR ;
3149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3150:
3151: WHEN OTHERS THEN
3152: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3153: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3153: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3154: END IF;
3155: ROLLBACK TO g_update_del_GRP;
3156: x_return_status := G_RET_STS_UNEXP_ERROR ;
3157: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3159: END IF;
3160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3161:

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

3154: END IF;
3155: ROLLBACK TO g_update_del_GRP;
3156: x_return_status := G_RET_STS_UNEXP_ERROR ;
3157: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3159: END IF;
3160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3161:
3162: END; -- updateDeliverables

Line 3160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3156: x_return_status := G_RET_STS_UNEXP_ERROR ;
3157: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3159: END IF;
3160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3161:
3162: END; -- updateDeliverables
3163:
3164: /**

Line 3209: FND_MSG_PUB.initialize;

3205: END IF;
3206:
3207: -- Initialize message list if p_init_msg_list is set to TRUE.
3208: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3209: FND_MSG_PUB.initialize;
3210: END IF;
3211:
3212: -- Initialize API return status to success
3213: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3239: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3235: COMMIT WORK;
3236: END IF;
3237:
3238: -- Standard call to get message count and if count is 1, get message info.
3239: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3240:
3241: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateBuyerDeliverables');
3243: END IF;

Line 3253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3249: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateBuyerDeliverables Unexpected ERROR');
3250: END IF;
3251: ROLLBACK TO g_update2_del_GRP;
3252: x_return_status := G_RET_STS_ERROR ;
3253: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3254:
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3258: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateBuyerDeliverables Unexpected ERROR');
3259: END IF;
3260: ROLLBACK TO g_update2_del_GRP;
3261: x_return_status := G_RET_STS_UNEXP_ERROR ;
3262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3263:
3264: WHEN OTHERS THEN
3265: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3266: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateBuyerDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3266: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateBuyerDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3267: END IF;
3268: ROLLBACK TO g_update2_del_GRP;
3269: x_return_status := G_RET_STS_UNEXP_ERROR ;
3270: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3272: END IF;
3273: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3274:

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

3267: END IF;
3268: ROLLBACK TO g_update2_del_GRP;
3269: x_return_status := G_RET_STS_UNEXP_ERROR ;
3270: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3272: END IF;
3273: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3274:
3275: END; -- updateBuyerDeliverables

Line 3273: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3269: x_return_status := G_RET_STS_UNEXP_ERROR ;
3270: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3272: END IF;
3273: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3274:
3275: END; -- updateBuyerDeliverables
3276:
3277: /**

Line 3311: FND_MSG_PUB.initialize;

3307: END IF;
3308:
3309: -- Initialize message list if p_init_msg_list is set to TRUE.
3310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3311: FND_MSG_PUB.initialize;
3312: END IF;
3313:
3314: -- Initialize API return status to success
3315: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3346: COMMIT WORK;
3347: END IF;
3348:
3349: -- Standard call to get message count and if count is 1, get message info.
3350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3351:
3352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'400: Leaving disableDeliverables');
3354: END IF;

Line 3364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3360: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving disableDeliverables Unexpected ERROR');
3361: END IF;
3362: ROLLBACK TO g_disable_del_GRP;
3363: x_return_status := G_RET_STS_ERROR ;
3364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3365:
3366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3367: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving disableDeliverables Unexpected ERROR');

Line 3372: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving disableDeliverables Unexpected ERROR');
3369: END IF;
3370: ROLLBACK TO g_disable_del_GRP;
3371: x_return_status := G_RET_STS_UNEXP_ERROR ;
3372: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3373:
3374: WHEN OTHERS THEN
3375: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3376: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving disableDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3376: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving disableDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3377: END IF;
3378: ROLLBACK TO g_disable_del_GRP;
3379: x_return_status := G_RET_STS_UNEXP_ERROR ;
3380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3382: END IF;
3383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3384:

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

3377: END IF;
3378: ROLLBACK TO g_disable_del_GRP;
3379: x_return_status := G_RET_STS_UNEXP_ERROR ;
3380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3382: END IF;
3383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3384:
3385: END; --disableDeliverables

Line 3383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3379: x_return_status := G_RET_STS_UNEXP_ERROR ;
3380: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3382: END IF;
3383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3384:
3385: END; --disableDeliverables
3386:
3387:

Line 3426: FND_MSG_PUB.initialize;

3422: END IF;
3423:
3424: -- Initialize message list if p_init_msg_list is set to TRUE.
3425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3426: FND_MSG_PUB.initialize;
3427: END IF;
3428:
3429: -- Initialize API return status to success
3430: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3444: COMMIT WORK;
3445: END IF;
3446:
3447: -- Standard call to get message count and if count is 1, get message info.
3448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3449:
3450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables');
3452: END IF;

Line 3462: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3458: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3459: END IF;
3460: ROLLBACK TO g_update_del_GRP;
3461: x_return_status := G_RET_STS_ERROR ;
3462: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3463:
3464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3465: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3466: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');

Line 3470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3466: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3467: END IF;
3468: ROLLBACK TO g_update_del_GRP;
3469: x_return_status := G_RET_STS_UNEXP_ERROR ;
3470: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3471:
3472: WHEN OTHERS THEN
3473: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3474: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3474: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3475: END IF;
3476: ROLLBACK TO g_update_del_GRP;
3477: x_return_status := G_RET_STS_UNEXP_ERROR ;
3478: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3482:

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

3475: END IF;
3476: ROLLBACK TO g_update_del_GRP;
3477: x_return_status := G_RET_STS_UNEXP_ERROR ;
3478: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3482:
3483: END; -- updateIntContactOnDeliverables

Line 3481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3477: x_return_status := G_RET_STS_UNEXP_ERROR ;
3478: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3480: END IF;
3481: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3482:
3483: END; -- updateIntContactOnDeliverables
3484:
3485:

Line 3531: FND_MSG_PUB.initialize;

3527: END IF;
3528:
3529: -- Initialize message list if p_init_msg_list is set to TRUE.
3530: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3531: FND_MSG_PUB.initialize;
3532: END IF;
3533:
3534: -- Initialize API return status to success
3535: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3562: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3558: COMMIT WORK;
3559: END IF;
3560:
3561: -- Standard call to get message count and if count is 1, get message info.
3562: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3563:
3564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables');
3566: END IF;

Line 3576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3572: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3573: END IF;
3574: ROLLBACK TO g_update2_del_GRP;
3575: x_return_status := G_RET_STS_ERROR ;
3576: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3577:
3578:
3579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3580: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3581: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateIntContactOnDeliverables Unexpected ERROR');
3582: END IF;
3583: ROLLBACK TO g_update2_del_GRP;
3584: x_return_status := G_RET_STS_UNEXP_ERROR ;
3585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3586:
3587: WHEN OTHERS THEN
3588: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3589: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3589: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateIntContactOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3590: END IF;
3591: ROLLBACK TO g_update2_del_GRP;
3592: x_return_status := G_RET_STS_UNEXP_ERROR ;
3593: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3595: END IF;
3596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3597:

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

3590: END IF;
3591: ROLLBACK TO g_update2_del_GRP;
3592: x_return_status := G_RET_STS_UNEXP_ERROR ;
3593: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3595: END IF;
3596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3597:
3598: END; -- updateIntContactOnDeliverables

Line 3596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3592: x_return_status := G_RET_STS_UNEXP_ERROR ;
3593: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3595: END IF;
3596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3597:
3598: END; -- updateIntContactOnDeliverables
3599:
3600: /**

Line 3637: FND_MSG_PUB.initialize;

3633: END IF;
3634:
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3637: FND_MSG_PUB.initialize;
3638: END IF;
3639:
3640: -- Initialize API return status to success
3641: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3655: COMMIT WORK;
3656: END IF;
3657:
3658: -- Standard call to get message count and if count is 1, get message info.
3659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3660:
3661: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3662: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables ');
3663: END IF;

Line 3673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3669: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3670: END IF;
3671: ROLLBACK TO g_update_del_GRP;
3672: x_return_status := G_RET_STS_ERROR ;
3673: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3674:
3675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3676: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3677: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');

Line 3681: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3677: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3678: END IF;
3679: ROLLBACK TO g_update_del_GRP;
3680: x_return_status := G_RET_STS_UNEXP_ERROR ;
3681: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3682:
3683: WHEN OTHERS THEN
3684: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3685: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3685: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
3686: END IF;
3687: ROLLBACK TO g_update_del_GRP;
3688: x_return_status := G_RET_STS_UNEXP_ERROR ;
3689: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3691: END IF;
3692: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3693:

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

3686: END IF;
3687: ROLLBACK TO g_update_del_GRP;
3688: x_return_status := G_RET_STS_UNEXP_ERROR ;
3689: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3691: END IF;
3692: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3693:
3694: END; -- updateExtPartyOnDeliverables

Line 3692: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3688: x_return_status := G_RET_STS_UNEXP_ERROR ;
3689: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3690: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3691: END IF;
3692: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3693:
3694: END; -- updateExtPartyOnDeliverables
3695:
3696: /**

Line 3755: FND_MSG_PUB.initialize;

3751: END IF;
3752:
3753: -- Initialize message list if p_init_msg_list is set to TRUE.
3754: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3755: FND_MSG_PUB.initialize;
3756: END IF;
3757:
3758: -- Initialize API return status to success
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3818: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3814: CLOSE del_cur ;
3815: END IF;
3816: ROLLBACK TO g_update_del_GRP;
3817: x_return_status := G_RET_STS_ERROR ;
3818: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3819:
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3821: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3822: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');

Line 3826: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3822: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving updateExtPartyOnDeliverables Unexpected ERROR');
3823: END IF;
3824: ROLLBACK TO g_update_del_GRP;
3825: x_return_status := G_RET_STS_UNEXP_ERROR ;
3826: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3827:
3828: WHEN OTHERS THEN
3829: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3830: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving updateExtPartyOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

3835: END IF;
3836:
3837: ROLLBACK TO g_update_del_GRP;
3838: x_return_status := G_RET_STS_UNEXP_ERROR ;
3839: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3841: END IF;
3842: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3843:

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

3836:
3837: ROLLBACK TO g_update_del_GRP;
3838: x_return_status := G_RET_STS_UNEXP_ERROR ;
3839: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3841: END IF;
3842: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3843:
3844: END;

Line 3842: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

3838: x_return_status := G_RET_STS_UNEXP_ERROR ;
3839: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3840: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3841: END IF;
3842: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3843:
3844: END;
3845:
3846: /**

Line 3937: FND_MSG_PUB.initialize;

3933: END IF;
3934:
3935: -- Initialize message list if p_init_msg_list is set to TRUE.
3936: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3937: FND_MSG_PUB.initialize;
3938: END IF;
3939:
3940: --loop thru deliverables where only the notes have changed
3941: FOR status_notes_rec IN status_notes_cur LOOP

Line 4043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4039: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving postDelStatusChanges Unexpected ERROR');
4040: END IF;
4041: ROLLBACK TO g_createHistory_GRP;
4042: x_return_status := G_RET_STS_ERROR ;
4043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4044:
4045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4046: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4047: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving postDelStatusChanges Unexpected ERROR');

Line 4051: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4047: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving postDelStatusChanges Unexpected ERROR');
4048: END IF;
4049: ROLLBACK TO g_createHistory_GRP;
4050: x_return_status := G_RET_STS_UNEXP_ERROR ;
4051: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4052:
4053: WHEN OTHERS THEN
4054: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4055: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving postDelStatusChanges because of EXCEPTION: '||substr(sqlerrm,1,200));

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

4055: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving postDelStatusChanges because of EXCEPTION: '||substr(sqlerrm,1,200));
4056: END IF;
4057: ROLLBACK TO g_createHistory_GRP;
4058: x_return_status := G_RET_STS_UNEXP_ERROR ;
4059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4061: END IF;
4062: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4063:

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

4056: END IF;
4057: ROLLBACK TO g_createHistory_GRP;
4058: x_return_status := G_RET_STS_UNEXP_ERROR ;
4059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4061: END IF;
4062: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4063:
4064: END; -- postDelStatusChanges

Line 4062: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4058: x_return_status := G_RET_STS_UNEXP_ERROR ;
4059: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4061: END IF;
4062: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4063:
4064: END; -- postDelStatusChanges
4065:
4066: /** 11.5.10+ code

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

4140: CLOSE del_cur ;
4141: END IF;
4142:
4143: x_return_status := G_RET_STS_UNEXP_ERROR ;
4144: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4146: END IF;
4147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4148: , p_count => x_msg_count

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

4141: END IF;
4142:
4143: x_return_status := G_RET_STS_UNEXP_ERROR ;
4144: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4146: END IF;
4147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4148: , p_count => x_msg_count
4149: , p_data => x_msg_data );

Line 4147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

4143: x_return_status := G_RET_STS_UNEXP_ERROR ;
4144: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4146: END IF;
4147: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4148: , p_count => x_msg_count
4149: , p_data => x_msg_data );
4150:
4151: RETURN null;

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

4220: CLOSE del_cur ;
4221: END IF;
4222:
4223: x_return_status := G_RET_STS_UNEXP_ERROR ;
4224: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4226: END IF;
4227: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4228: , p_count => x_msg_count

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

4221: END IF;
4222:
4223: x_return_status := G_RET_STS_UNEXP_ERROR ;
4224: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4226: END IF;
4227: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4228: , p_count => x_msg_count
4229: , p_data => x_msg_data );

Line 4227: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

4223: x_return_status := G_RET_STS_UNEXP_ERROR ;
4224: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4226: END IF;
4227: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
4228: , p_count => x_msg_count
4229: , p_data => x_msg_data );
4230:
4231: RETURN null;

Line 4296: FND_MSG_PUB.initialize;

4292: END IF;
4293:
4294: -- Initialize message list if p_init_msg_list is set to TRUE.
4295: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4296: FND_MSG_PUB.initialize;
4297: END IF;
4298:
4299: -- Initialize API return status to success
4300: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4343: CLOSE del_cur ;
4344: END IF;
4345: ROLLBACK TO g_update_del_GRP;
4346: x_return_status := G_RET_STS_ERROR ;
4347: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4348:
4349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4350: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4351: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');

Line 4355: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4351: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving mergeExtPartyOnDeliverables Unexpected ERROR');
4352: END IF;
4353: ROLLBACK TO g_update_del_GRP;
4354: x_return_status := G_RET_STS_UNEXP_ERROR ;
4355: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4356:
4357: WHEN OTHERS THEN
4358: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4359: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving mergeExtPartyOnDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

4364: END IF;
4365:
4366: ROLLBACK TO g_update_del_GRP;
4367: x_return_status := G_RET_STS_UNEXP_ERROR ;
4368: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4370: END IF;
4371: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4372:

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

4365:
4366: ROLLBACK TO g_update_del_GRP;
4367: x_return_status := G_RET_STS_UNEXP_ERROR ;
4368: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4370: END IF;
4371: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4372:
4373: END; -- mergeExtPartyOnDeliverables

Line 4371: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4367: x_return_status := G_RET_STS_UNEXP_ERROR ;
4368: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4369: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4370: END IF;
4371: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4372:
4373: END; -- mergeExtPartyOnDeliverables
4374:
4375: /**

Line 4412: FND_MSG_PUB.initialize;

4408: END IF;
4409:
4410: -- Initialize message list if p_init_msg_list is set to TRUE.
4411: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4412: FND_MSG_PUB.initialize;
4413: END IF;
4414:
4415: -- Initialize API return status to success
4416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4483: COMMIT WORK;
4484: END IF;
4485:
4486: -- Standard call to get message count and if count is 1, get message info.
4487: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4488:
4489: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving activateCloseoutDeliverables');
4491: END IF;

Line 4501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4497: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving activateCloseoutDeliverables Unexpected ERROR');
4498: END IF;
4499: ROLLBACK TO g_activatecloseout_del_GRP;
4500: x_return_status := G_RET_STS_ERROR ;
4501: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4502:
4503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4504:
4505: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4506: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving activateCloseoutDeliverables Unexpected ERROR');
4507: END IF;
4508: ROLLBACK TO g_activatecloseout_del_GRP;
4509: x_return_status := G_RET_STS_UNEXP_ERROR ;
4510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4511:
4512: WHEN OTHERS THEN
4513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving activateCloseoutDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));

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

4514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving activateCloseoutDeliverables because of EXCEPTION: '||substr(sqlerrm,1,200));
4515: END IF;
4516: ROLLBACK TO g_activatecloseout_del_GRP;
4517: x_return_status := G_RET_STS_UNEXP_ERROR ;
4518: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4520: END IF;
4521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4522:

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

4515: END IF;
4516: ROLLBACK TO g_activatecloseout_del_GRP;
4517: x_return_status := G_RET_STS_UNEXP_ERROR ;
4518: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4520: END IF;
4521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4522:
4523: END; -- activateCloseoutDeliverables

Line 4521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

4517: x_return_status := G_RET_STS_UNEXP_ERROR ;
4518: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4520: END IF;
4521: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4522:
4523: END; -- activateCloseoutDeliverables
4524:
4525: /*-- Start of comments

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

4625: END IF;
4626: IF getDeliverables %ISOPEN THEN
4627: CLOSE getDeliverables ;
4628: END IF;
4629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4631: END IF;
4632: x_return_status := G_RET_STS_ERROR;
4633: FND_MSG_PUB.Count_And_Get(

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

4626: IF getDeliverables %ISOPEN THEN
4627: CLOSE getDeliverables ;
4628: END IF;
4629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4631: END IF;
4632: x_return_status := G_RET_STS_ERROR;
4633: FND_MSG_PUB.Count_And_Get(
4634: p_count => x_msg_count,

Line 4633: FND_MSG_PUB.Count_And_Get(

4629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4631: END IF;
4632: x_return_status := G_RET_STS_ERROR;
4633: FND_MSG_PUB.Count_And_Get(
4634: p_count => x_msg_count,
4635: p_data => x_msg_data
4636: );
4637:

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

4725: END IF;
4726: IF del_cur%ISOPEN THEN
4727: CLOSE del_cur ;
4728: END IF;
4729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4730: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4731: END IF;
4732: RETURN null;
4733:

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

4726: IF del_cur%ISOPEN THEN
4727: CLOSE del_cur ;
4728: END IF;
4729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4730: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4731: END IF;
4732: RETURN null;
4733:
4734: END checkDeliverablePayHold;