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 242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

238: If PA_EVENT_UTILS.CHECK_VALID_PROJECT
239: (P_project_id =>P_project_id
240: ,P_project_num =>P_event_in_rec.P_project_number) = 'N'
241: Then
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
243: THEN
244: pa_interface_utils_pub.map_new_amg_msg
245: ( p_old_message_code => 'PA_INVALID_PROJECT'
246: ,p_msg_attribute => 'CHANGE'

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

369: ,p_return_msg => p_return_msg
370: ,p_valid_status => p_validate_status);
371: IF p_validate_status = 'N'
372: THEN
373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
374: THEN
375: pa_interface_utils_pub.map_new_amg_msg
376: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
377: ,p_msg_attribute => 'CHANGE'

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

956: PA_EVENT_PUB.PACKAGE_NAME
957: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
959:
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: FND_MSG_PUB.add_exc_msg
963: ( p_pkg_name => PACKAGE_NAME
964: , p_procedure_name => PROCEDURE_NAME );

Line 962: FND_MSG_PUB.add_exc_msg

958: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
959:
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: FND_MSG_PUB.add_exc_msg
963: ( p_pkg_name => PACKAGE_NAME
964: , p_procedure_name => PROCEDURE_NAME );
965: PACKAGE_NAME:=NULL;
966: PROCEDURE_NAME:=NULL;

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

973: PA_EVENT_PUB.PACKAGE_NAME
974: :='(Event Reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
976:
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => PACKAGE_NAME
981: , p_procedure_name => PROCEDURE_NAME );

Line 979: FND_MSG_PUB.add_exc_msg

975: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
976:
977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.add_exc_msg
980: ( p_pkg_name => PACKAGE_NAME
981: , p_procedure_name => PROCEDURE_NAME );
982: PACKAGE_NAME:=NULL;
983: PROCEDURE_NAME:=NULL;

Line 1003: FND_MSG_PUB.Count_And_Get

999: --Setting the return status to false even if one record fails the validation.
1000: p_return_status := l_return_status;
1001:
1002: --Extracting and returning error message if message count is 1.
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_encoded => l_encoded
1005: ,p_count => p_msg_count
1006: ,p_data => p_msg_data );
1007:

Line 1013: FND_MSG_PUB.Count_And_Get

1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR
1011: THEN
1012: p_return_status := FND_API.G_RET_STS_ERROR;
1013: FND_MSG_PUB.Count_And_Get
1014: ( p_encoded => l_encoded
1015: ,p_count => p_msg_count
1016: ,p_data => p_msg_data );
1017:

Line 1021: FND_MSG_PUB.Count_And_Get

1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1019: THEN
1020: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: FND_MSG_PUB.Count_And_Get
1022: ( p_encoded => l_encoded
1023: ,p_count => p_msg_count
1024: ,p_data => p_msg_data );
1025:

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

1029: PA_EVENT_PUB.PACKAGE_NAME
1030: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1032:
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.add_exc_msg
1036: ( p_pkg_name => PACKAGE_NAME
1037: , p_procedure_name => PROCEDURE_NAME );

Line 1035: FND_MSG_PUB.add_exc_msg

1031: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'CREATE_EVENT';
1032:
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.add_exc_msg
1036: ( p_pkg_name => PACKAGE_NAME
1037: , p_procedure_name => PROCEDURE_NAME );
1038: PACKAGE_NAME:=NULL;
1039: PROCEDURE_NAME:=NULL;

Line 1042: FND_MSG_PUB.Count_And_Get

1038: PACKAGE_NAME:=NULL;
1039: PROCEDURE_NAME:=NULL;
1040: END IF;
1041:
1042: FND_MSG_PUB.Count_And_Get
1043: ( p_encoded => l_encoded
1044: ,p_count => p_msg_count
1045: ,p_data => p_msg_data );
1046:

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

1050: PA_EVENT_PUB.PACKAGE_NAME
1051: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1053:
1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.add_exc_msg
1057: ( p_pkg_name => PACKAGE_NAME
1058: , p_procedure_name => PROCEDURE_NAME );

Line 1056: FND_MSG_PUB.add_exc_msg

1052: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CREATE_EVENT';
1053:
1054: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.add_exc_msg
1057: ( p_pkg_name => PACKAGE_NAME
1058: , p_procedure_name => PROCEDURE_NAME );
1059: PACKAGE_NAME:=NULL;
1060: PROCEDURE_NAME:=NULL;

Line 1063: FND_MSG_PUB.Count_And_Get

1059: PACKAGE_NAME:=NULL;
1060: PROCEDURE_NAME:=NULL;
1061: END IF;
1062:
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_encoded => l_encoded
1065: ,p_count => p_msg_count
1066: ,p_data => p_msg_data );
1067:

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

1357:
1358: --validation to be done only if project number is provided.
1359: If (P_project_id <> nvl(l_project_id,P_project_id))
1360: Then
1361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: pa_interface_utils_pub.map_new_amg_msg
1364: ( p_old_message_code => 'PA_EV_REF_PROJ_MISS'
1365: ,p_msg_attribute => 'CHANGE'

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

1530: ,p_return_msg => p_return_msg
1531: ,p_valid_status => p_validate_status);
1532: IF p_validate_status = 'N'
1533: THEN
1534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536: pa_interface_utils_pub.map_new_amg_msg
1537: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
1538: ,p_msg_attribute => 'CHANGE'

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

2164: -- Till here
2165:
2166: IF nvl(l_record_version_number, 0) <> nvl(p_event_in_rec.P_record_version_number, 0)
2167: Then
2168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2169: THEN
2170: pa_interface_utils_pub.map_new_amg_msg
2171: ( p_old_message_code => 'PA_RECORD_CHANGED'
2172: ,p_msg_attribute => 'CHANGE'

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

2792: PA_EVENT_PUB.PACKAGE_NAME
2793: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2795:
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.add_exc_msg
2799: ( p_pkg_name => PACKAGE_NAME
2800: , p_procedure_name => PROCEDURE_NAME );

Line 2798: FND_MSG_PUB.add_exc_msg

2794: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2795:
2796: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.add_exc_msg
2799: ( p_pkg_name => PACKAGE_NAME
2800: , p_procedure_name => PROCEDURE_NAME );
2801: PACKAGE_NAME:=NULL;
2802: PROCEDURE_NAME:=NULL;

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

2809: PA_EVENT_PUB.PACKAGE_NAME
2810: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2812:
2813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2814: THEN
2815: FND_MSG_PUB.add_exc_msg
2816: ( p_pkg_name => PACKAGE_NAME
2817: , p_procedure_name => PROCEDURE_NAME );

Line 2815: FND_MSG_PUB.add_exc_msg

2811: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2812:
2813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2814: THEN
2815: FND_MSG_PUB.add_exc_msg
2816: ( p_pkg_name => PACKAGE_NAME
2817: , p_procedure_name => PROCEDURE_NAME );
2818: PACKAGE_NAME:=NULL;
2819: PROCEDURE_NAME:=NULL;

Line 2839: FND_MSG_PUB.Count_And_Get

2835: --Setting the return status to false even if one record fails the validation.
2836: p_return_status := l_return_status;
2837:
2838: --If there is one error message then extract the error meaasge and return it.
2839: FND_MSG_PUB.Count_And_Get
2840: ( p_encoded => l_encoded
2841: ,p_count => p_msg_count
2842: ,p_data => p_msg_data );
2843:

Line 2848: FND_MSG_PUB.Count_And_Get

2844: EXCEPTION
2845: WHEN FND_API.G_EXC_ERROR
2846: THEN
2847: p_return_status := FND_API.G_RET_STS_ERROR;
2848: FND_MSG_PUB.Count_And_Get
2849: ( p_encoded => l_encoded
2850: ,p_count => p_msg_count
2851: ,p_data => p_msg_data );
2852:

Line 2856: FND_MSG_PUB.Count_And_Get

2852:
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2854: THEN
2855: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: FND_MSG_PUB.Count_And_Get
2857: ( p_encoded => l_encoded
2858: ,p_count => p_msg_count
2859: ,p_data => p_msg_data );
2860:

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

2864: PA_EVENT_PUB.PACKAGE_NAME
2865: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2867:
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2869: THEN
2870: FND_MSG_PUB.add_exc_msg
2871: ( p_pkg_name => PACKAGE_NAME
2872: , p_procedure_name => PROCEDURE_NAME );

Line 2870: FND_MSG_PUB.add_exc_msg

2866: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'UPDATE_EVENT';
2867:
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2869: THEN
2870: FND_MSG_PUB.add_exc_msg
2871: ( p_pkg_name => PACKAGE_NAME
2872: , p_procedure_name => PROCEDURE_NAME );
2873: PACKAGE_NAME:=NULL;
2874: PROCEDURE_NAME:=NULL;

Line 2876: FND_MSG_PUB.Count_And_Get

2872: , p_procedure_name => PROCEDURE_NAME );
2873: PACKAGE_NAME:=NULL;
2874: PROCEDURE_NAME:=NULL;
2875: END IF;
2876: FND_MSG_PUB.Count_And_Get
2877: ( p_encoded => l_encoded
2878: ,p_count => p_msg_count
2879: ,p_data => p_msg_data );
2880:

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

2885: PA_EVENT_PUB.PACKAGE_NAME
2886: :='(event_reference='||p_event_in_rec.p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2888:
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2890: THEN
2891: FND_MSG_PUB.add_exc_msg
2892: ( p_pkg_name => PACKAGE_NAME
2893: , p_procedure_name => PROCEDURE_NAME );

Line 2891: FND_MSG_PUB.add_exc_msg

2887: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'UPDATE_EVENT';
2888:
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2890: THEN
2891: FND_MSG_PUB.add_exc_msg
2892: ( p_pkg_name => PACKAGE_NAME
2893: , p_procedure_name => PROCEDURE_NAME );
2894: PACKAGE_NAME:=NULL;
2895: PROCEDURE_NAME:=NULL;

Line 2898: FND_MSG_PUB.Count_And_Get

2894: PACKAGE_NAME:=NULL;
2895: PROCEDURE_NAME:=NULL;
2896: END IF;
2897:
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 3049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3045: If PA_EVENT_PVT.CHECK_DELETE_EVENT_OK
3046: (P_pm_event_reference =>l_pm_event_reference
3047: ,P_event_id =>l_event_id_out) ='N'
3048: Then
3049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3050: THEN
3051: pa_interface_utils_pub.map_new_amg_msg
3052: ( p_old_message_code => 'PA_TK_EVENT_IN_USE'
3053: ,p_msg_attribute => 'CHANGE'

Line 3097: FND_MSG_PUB.Count_And_Get

3093: END IF;
3094:
3095:
3096: --If there is one error message then extract the error meaasge
3097: FND_MSG_PUB.Count_And_Get
3098: ( p_encoded => l_encoded
3099: ,p_count => p_msg_count
3100: ,p_data => p_msg_data );
3101:

Line 3110: FND_MSG_PUB.Count_And_Get

3106: WHEN FND_API.G_EXC_ERROR
3107: THEN
3108: ROLLBACK to delete_event;
3109: p_return_status := FND_API.G_RET_STS_ERROR;
3110: FND_MSG_PUB.Count_And_Get
3111: ( p_encoded => l_encoded
3112: , p_count => p_msg_count
3113: , p_data => p_msg_data );
3114:

Line 3119: FND_MSG_PUB.Count_And_Get

3115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3116: THEN
3117: ROLLBACK to delete_event;
3118: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3119: FND_MSG_PUB.Count_And_Get
3120: ( p_encoded => l_encoded
3121: , p_count => p_msg_count
3122: , p_data => p_msg_data );
3123:

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

3129: PA_EVENT_PUB.PACKAGE_NAME
3130: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3132:
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.add_exc_msg
3136: ( p_pkg_name => PACKAGE_NAME
3137: , p_procedure_name => PROCEDURE_NAME );

Line 3135: FND_MSG_PUB.add_exc_msg

3131: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||'DELETE_EVENT';
3132:
3133: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.add_exc_msg
3136: ( p_pkg_name => PACKAGE_NAME
3137: , p_procedure_name => PROCEDURE_NAME );
3138: PACKAGE_NAME:=NULL;
3139: PROCEDURE_NAME:=NULL;

Line 3142: FND_MSG_PUB.Count_And_Get

3138: PACKAGE_NAME:=NULL;
3139: PROCEDURE_NAME:=NULL;
3140: END IF;
3141:
3142: FND_MSG_PUB.Count_And_Get
3143: ( p_encoded => l_encoded
3144: , p_count => p_msg_count
3145: , p_data => p_msg_data );
3146:

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

3152: PA_EVENT_PUB.PACKAGE_NAME
3153: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3155:
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3157: THEN
3158: FND_MSG_PUB.add_exc_msg
3159: ( p_pkg_name => PACKAGE_NAME
3160: , p_procedure_name => PROCEDURE_NAME );

Line 3158: FND_MSG_PUB.add_exc_msg

3154: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'DELETE_EVENT';
3155:
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3157: THEN
3158: FND_MSG_PUB.add_exc_msg
3159: ( p_pkg_name => PACKAGE_NAME
3160: , p_procedure_name => PROCEDURE_NAME );
3161: PACKAGE_NAME:=NULL;
3162: PROCEDURE_NAME:=NULL;

Line 3165: FND_MSG_PUB.Count_And_Get

3161: PACKAGE_NAME:=NULL;
3162: PROCEDURE_NAME:=NULL;
3163: END IF;
3164:
3165: FND_MSG_PUB.Count_And_Get
3166: ( p_encoded => l_encoded
3167: , p_count => p_msg_count
3168: , p_data => p_msg_data );
3169:

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

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

Line 3201: FND_MSG_PUB.add_exc_msg

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

Line 3386: FND_MSG_PUB.Count_And_Get

3382: EXCEPTION
3383: WHEN FND_API.G_EXC_ERROR
3384: THEN
3385: p_return_status := FND_API.G_RET_STS_ERROR;
3386: FND_MSG_PUB.Count_And_Get
3387: ( p_count => p_msg_count ,
3388: p_data => p_msg_data );
3389:
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3393: FND_MSG_PUB.Count_And_Get

3389:
3390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3391: THEN
3392: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3393: FND_MSG_PUB.Count_And_Get
3394: ( p_count => p_msg_count
3395: , p_data => p_msg_data );
3396:
3397: WHEN OTHERS

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

3401: PA_EVENT_PUB.PACKAGE_NAME
3402: :='(event_reference='||G_event_in_tbl(G_event_tbl_count).P_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3404:
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN
3407: FND_MSG_PUB.add_exc_msg
3408: ( p_pkg_name => PACKAGE_NAME
3409: , p_procedure_name => PROCEDURE_NAME );

Line 3407: FND_MSG_PUB.add_exc_msg

3403: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'LOAD_EVENT';
3404:
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3406: THEN
3407: FND_MSG_PUB.add_exc_msg
3408: ( p_pkg_name => PACKAGE_NAME
3409: , p_procedure_name => PROCEDURE_NAME );
3410: PACKAGE_NAME:=NULL;
3411: PROCEDURE_NAME:=NULL;

Line 3414: FND_MSG_PUB.Count_And_Get

3410: PACKAGE_NAME:=NULL;
3411: PROCEDURE_NAME:=NULL;
3412: END IF;
3413:
3414: FND_MSG_PUB.Count_And_Get
3415: ( p_count => p_msg_count ,
3416: p_data => p_msg_data );
3417:
3418:

Line 3523: FND_MSG_PUB.Count_And_Get

3519: WHEN FND_API.G_EXC_ERROR
3520: THEN
3521: p_event_id_out := NULL; -- NOCOPY
3522: p_return_status := FND_API.G_RET_STS_ERROR;
3523: FND_MSG_PUB.Count_And_Get
3524: ( p_encoded => l_encoded
3525: ,p_count => p_msg_count
3526: ,p_data => p_msg_data );
3527:

Line 3532: FND_MSG_PUB.Count_And_Get

3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3529: THEN
3530: p_event_id_out := NULL; -- NOCOPY
3531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3532: FND_MSG_PUB.Count_And_Get
3533: ( p_encoded => l_encoded
3534: ,p_count => p_msg_count
3535: ,p_data => p_msg_data );
3536:

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

3542: PA_EVENT_PUB.PACKAGE_NAME
3543: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3545:
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3547: THEN
3548: FND_MSG_PUB.add_exc_msg
3549: ( p_pkg_name => PACKAGE_NAME
3550: , p_procedure_name => PROCEDURE_NAME );

Line 3548: FND_MSG_PUB.add_exc_msg

3544: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_CREATE_EVENT';
3545:
3546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3547: THEN
3548: FND_MSG_PUB.add_exc_msg
3549: ( p_pkg_name => PACKAGE_NAME
3550: , p_procedure_name => PROCEDURE_NAME );
3551: PACKAGE_NAME:=NULL;
3552: PROCEDURE_NAME:=NULL;

Line 3555: FND_MSG_PUB.Count_And_Get

3551: PACKAGE_NAME:=NULL;
3552: PROCEDURE_NAME:=NULL;
3553: END IF;
3554:
3555: FND_MSG_PUB.Count_And_Get
3556: ( p_encoded => l_encoded
3557: ,p_count => p_msg_count
3558: ,p_data => p_msg_data );
3559:

Line 3659: FND_MSG_PUB.Count_And_Get

3655: EXCEPTION
3656: WHEN FND_API.G_EXC_ERROR
3657: THEN
3658: p_return_status := FND_API.G_RET_STS_ERROR;
3659: FND_MSG_PUB.Count_And_Get
3660: ( p_encoded => l_encoded
3661: ,p_count => p_msg_count
3662: ,p_data => p_msg_data );
3663:

Line 3667: FND_MSG_PUB.Count_And_Get

3663:
3664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3665: THEN
3666: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3667: FND_MSG_PUB.Count_And_Get
3668: ( p_encoded => l_encoded
3669: ,p_count => p_msg_count
3670: ,p_data => p_msg_data );
3671:

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

3676: PA_EVENT_PUB.PACKAGE_NAME
3677: :=PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3679:
3680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3681: THEN
3682: FND_MSG_PUB.add_exc_msg
3683: ( p_pkg_name => PACKAGE_NAME
3684: , p_procedure_name => PROCEDURE_NAME );

Line 3682: FND_MSG_PUB.add_exc_msg

3678: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'EXECUTE_UPDATE_EVENT';
3679:
3680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3681: THEN
3682: FND_MSG_PUB.add_exc_msg
3683: ( p_pkg_name => PACKAGE_NAME
3684: , p_procedure_name => PROCEDURE_NAME );
3685: PACKAGE_NAME:=NULL;
3686: PROCEDURE_NAME:=NULL;

Line 3689: FND_MSG_PUB.Count_And_Get

3685: PACKAGE_NAME:=NULL;
3686: PROCEDURE_NAME:=NULL;
3687: END IF;
3688:
3689: FND_MSG_PUB.Count_And_Get
3690: ( p_encoded => l_encoded
3691: ,p_count => p_msg_count
3692: ,p_data => p_msg_data );
3693:

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)||'CLEAR_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)||'CLEAR_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 3799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3795:
3796: IF (p_pm_product_code IS NULL)
3797: OR (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)
3798: THEN
3799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3800: THEN
3801: pa_interface_utils_pub.map_new_amg_msg
3802: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISS'
3803: ,p_msg_attribute => 'CHANGE'

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

3834: End If;
3835: tot_recs :=tot_recs + 1;
3836: End Loop;
3837: Else
3838: If FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3839: Then
3840: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3841: FND_MESSAGE.SET_TOKEN('ATTR_NAME','p_pm_event_reference');
3842: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_pm_event_reference);

Line 3843: FND_MSG_PUB.ADD;

3839: Then
3840: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3841: FND_MESSAGE.SET_TOKEN('ATTR_NAME','p_pm_event_reference');
3842: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_pm_event_reference);
3843: FND_MSG_PUB.ADD;
3844: End If;
3845: p_return_status := FND_API.G_RET_STS_ERROR;
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;

Line 3849: FND_MSG_PUB.Count_And_Get

3845: p_return_status := FND_API.G_RET_STS_ERROR;
3846: RAISE FND_API.G_EXC_ERROR;
3847: END IF;
3848:
3849: FND_MSG_PUB.Count_And_Get
3850: ( p_encoded => l_encoded
3851: , p_count => p_msg_count
3852: , p_data => p_msg_data );
3853:

Line 3870: FND_MSG_PUB.Count_And_Get

3866: THEN
3867: ROLLBACK to fetch_event;
3868: p_event_id_out := NULL; -- NOCOPY
3869: p_return_status := FND_API.G_RET_STS_ERROR;
3870: FND_MSG_PUB.Count_And_Get
3871: ( p_encoded => l_encoded
3872: , p_count => p_msg_count
3873: , p_data => p_msg_data );
3874:

Line 3880: FND_MSG_PUB.Count_And_Get

3876: THEN
3877: ROLLBACK to fetch_event;
3878: p_event_id_out := NULL; -- NOCOPY
3879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3880: FND_MSG_PUB.Count_And_Get
3881: ( p_encoded => l_encoded
3882: , p_count => p_msg_count
3883: , p_data => p_msg_data );
3884:

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

3891: PA_EVENT_PUB.PACKAGE_NAME
3892: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3894:
3895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3896: THEN
3897: FND_MSG_PUB.add_exc_msg
3898: ( p_pkg_name => PACKAGE_NAME
3899: , p_procedure_name => PROCEDURE_NAME );

Line 3897: FND_MSG_PUB.add_exc_msg

3893: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'FETCH_EVENT';
3894:
3895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3896: THEN
3897: FND_MSG_PUB.add_exc_msg
3898: ( p_pkg_name => PACKAGE_NAME
3899: , p_procedure_name => PROCEDURE_NAME );
3900: PACKAGE_NAME:=NULL;
3901: PROCEDURE_NAME:=NULL;

Line 3904: FND_MSG_PUB.Count_And_Get

3900: PACKAGE_NAME:=NULL;
3901: PROCEDURE_NAME:=NULL;
3902: END IF;
3903:
3904: FND_MSG_PUB.Count_And_Get
3905: ( p_encoded => l_encoded
3906: , p_count => p_msg_count
3907: , p_data => p_msg_data );
3908:

Line 4036: FND_MSG_PUB.Count_And_Get

4032: p_return_status := FND_API.G_RET_STS_ERROR;
4033: RAISE FND_API.G_EXC_ERROR;
4034: END IF;
4035:
4036: FND_MSG_PUB.Count_And_Get
4037: ( p_encoded => l_encoded
4038: , p_count => p_msg_count
4039: , p_data => p_msg_data );
4040:

Line 4049: FND_MSG_PUB.Count_And_Get

4045: WHEN FND_API.G_EXC_ERROR
4046: THEN
4047: ROLLBACK to check_delete_event_ok;
4048: p_return_status := FND_API.G_RET_STS_ERROR;
4049: FND_MSG_PUB.Count_And_Get
4050: ( p_encoded => l_encoded
4051: , p_count => p_msg_count
4052: , p_data => p_msg_data );
4053:

Line 4058: FND_MSG_PUB.Count_And_Get

4054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4055: THEN
4056: ROLLBACK to check_delete_event_ok;
4057: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4058: FND_MSG_PUB.Count_And_Get
4059: ( p_encoded => l_encoded
4060: , p_count => p_msg_count
4061: , p_data => p_msg_data );
4062:

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

4068: PA_EVENT_PUB.PACKAGE_NAME
4069: :='(event_reference='||p_pm_event_reference||')'||PA_EVENT_PUB.PACKAGE_NAME||'PUBLIC';
4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4071:
4072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4073: THEN
4074: FND_MSG_PUB.add_exc_msg
4075: ( p_pkg_name => PACKAGE_NAME
4076: , p_procedure_name => PROCEDURE_NAME );

Line 4074: FND_MSG_PUB.add_exc_msg

4070: PA_EVENT_PUB.PROCEDURE_NAME:=PA_EVENT_PUB.PROCEDURE_NAME||substr(sqlerrm,1,80)||'CHECK_DELETE_EVENT_OK';
4071:
4072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4073: THEN
4074: FND_MSG_PUB.add_exc_msg
4075: ( p_pkg_name => PACKAGE_NAME
4076: , p_procedure_name => PROCEDURE_NAME );
4077: PACKAGE_NAME:=NULL;
4078: PROCEDURE_NAME:=NULL;

Line 4081: FND_MSG_PUB.Count_And_Get

4077: PACKAGE_NAME:=NULL;
4078: PROCEDURE_NAME:=NULL;
4079: END IF;
4080:
4081: FND_MSG_PUB.Count_And_Get
4082: ( p_encoded => l_encoded
4083: , p_count => p_msg_count
4084: , p_data => p_msg_data );
4085: