eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EVENT_PUB dependencies on FND_MSG_PUB

Line 262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

258: If PA_EVENT_UTILS.CHECK_VALID_PROJECT
259: (P_project_id =>P_project_id
260: ,P_project_num =>P_event_in_rec.P_project_number) = 'N'
261: Then
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
263: THEN
264: pa_interface_utils_pub.map_new_amg_msg
265: ( p_old_message_code => 'PA_INVALID_PROJECT'
266: ,p_msg_attribute => 'CHANGE'

Line 393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

389: ,p_return_msg => p_return_msg
390: ,p_valid_status => p_validate_status);
391: IF p_validate_status = 'N'
392: THEN
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
394: THEN
395: pa_interface_utils_pub.map_new_amg_msg
396: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
397: ,p_msg_attribute => 'CHANGE'

Line 986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

982: PA_EVENT_PUB.PACKAGE_NAME
983: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
984: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
985:
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: FND_MSG_PUB.add_exc_msg
989: ( p_pkg_name => PACKAGE_NAME
990: , p_procedure_name => PROCEDURE_NAME );

Line 988: FND_MSG_PUB.add_exc_msg

984: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
985:
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
987: THEN
988: FND_MSG_PUB.add_exc_msg
989: ( p_pkg_name => PACKAGE_NAME
990: , p_procedure_name => PROCEDURE_NAME );
991: PACKAGE_NAME:=NULL;
992: PROCEDURE_NAME:=NULL;

Line 1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

999: PA_EVENT_PUB.PACKAGE_NAME
1000: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1001: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1002:
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.add_exc_msg
1006: ( p_pkg_name => PACKAGE_NAME
1007: , p_procedure_name => PROCEDURE_NAME );

Line 1005: FND_MSG_PUB.add_exc_msg

1001: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1002:
1003: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1004: THEN
1005: FND_MSG_PUB.add_exc_msg
1006: ( p_pkg_name => PACKAGE_NAME
1007: , p_procedure_name => PROCEDURE_NAME );
1008: PACKAGE_NAME:=NULL;
1009: PROCEDURE_NAME:=NULL;

Line 1030: FND_MSG_PUB.Count_And_Get

1026: --Setting the return status to false even if one record fails the validation.
1027: p_return_status := l_return_status;
1028:
1029: --Extracting and returning error message if message count is 1.
1030: FND_MSG_PUB.Count_And_Get
1031: ( p_encoded => l_encoded
1032: ,p_count => p_msg_count
1033: ,p_data => p_msg_data );
1034:

Line 1040: FND_MSG_PUB.Count_And_Get

1036: EXCEPTION
1037: WHEN FND_API.G_EXC_ERROR
1038: THEN
1039: p_return_status := FND_API.G_RET_STS_ERROR;
1040: FND_MSG_PUB.Count_And_Get
1041: ( p_encoded => l_encoded
1042: ,p_count => p_msg_count
1043: ,p_data => p_msg_data );
1044:

Line 1048: FND_MSG_PUB.Count_And_Get

1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1046: THEN
1047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: FND_MSG_PUB.Count_And_Get
1049: ( p_encoded => l_encoded
1050: ,p_count => p_msg_count
1051: ,p_data => p_msg_data );
1052:

Line 1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1056: PA_EVENT_PUB.PACKAGE_NAME
1057: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1058: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1059:
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1061: THEN
1062: FND_MSG_PUB.add_exc_msg
1063: ( p_pkg_name => PACKAGE_NAME
1064: , p_procedure_name => PROCEDURE_NAME );

Line 1062: FND_MSG_PUB.add_exc_msg

1058: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1059:
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1061: THEN
1062: FND_MSG_PUB.add_exc_msg
1063: ( p_pkg_name => PACKAGE_NAME
1064: , p_procedure_name => PROCEDURE_NAME );
1065: PACKAGE_NAME:=NULL;
1066: PROCEDURE_NAME:=NULL;

Line 1069: FND_MSG_PUB.Count_And_Get

1065: PACKAGE_NAME:=NULL;
1066: PROCEDURE_NAME:=NULL;
1067: END IF;
1068:
1069: FND_MSG_PUB.Count_And_Get
1070: ( p_encoded => l_encoded
1071: ,p_count => p_msg_count
1072: ,p_data => p_msg_data );
1073:

Line 1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1077: PA_EVENT_PUB.PACKAGE_NAME
1078: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1079: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1080:
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.add_exc_msg
1084: ( p_pkg_name => PACKAGE_NAME
1085: , p_procedure_name => PROCEDURE_NAME );

Line 1083: FND_MSG_PUB.add_exc_msg

1079: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1080:
1081: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1082: THEN
1083: FND_MSG_PUB.add_exc_msg
1084: ( p_pkg_name => PACKAGE_NAME
1085: , p_procedure_name => PROCEDURE_NAME );
1086: PACKAGE_NAME:=NULL;
1087: PROCEDURE_NAME:=NULL;

Line 1090: FND_MSG_PUB.Count_And_Get

1086: PACKAGE_NAME:=NULL;
1087: PROCEDURE_NAME:=NULL;
1088: END IF;
1089:
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_encoded => l_encoded
1092: ,p_count => p_msg_count
1093: ,p_data => p_msg_data );
1094:

Line 1388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1384:
1385: --validation to be done only if project number is provided.
1386: If (P_project_id <> nvl(l_project_id,P_project_id))
1387: Then
1388: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1389: THEN
1390: pa_interface_utils_pub.map_new_amg_msg
1391: ( p_old_message_code => 'PA_EV_REF_PROJ_MISS'
1392: ,p_msg_attribute => 'CHANGE'

Line 1561: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1557: ,p_return_msg => p_return_msg
1558: ,p_valid_status => p_validate_status);
1559: IF p_validate_status = 'N'
1560: THEN
1561: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1562: THEN
1563: pa_interface_utils_pub.map_new_amg_msg
1564: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1565: ,p_msg_attribute => 'CHANGE'

Line 2195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2191: -- Till here
2192:
2193: IF nvl(l_record_version_number, 0) <> nvl(p_event_in_rec.P_record_version_number, 0)
2194: Then
2195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2196: THEN
2197: pa_interface_utils_pub.map_new_amg_msg
2198: ( p_old_message_code => 'PA_RECORD_CHANGED'
2199: ,p_msg_attribute => 'CHANGE'

Line 2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2833: PA_EVENT_PUB.PACKAGE_NAME
2834: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2835: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2836:
2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2838: THEN
2839: FND_MSG_PUB.add_exc_msg
2840: ( p_pkg_name => PACKAGE_NAME
2841: , p_procedure_name => PROCEDURE_NAME );

Line 2839: FND_MSG_PUB.add_exc_msg

2835: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2836:
2837: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2838: THEN
2839: FND_MSG_PUB.add_exc_msg
2840: ( p_pkg_name => PACKAGE_NAME
2841: , p_procedure_name => PROCEDURE_NAME );
2842: PACKAGE_NAME:=NULL;
2843: PROCEDURE_NAME:=NULL;

Line 2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2850: PA_EVENT_PUB.PACKAGE_NAME
2851: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2852: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2853:
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2855: THEN
2856: FND_MSG_PUB.add_exc_msg
2857: ( p_pkg_name => PACKAGE_NAME
2858: , p_procedure_name => PROCEDURE_NAME );

Line 2856: FND_MSG_PUB.add_exc_msg

2852: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2853:
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2855: THEN
2856: FND_MSG_PUB.add_exc_msg
2857: ( p_pkg_name => PACKAGE_NAME
2858: , p_procedure_name => PROCEDURE_NAME );
2859: PACKAGE_NAME:=NULL;
2860: PROCEDURE_NAME:=NULL;

Line 2881: FND_MSG_PUB.Count_And_Get

2877: --Setting the return status to false even if one record fails the validation.
2878: p_return_status := l_return_status;
2879:
2880: --If there is one error message then extract the error meaasge and return it.
2881: FND_MSG_PUB.Count_And_Get
2882: ( p_encoded => l_encoded
2883: ,p_count => p_msg_count
2884: ,p_data => p_msg_data );
2885:

Line 2890: FND_MSG_PUB.Count_And_Get

2886: EXCEPTION
2887: WHEN FND_API.G_EXC_ERROR
2888: THEN
2889: p_return_status := FND_API.G_RET_STS_ERROR;
2890: FND_MSG_PUB.Count_And_Get
2891: ( p_encoded => l_encoded
2892: ,p_count => p_msg_count
2893: ,p_data => p_msg_data );
2894:

Line 2898: FND_MSG_PUB.Count_And_Get

2894:
2895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2896: THEN
2897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2898: FND_MSG_PUB.Count_And_Get
2899: ( p_encoded => l_encoded
2900: ,p_count => p_msg_count
2901: ,p_data => p_msg_data );
2902:

Line 2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2906: PA_EVENT_PUB.PACKAGE_NAME
2907: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2908: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2909:
2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2911: THEN
2912: FND_MSG_PUB.add_exc_msg
2913: ( p_pkg_name => PACKAGE_NAME
2914: , p_procedure_name => PROCEDURE_NAME );

Line 2912: FND_MSG_PUB.add_exc_msg

2908: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2909:
2910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2911: THEN
2912: FND_MSG_PUB.add_exc_msg
2913: ( p_pkg_name => PACKAGE_NAME
2914: , p_procedure_name => PROCEDURE_NAME );
2915: PACKAGE_NAME:=NULL;
2916: PROCEDURE_NAME:=NULL;

Line 2918: FND_MSG_PUB.Count_And_Get

2914: , p_procedure_name => PROCEDURE_NAME );
2915: PACKAGE_NAME:=NULL;
2916: PROCEDURE_NAME:=NULL;
2917: END IF;
2918: FND_MSG_PUB.Count_And_Get
2919: ( p_encoded => l_encoded
2920: ,p_count => p_msg_count
2921: ,p_data => p_msg_data );
2922:

Line 2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2927: PA_EVENT_PUB.PACKAGE_NAME
2928: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2929: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2930:
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2932: THEN
2933: FND_MSG_PUB.add_exc_msg
2934: ( p_pkg_name => PACKAGE_NAME
2935: , p_procedure_name => PROCEDURE_NAME );

Line 2933: FND_MSG_PUB.add_exc_msg

2929: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2930:
2931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2932: THEN
2933: FND_MSG_PUB.add_exc_msg
2934: ( p_pkg_name => PACKAGE_NAME
2935: , p_procedure_name => PROCEDURE_NAME );
2936: PACKAGE_NAME:=NULL;
2937: PROCEDURE_NAME:=NULL;

Line 2940: FND_MSG_PUB.Count_And_Get

2936: PACKAGE_NAME:=NULL;
2937: PROCEDURE_NAME:=NULL;
2938: END IF;
2939:
2940: FND_MSG_PUB.Count_And_Get
2941: ( p_encoded => l_encoded
2942: ,p_count => p_msg_count
2943: ,p_data => p_msg_data );
2944:

Line 3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3087: If PA_EVENT_PVT.CHECK_DELETE_EVENT_OK
3088: (P_pm_event_reference =>l_pm_event_reference
3089: ,P_event_id =>l_event_id_out) ='N'
3090: Then
3091: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3092: THEN
3093: pa_interface_utils_pub.map_new_amg_msg
3094: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
3095: ,p_msg_attribute => 'CHANGE'

Line 3139: FND_MSG_PUB.Count_And_Get

3135: END IF;
3136:
3137:
3138: --If there is one error message then extract the error meaasge
3139: FND_MSG_PUB.Count_And_Get
3140: ( p_encoded => l_encoded
3141: ,p_count => p_msg_count
3142: ,p_data => p_msg_data );
3143:

Line 3152: FND_MSG_PUB.Count_And_Get

3148: WHEN FND_API.G_EXC_ERROR
3149: THEN
3150: ROLLBACK to delete_event;
3151: p_return_status := FND_API.G_RET_STS_ERROR;
3152: FND_MSG_PUB.Count_And_Get
3153: ( p_encoded => l_encoded
3154: , p_count => p_msg_count
3155: , p_data => p_msg_data );
3156:

Line 3161: FND_MSG_PUB.Count_And_Get

3157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3158: THEN
3159: ROLLBACK to delete_event;
3160: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3161: FND_MSG_PUB.Count_And_Get
3162: ( p_encoded => l_encoded
3163: , p_count => p_msg_count
3164: , p_data => p_msg_data );
3165:

Line 3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3171: PA_EVENT_PUB.PACKAGE_NAME
3172: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3173: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3174:
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3176: THEN
3177: FND_MSG_PUB.add_exc_msg
3178: ( p_pkg_name => PACKAGE_NAME
3179: , p_procedure_name => PROCEDURE_NAME );

Line 3177: FND_MSG_PUB.add_exc_msg

3173: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3174:
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3176: THEN
3177: FND_MSG_PUB.add_exc_msg
3178: ( p_pkg_name => PACKAGE_NAME
3179: , p_procedure_name => PROCEDURE_NAME );
3180: PACKAGE_NAME:=NULL;
3181: PROCEDURE_NAME:=NULL;

Line 3184: FND_MSG_PUB.Count_And_Get

3180: PACKAGE_NAME:=NULL;
3181: PROCEDURE_NAME:=NULL;
3182: END IF;
3183:
3184: FND_MSG_PUB.Count_And_Get
3185: ( p_encoded => l_encoded
3186: , p_count => p_msg_count
3187: , p_data => p_msg_data );
3188:

Line 3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3194: PA_EVENT_PUB.PACKAGE_NAME
3195: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3196: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN
3200: FND_MSG_PUB.add_exc_msg
3201: ( p_pkg_name => PACKAGE_NAME
3202: , p_procedure_name => PROCEDURE_NAME );

Line 3200: FND_MSG_PUB.add_exc_msg

3196: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN
3200: FND_MSG_PUB.add_exc_msg
3201: ( p_pkg_name => PACKAGE_NAME
3202: , p_procedure_name => PROCEDURE_NAME );
3203: PACKAGE_NAME:=NULL;
3204: PROCEDURE_NAME:=NULL;

Line 3207: FND_MSG_PUB.Count_And_Get

3203: PACKAGE_NAME:=NULL;
3204: PROCEDURE_NAME:=NULL;
3205: END IF;
3206:
3207: FND_MSG_PUB.Count_And_Get
3208: ( p_encoded => l_encoded
3209: , p_count => p_msg_count
3210: , p_data => p_msg_data );
3211:

Line 3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3237: PA_EVENT_PUB.PACKAGE_NAME
3238: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3239: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3240:
3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3242: THEN
3243: FND_MSG_PUB.add_exc_msg
3244: ( p_pkg_name => PACKAGE_NAME
3245: , p_procedure_name => PROCEDURE_NAME );

Line 3243: FND_MSG_PUB.add_exc_msg

3239: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'INIT_EVENT';
3240:
3241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3242: THEN
3243: FND_MSG_PUB.add_exc_msg
3244: ( p_pkg_name => PACKAGE_NAME
3245: , p_procedure_name => PROCEDURE_NAME );
3246: PACKAGE_NAME:=NULL;
3247: PROCEDURE_NAME:=NULL;

Line 3428: FND_MSG_PUB.Count_And_Get

3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR
3426: THEN
3427: p_return_status := FND_API.G_RET_STS_ERROR;
3428: FND_MSG_PUB.Count_And_Get
3429: ( p_count => p_msg_count ,
3430: p_data => p_msg_data );
3431:
3432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3435: FND_MSG_PUB.Count_And_Get

3431:
3432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3433: THEN
3434: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3435: FND_MSG_PUB.Count_And_Get
3436: ( p_count => p_msg_count
3437: , p_data => p_msg_data );
3438:
3439: WHEN OTHERS

Line 3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3443: PA_EVENT_PUB.PACKAGE_NAME
3444: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3445: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3446:
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN
3449: FND_MSG_PUB.add_exc_msg
3450: ( p_pkg_name => PACKAGE_NAME
3451: , p_procedure_name => PROCEDURE_NAME );

Line 3449: FND_MSG_PUB.add_exc_msg

3445: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3446:
3447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3448: THEN
3449: FND_MSG_PUB.add_exc_msg
3450: ( p_pkg_name => PACKAGE_NAME
3451: , p_procedure_name => PROCEDURE_NAME );
3452: PACKAGE_NAME:=NULL;
3453: PROCEDURE_NAME:=NULL;

Line 3456: FND_MSG_PUB.Count_And_Get

3452: PACKAGE_NAME:=NULL;
3453: PROCEDURE_NAME:=NULL;
3454: END IF;
3455:
3456: FND_MSG_PUB.Count_And_Get
3457: ( p_count => p_msg_count ,
3458: p_data => p_msg_data );
3459:
3460:

Line 3565: FND_MSG_PUB.Count_And_Get

3561: WHEN FND_API.G_EXC_ERROR
3562: THEN
3563: p_event_id_out := NULL; -- NOCOPY
3564: p_return_status := FND_API.G_RET_STS_ERROR;
3565: FND_MSG_PUB.Count_And_Get
3566: ( p_encoded => l_encoded
3567: ,p_count => p_msg_count
3568: ,p_data => p_msg_data );
3569:

Line 3574: FND_MSG_PUB.Count_And_Get

3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3571: THEN
3572: p_event_id_out := NULL; -- NOCOPY
3573: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3574: FND_MSG_PUB.Count_And_Get
3575: ( p_encoded => l_encoded
3576: ,p_count => p_msg_count
3577: ,p_data => p_msg_data );
3578:

Line 3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3584: PA_EVENT_PUB.PACKAGE_NAME
3585: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3586: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3589: THEN
3590: FND_MSG_PUB.add_exc_msg
3591: ( p_pkg_name => PACKAGE_NAME
3592: , p_procedure_name => PROCEDURE_NAME );

Line 3590: FND_MSG_PUB.add_exc_msg

3586: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3589: THEN
3590: FND_MSG_PUB.add_exc_msg
3591: ( p_pkg_name => PACKAGE_NAME
3592: , p_procedure_name => PROCEDURE_NAME );
3593: PACKAGE_NAME:=NULL;
3594: PROCEDURE_NAME:=NULL;

Line 3597: FND_MSG_PUB.Count_And_Get

3593: PACKAGE_NAME:=NULL;
3594: PROCEDURE_NAME:=NULL;
3595: END IF;
3596:
3597: FND_MSG_PUB.Count_And_Get
3598: ( p_encoded => l_encoded
3599: ,p_count => p_msg_count
3600: ,p_data => p_msg_data );
3601:

Line 3701: FND_MSG_PUB.Count_And_Get

3697: EXCEPTION
3698: WHEN FND_API.G_EXC_ERROR
3699: THEN
3700: p_return_status := FND_API.G_RET_STS_ERROR;
3701: FND_MSG_PUB.Count_And_Get
3702: ( p_encoded => l_encoded
3703: ,p_count => p_msg_count
3704: ,p_data => p_msg_data );
3705:

Line 3709: FND_MSG_PUB.Count_And_Get

3705:
3706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3707: THEN
3708: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3709: FND_MSG_PUB.Count_And_Get
3710: ( p_encoded => l_encoded
3711: ,p_count => p_msg_count
3712: ,p_data => p_msg_data );
3713:

Line 3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3718: PA_EVENT_PUB.PACKAGE_NAME
3719: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3721:
3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3723: THEN
3724: FND_MSG_PUB.add_exc_msg
3725: ( p_pkg_name => PACKAGE_NAME
3726: , p_procedure_name => PROCEDURE_NAME );

Line 3724: FND_MSG_PUB.add_exc_msg

3720: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3721:
3722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3723: THEN
3724: FND_MSG_PUB.add_exc_msg
3725: ( p_pkg_name => PACKAGE_NAME
3726: , p_procedure_name => PROCEDURE_NAME );
3727: PACKAGE_NAME:=NULL;
3728: PROCEDURE_NAME:=NULL;

Line 3731: FND_MSG_PUB.Count_And_Get

3727: PACKAGE_NAME:=NULL;
3728: PROCEDURE_NAME:=NULL;
3729: END IF;
3730:
3731: FND_MSG_PUB.Count_And_Get
3732: ( p_encoded => l_encoded
3733: ,p_count => p_msg_count
3734: ,p_data => p_msg_data );
3735:

Line 3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3760: PA_EVENT_PUB.PACKAGE_NAME
3761: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3762: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3763:
3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.add_exc_msg
3767: ( p_pkg_name => PACKAGE_NAME
3768: , p_procedure_name => PROCEDURE_NAME );

Line 3766: FND_MSG_PUB.add_exc_msg

3762: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CLEAR_EVENT';
3763:
3764: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.add_exc_msg
3767: ( p_pkg_name => PACKAGE_NAME
3768: , p_procedure_name => PROCEDURE_NAME );
3769: PACKAGE_NAME:=NULL;
3770: PROCEDURE_NAME:=NULL;

Line 3841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3837:
3838: IF (p_pm_product_code IS NULL)
3839: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3840: THEN
3841: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3842: THEN
3843: pa_interface_utils_pub.map_new_amg_msg
3844: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3845: ,p_msg_attribute => 'CHANGE'

Line 3880: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3876: End If;
3877: tot_recs :=tot_recs + 1;
3878: End Loop;
3879: Else
3880: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3881: Then
3882: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3883: FND_MESSAGE.SET_TOKEN('ATTR_NAME','p_pm_event_reference');
3884: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_pm_event_reference);

Line 3885: FND_MSG_PUB.ADD;

3881: Then
3882: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3883: FND_MESSAGE.SET_TOKEN('ATTR_NAME','p_pm_event_reference');
3884: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_pm_event_reference);
3885: FND_MSG_PUB.ADD;
3886: End If;
3887: p_return_status := FND_API.G_RET_STS_ERROR;
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;

Line 3891: FND_MSG_PUB.Count_And_Get

3887: p_return_status := FND_API.G_RET_STS_ERROR;
3888: RAISE FND_API.G_EXC_ERROR;
3889: END IF;
3890:
3891: FND_MSG_PUB.Count_And_Get
3892: ( p_encoded => l_encoded
3893: , p_count => p_msg_count
3894: , p_data => p_msg_data );
3895:

Line 3912: FND_MSG_PUB.Count_And_Get

3908: THEN
3909: ROLLBACK to fetch_event;
3910: p_event_id_out := NULL; -- NOCOPY
3911: p_return_status := FND_API.G_RET_STS_ERROR;
3912: FND_MSG_PUB.Count_And_Get
3913: ( p_encoded => l_encoded
3914: , p_count => p_msg_count
3915: , p_data => p_msg_data );
3916:

Line 3922: FND_MSG_PUB.Count_And_Get

3918: THEN
3919: ROLLBACK to fetch_event;
3920: p_event_id_out := NULL; -- NOCOPY
3921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3922: FND_MSG_PUB.Count_And_Get
3923: ( p_encoded => l_encoded
3924: , p_count => p_msg_count
3925: , p_data => p_msg_data );
3926:

Line 3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3933: PA_EVENT_PUB.PACKAGE_NAME
3934: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3935: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3936:
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN
3939: FND_MSG_PUB.add_exc_msg
3940: ( p_pkg_name => PACKAGE_NAME
3941: , p_procedure_name => PROCEDURE_NAME );

Line 3939: FND_MSG_PUB.add_exc_msg

3935: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3936:
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN
3939: FND_MSG_PUB.add_exc_msg
3940: ( p_pkg_name => PACKAGE_NAME
3941: , p_procedure_name => PROCEDURE_NAME );
3942: PACKAGE_NAME:=NULL;
3943: PROCEDURE_NAME:=NULL;

Line 3946: FND_MSG_PUB.Count_And_Get

3942: PACKAGE_NAME:=NULL;
3943: PROCEDURE_NAME:=NULL;
3944: END IF;
3945:
3946: FND_MSG_PUB.Count_And_Get
3947: ( p_encoded => l_encoded
3948: , p_count => p_msg_count
3949: , p_data => p_msg_data );
3950:

Line 4078: FND_MSG_PUB.Count_And_Get

4074: p_return_status := FND_API.G_RET_STS_ERROR;
4075: RAISE FND_API.G_EXC_ERROR;
4076: END IF;
4077:
4078: FND_MSG_PUB.Count_And_Get
4079: ( p_encoded => l_encoded
4080: , p_count => p_msg_count
4081: , p_data => p_msg_data );
4082:

Line 4091: FND_MSG_PUB.Count_And_Get

4087: WHEN FND_API.G_EXC_ERROR
4088: THEN
4089: ROLLBACK to check_delete_event_ok;
4090: p_return_status := FND_API.G_RET_STS_ERROR;
4091: FND_MSG_PUB.Count_And_Get
4092: ( p_encoded => l_encoded
4093: , p_count => p_msg_count
4094: , p_data => p_msg_data );
4095:

Line 4100: FND_MSG_PUB.Count_And_Get

4096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4097: THEN
4098: ROLLBACK to check_delete_event_ok;
4099: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4100: FND_MSG_PUB.Count_And_Get
4101: ( p_encoded => l_encoded
4102: , p_count => p_msg_count
4103: , p_data => p_msg_data );
4104:

Line 4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4110: PA_EVENT_PUB.PACKAGE_NAME
4111: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4112: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4113:
4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4115: THEN
4116: FND_MSG_PUB.add_exc_msg
4117: ( p_pkg_name => PACKAGE_NAME
4118: , p_procedure_name => PROCEDURE_NAME );

Line 4116: FND_MSG_PUB.add_exc_msg

4112: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4113:
4114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4115: THEN
4116: FND_MSG_PUB.add_exc_msg
4117: ( p_pkg_name => PACKAGE_NAME
4118: , p_procedure_name => PROCEDURE_NAME );
4119: PACKAGE_NAME:=NULL;
4120: PROCEDURE_NAME:=NULL;

Line 4123: FND_MSG_PUB.Count_And_Get

4119: PACKAGE_NAME:=NULL;
4120: PROCEDURE_NAME:=NULL;
4121: END IF;
4122:
4123: FND_MSG_PUB.Count_And_Get
4124: ( p_encoded => l_encoded
4125: , p_count => p_msg_count
4126: , p_data => p_msg_data );
4127: