DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on FND_MSG_PUB

Line 306: FND_MSG_PUB.ADD;

302: END IF;
303: END IF;
304: END IF;
305: END IF;
306: FND_MSG_PUB.ADD;
307: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), L_FND_FALSE), 1, 2000) ;
308: END IF;
309: l_debug_info := 'Error Mesage: '||l_error_message;
310: INL_LOGGING_PVT.Log_Statement(

Line 307: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), L_FND_FALSE), 1, 2000) ;

303: END IF;
304: END IF;
305: END IF;
306: FND_MSG_PUB.ADD;
307: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), L_FND_FALSE), 1, 2000) ;
308: END IF;
309: l_debug_info := 'Error Mesage: '||l_error_message;
310: INL_LOGGING_PVT.Log_Statement(
311: p_module_name => g_module_name,

Line 473: IF FND_MSG_PUB.Check_Msg_Level(

469: INL_LOGGING_PVT.Log_UnexpecError (
470: p_module_name => g_module_name,
471: p_procedure_name => l_program_name);
472: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
473: IF FND_MSG_PUB.Check_Msg_Level(
474: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ) THEN
476: FND_MSG_PUB.Add_Exc_Msg(
477: p_pkg_name => g_pkg_name,

Line 474: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

470: p_module_name => g_module_name,
471: p_procedure_name => l_program_name);
472: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
473: IF FND_MSG_PUB.Check_Msg_Level(
474: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ) THEN
476: FND_MSG_PUB.Add_Exc_Msg(
477: p_pkg_name => g_pkg_name,
478: p_procedure_name => l_program_name);

Line 476: FND_MSG_PUB.Add_Exc_Msg(

472: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
473: IF FND_MSG_PUB.Check_Msg_Level(
474: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ) THEN
476: FND_MSG_PUB.Add_Exc_Msg(
477: p_pkg_name => g_pkg_name,
478: p_procedure_name => l_program_name);
479: END IF;
480: END Handle_InterfError;

Line 544: IF FND_MSG_PUB.Check_Msg_Level(

540: INL_LOGGING_PVT.Log_UnexpecError (
541: p_module_name => g_module_name,
542: p_procedure_name => l_program_name);
543: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
544: IF FND_MSG_PUB.Check_Msg_Level(
545: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
546: ) THEN
547: FND_MSG_PUB.Add_Exc_Msg(
548: p_pkg_name => g_pkg_name,

Line 545: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

541: p_module_name => g_module_name,
542: p_procedure_name => l_program_name);
543: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
544: IF FND_MSG_PUB.Check_Msg_Level(
545: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
546: ) THEN
547: FND_MSG_PUB.Add_Exc_Msg(
548: p_pkg_name => g_pkg_name,
549: p_procedure_name => l_program_name);

Line 547: FND_MSG_PUB.Add_Exc_Msg(

543: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
544: IF FND_MSG_PUB.Check_Msg_Level(
545: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
546: ) THEN
547: FND_MSG_PUB.Add_Exc_Msg(
548: p_pkg_name => g_pkg_name,
549: p_procedure_name => l_program_name);
550: END IF;
551: END Reset_InterfError;

Line 620: IF FND_MSG_PUB.Check_Msg_Level(

616: INL_LOGGING_PVT.Log_UnexpecError (
617: p_module_name => g_module_name,
618: p_procedure_name => l_program_name
619: );
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(
624: p_pkg_name => g_pkg_name,

Line 621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

617: p_module_name => g_module_name,
618: p_procedure_name => l_program_name
619: );
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(
624: p_pkg_name => g_pkg_name,
625: p_procedure_name => l_program_name

Line 623: FND_MSG_PUB.Add_Exc_Msg(

619: );
620: IF FND_MSG_PUB.Check_Msg_Level(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(
624: p_pkg_name => g_pkg_name,
625: p_procedure_name => l_program_name
626: );
627: END IF;

Line 699: IF FND_MSG_PUB.Check_Msg_Level(

695: INL_LOGGING_PVT.Log_UnexpecError (
696: p_module_name => g_module_name,
697: p_procedure_name => l_program_name
698: );
699: IF FND_MSG_PUB.Check_Msg_Level(
700: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
701: ) THEN
702: FND_MSG_PUB.Add_Exc_Msg(
703: p_pkg_name => g_pkg_name,

Line 700: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

696: p_module_name => g_module_name,
697: p_procedure_name => l_program_name
698: );
699: IF FND_MSG_PUB.Check_Msg_Level(
700: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
701: ) THEN
702: FND_MSG_PUB.Add_Exc_Msg(
703: p_pkg_name => g_pkg_name,
704: p_procedure_name => l_program_name

Line 702: FND_MSG_PUB.Add_Exc_Msg(

698: );
699: IF FND_MSG_PUB.Check_Msg_Level(
700: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
701: ) THEN
702: FND_MSG_PUB.Add_Exc_Msg(
703: p_pkg_name => g_pkg_name,
704: p_procedure_name => l_program_name
705: );
706: END IF;

Line 1047: IF FND_MSG_PUB.Check_Msg_Level(

1043: -- Standard Unexpected Error Logging
1044: INL_LOGGING_PVT.Log_UnexpecError (
1045: p_module_name => g_module_name,
1046: p_procedure_name => l_program_name);
1047: IF FND_MSG_PUB.Check_Msg_Level(
1048: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1049: ) THEN
1050: FND_MSG_PUB.Add_Exc_Msg(
1051: p_pkg_name => g_pkg_name,

Line 1048: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1044: INL_LOGGING_PVT.Log_UnexpecError (
1045: p_module_name => g_module_name,
1046: p_procedure_name => l_program_name);
1047: IF FND_MSG_PUB.Check_Msg_Level(
1048: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1049: ) THEN
1050: FND_MSG_PUB.Add_Exc_Msg(
1051: p_pkg_name => g_pkg_name,
1052: p_procedure_name => l_program_name);

Line 1050: FND_MSG_PUB.Add_Exc_Msg(

1046: p_procedure_name => l_program_name);
1047: IF FND_MSG_PUB.Check_Msg_Level(
1048: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1049: ) THEN
1050: FND_MSG_PUB.Add_Exc_Msg(
1051: p_pkg_name => g_pkg_name,
1052: p_procedure_name => l_program_name);
1053: END IF;
1054: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 2212: IF FND_MSG_PUB.Check_Msg_Level(

2208: -- Standard Unexpected Error Logging
2209: INL_LOGGING_PVT.Log_UnexpecError (
2210: p_module_name => g_module_name,
2211: p_procedure_name => l_program_name);
2212: IF FND_MSG_PUB.Check_Msg_Level(
2213: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ) THEN
2215: FND_MSG_PUB.Add_Exc_Msg(
2216: p_pkg_name => g_pkg_name,

Line 2213: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2209: INL_LOGGING_PVT.Log_UnexpecError (
2210: p_module_name => g_module_name,
2211: p_procedure_name => l_program_name);
2212: IF FND_MSG_PUB.Check_Msg_Level(
2213: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ) THEN
2215: FND_MSG_PUB.Add_Exc_Msg(
2216: p_pkg_name => g_pkg_name,
2217: p_procedure_name => l_program_name);

Line 2215: FND_MSG_PUB.Add_Exc_Msg(

2211: p_procedure_name => l_program_name);
2212: IF FND_MSG_PUB.Check_Msg_Level(
2213: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ) THEN
2215: FND_MSG_PUB.Add_Exc_Msg(
2216: p_pkg_name => g_pkg_name,
2217: p_procedure_name => l_program_name);
2218: END IF;
2219: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 2759: IF FND_MSG_PUB.Check_Msg_Level(

2755: INL_LOGGING_PVT.Log_UnexpecError (
2756: p_module_name => g_module_name,
2757: p_procedure_name => l_program_name);
2758: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2759: IF FND_MSG_PUB.Check_Msg_Level(
2760: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2761: ) THEN
2762: FND_MSG_PUB.Add_Exc_Msg(
2763: p_pkg_name => g_pkg_name,

Line 2760: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2756: p_module_name => g_module_name,
2757: p_procedure_name => l_program_name);
2758: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2759: IF FND_MSG_PUB.Check_Msg_Level(
2760: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2761: ) THEN
2762: FND_MSG_PUB.Add_Exc_Msg(
2763: p_pkg_name => g_pkg_name,
2764: p_procedure_name => l_program_name);

Line 2762: FND_MSG_PUB.Add_Exc_Msg(

2758: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2759: IF FND_MSG_PUB.Check_Msg_Level(
2760: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2761: ) THEN
2762: FND_MSG_PUB.Add_Exc_Msg(
2763: p_pkg_name => g_pkg_name,
2764: p_procedure_name => l_program_name);
2765: END IF;
2766: END Validate_ShipLnSrcTypeCode;

Line 3141: IF FND_MSG_PUB.Check_Msg_Level(

3137: INL_LOGGING_PVT.Log_UnexpecError (
3138: p_module_name => g_module_name,
3139: p_procedure_name => l_program_name);
3140: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3141: IF FND_MSG_PUB.Check_Msg_Level(
3142: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3143: ) THEN
3144: FND_MSG_PUB.Add_Exc_Msg(
3145: p_pkg_name => g_pkg_name,

Line 3142: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3138: p_module_name => g_module_name,
3139: p_procedure_name => l_program_name);
3140: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3141: IF FND_MSG_PUB.Check_Msg_Level(
3142: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3143: ) THEN
3144: FND_MSG_PUB.Add_Exc_Msg(
3145: p_pkg_name => g_pkg_name,
3146: p_procedure_name => l_program_name);

Line 3144: FND_MSG_PUB.Add_Exc_Msg(

3140: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3141: IF FND_MSG_PUB.Check_Msg_Level(
3142: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3143: ) THEN
3144: FND_MSG_PUB.Add_Exc_Msg(
3145: p_pkg_name => g_pkg_name,
3146: p_procedure_name => l_program_name);
3147: END IF;
3148: END Validate_Currency;

Line 3393: IF FND_MSG_PUB.Check_Msg_Level(

3389: -- Standard Unexpected Error Logging
3390: INL_LOGGING_PVT.Log_UnexpecError (
3391: p_module_name => g_module_name,
3392: p_procedure_name => l_program_name);
3393: IF FND_MSG_PUB.Check_Msg_Level(
3394: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3395: ) THEN
3396: FND_MSG_PUB.Add_Exc_Msg(
3397: p_pkg_name => g_pkg_name,

Line 3394: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3390: INL_LOGGING_PVT.Log_UnexpecError (
3391: p_module_name => g_module_name,
3392: p_procedure_name => l_program_name);
3393: IF FND_MSG_PUB.Check_Msg_Level(
3394: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3395: ) THEN
3396: FND_MSG_PUB.Add_Exc_Msg(
3397: p_pkg_name => g_pkg_name,
3398: p_procedure_name => l_program_name);

Line 3396: FND_MSG_PUB.Add_Exc_Msg(

3392: p_procedure_name => l_program_name);
3393: IF FND_MSG_PUB.Check_Msg_Level(
3394: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3395: ) THEN
3396: FND_MSG_PUB.Add_Exc_Msg(
3397: p_pkg_name => g_pkg_name,
3398: p_procedure_name => l_program_name);
3399: END IF;
3400: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 3924: IF FND_MSG_PUB.Check_Msg_Level(

3920: -- Standard Unexpected Error Logging
3921: INL_LOGGING_PVT.Log_UnexpecError (
3922: p_module_name => g_module_name,
3923: p_procedure_name => l_program_name);
3924: IF FND_MSG_PUB.Check_Msg_Level(
3925: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3926: ) THEN
3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,

Line 3925: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3921: INL_LOGGING_PVT.Log_UnexpecError (
3922: p_module_name => g_module_name,
3923: p_procedure_name => l_program_name);
3924: IF FND_MSG_PUB.Check_Msg_Level(
3925: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3926: ) THEN
3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,
3929: p_procedure_name => l_program_name);

Line 3927: FND_MSG_PUB.Add_Exc_Msg(

3923: p_procedure_name => l_program_name);
3924: IF FND_MSG_PUB.Check_Msg_Level(
3925: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3926: ) THEN
3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,
3929: p_procedure_name => l_program_name);
3930: END IF;
3931: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 4031: IF FND_MSG_PUB.Check_Msg_Level(

4027: -- Standard Unexpected Error Logging
4028: INL_LOGGING_PVT.Log_UnexpecError (
4029: p_module_name => g_module_name,
4030: p_procedure_name => l_program_name);
4031: IF FND_MSG_PUB.Check_Msg_Level(
4032: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4033: ) THEN
4034: FND_MSG_PUB.Add_Exc_Msg(
4035: p_pkg_name => g_pkg_name,

Line 4032: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4028: INL_LOGGING_PVT.Log_UnexpecError (
4029: p_module_name => g_module_name,
4030: p_procedure_name => l_program_name);
4031: IF FND_MSG_PUB.Check_Msg_Level(
4032: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4033: ) THEN
4034: FND_MSG_PUB.Add_Exc_Msg(
4035: p_pkg_name => g_pkg_name,
4036: p_procedure_name => l_program_name);

Line 4034: FND_MSG_PUB.Add_Exc_Msg(

4030: p_procedure_name => l_program_name);
4031: IF FND_MSG_PUB.Check_Msg_Level(
4032: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4033: ) THEN
4034: FND_MSG_PUB.Add_Exc_Msg(
4035: p_pkg_name => g_pkg_name,
4036: p_procedure_name => l_program_name);
4037: END IF;
4038: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 4135: IF FND_MSG_PUB.Check_Msg_Level(

4131: -- Standard Unexpected Error Logging
4132: INL_LOGGING_PVT.Log_UnexpecError (
4133: p_module_name => g_module_name,
4134: p_procedure_name => l_program_name);
4135: IF FND_MSG_PUB.Check_Msg_Level(
4136: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4137: ) THEN
4138: FND_MSG_PUB.Add_Exc_Msg(
4139: p_pkg_name => g_pkg_name,

Line 4136: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4132: INL_LOGGING_PVT.Log_UnexpecError (
4133: p_module_name => g_module_name,
4134: p_procedure_name => l_program_name);
4135: IF FND_MSG_PUB.Check_Msg_Level(
4136: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4137: ) THEN
4138: FND_MSG_PUB.Add_Exc_Msg(
4139: p_pkg_name => g_pkg_name,
4140: p_procedure_name => l_program_name);

Line 4138: FND_MSG_PUB.Add_Exc_Msg(

4134: p_procedure_name => l_program_name);
4135: IF FND_MSG_PUB.Check_Msg_Level(
4136: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4137: ) THEN
4138: FND_MSG_PUB.Add_Exc_Msg(
4139: p_pkg_name => g_pkg_name,
4140: p_procedure_name => l_program_name);
4141: END IF;
4142: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 5974: IF FND_MSG_PUB.Check_Msg_Level(

5970: -- Standard Unexpected Error Logging
5971: INL_LOGGING_PVT.Log_UnexpecError (
5972: p_module_name => g_module_name,
5973: p_procedure_name => l_program_name);
5974: IF FND_MSG_PUB.Check_Msg_Level(
5975: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5976: ) THEN
5977: FND_MSG_PUB.Add_Exc_Msg(
5978: p_pkg_name => g_pkg_name,

Line 5975: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5971: INL_LOGGING_PVT.Log_UnexpecError (
5972: p_module_name => g_module_name,
5973: p_procedure_name => l_program_name);
5974: IF FND_MSG_PUB.Check_Msg_Level(
5975: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5976: ) THEN
5977: FND_MSG_PUB.Add_Exc_Msg(
5978: p_pkg_name => g_pkg_name,
5979: p_procedure_name => l_program_name);

Line 5977: FND_MSG_PUB.Add_Exc_Msg(

5973: p_procedure_name => l_program_name);
5974: IF FND_MSG_PUB.Check_Msg_Level(
5975: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5976: ) THEN
5977: FND_MSG_PUB.Add_Exc_Msg(
5978: p_pkg_name => g_pkg_name,
5979: p_procedure_name => l_program_name);
5980: END IF;
5981: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 6113: IF FND_MSG_PUB.Check_Msg_Level(

6109: -- Standard Unexpected Error Logging
6110: INL_LOGGING_PVT.Log_UnexpecError (
6111: p_module_name => g_module_name,
6112: p_procedure_name => l_program_name);
6113: IF FND_MSG_PUB.Check_Msg_Level(
6114: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6115: ) THEN
6116: FND_MSG_PUB.Add_Exc_Msg(
6117: p_pkg_name => g_pkg_name,

Line 6114: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6110: INL_LOGGING_PVT.Log_UnexpecError (
6111: p_module_name => g_module_name,
6112: p_procedure_name => l_program_name);
6113: IF FND_MSG_PUB.Check_Msg_Level(
6114: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6115: ) THEN
6116: FND_MSG_PUB.Add_Exc_Msg(
6117: p_pkg_name => g_pkg_name,
6118: p_procedure_name => l_program_name);

Line 6116: FND_MSG_PUB.Add_Exc_Msg(

6112: p_procedure_name => l_program_name);
6113: IF FND_MSG_PUB.Check_Msg_Level(
6114: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6115: ) THEN
6116: FND_MSG_PUB.Add_Exc_Msg(
6117: p_pkg_name => g_pkg_name,
6118: p_procedure_name => l_program_name);
6119: END IF;
6120: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 6455: IF FND_MSG_PUB.Check_Msg_Level(

6451: -- Standard Unexpected Error Logging
6452: INL_LOGGING_PVT.Log_UnexpecError (
6453: p_module_name => g_module_name,
6454: p_procedure_name => l_program_name);
6455: IF FND_MSG_PUB.Check_Msg_Level(
6456: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6457: ) THEN
6458: FND_MSG_PUB.Add_Exc_Msg(
6459: p_pkg_name => g_pkg_name,

Line 6456: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6452: INL_LOGGING_PVT.Log_UnexpecError (
6453: p_module_name => g_module_name,
6454: p_procedure_name => l_program_name);
6455: IF FND_MSG_PUB.Check_Msg_Level(
6456: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6457: ) THEN
6458: FND_MSG_PUB.Add_Exc_Msg(
6459: p_pkg_name => g_pkg_name,
6460: p_procedure_name => l_program_name);

Line 6458: FND_MSG_PUB.Add_Exc_Msg(

6454: p_procedure_name => l_program_name);
6455: IF FND_MSG_PUB.Check_Msg_Level(
6456: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6457: ) THEN
6458: FND_MSG_PUB.Add_Exc_Msg(
6459: p_pkg_name => g_pkg_name,
6460: p_procedure_name => l_program_name);
6461: END IF;
6462: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 6822: IF FND_MSG_PUB.Check_Msg_Level(

6818: -- Standard Unexpected Error Logging
6819: INL_LOGGING_PVT.Log_UnexpecError (
6820: p_module_name => g_module_name,
6821: p_procedure_name => l_program_name);
6822: IF FND_MSG_PUB.Check_Msg_Level(
6823: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6824: ) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(
6826: p_pkg_name => g_pkg_name,

Line 6823: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6819: INL_LOGGING_PVT.Log_UnexpecError (
6820: p_module_name => g_module_name,
6821: p_procedure_name => l_program_name);
6822: IF FND_MSG_PUB.Check_Msg_Level(
6823: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6824: ) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(
6826: p_pkg_name => g_pkg_name,
6827: p_procedure_name => l_program_name);

Line 6825: FND_MSG_PUB.Add_Exc_Msg(

6821: p_procedure_name => l_program_name);
6822: IF FND_MSG_PUB.Check_Msg_Level(
6823: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6824: ) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(
6826: p_pkg_name => g_pkg_name,
6827: p_procedure_name => l_program_name);
6828: END IF;
6829: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 7639: IF FND_MSG_PUB.Check_Msg_Level(

7635: -- Standard Unexpected Error Logging
7636: INL_LOGGING_PVT.Log_UnexpecError (
7637: p_module_name => g_module_name,
7638: p_procedure_name => l_program_name);
7639: IF FND_MSG_PUB.Check_Msg_Level(
7640: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7641: ) THEN
7642: FND_MSG_PUB.Add_Exc_Msg(
7643: p_pkg_name => g_pkg_name,

Line 7640: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7636: INL_LOGGING_PVT.Log_UnexpecError (
7637: p_module_name => g_module_name,
7638: p_procedure_name => l_program_name);
7639: IF FND_MSG_PUB.Check_Msg_Level(
7640: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7641: ) THEN
7642: FND_MSG_PUB.Add_Exc_Msg(
7643: p_pkg_name => g_pkg_name,
7644: p_procedure_name => l_program_name);

Line 7642: FND_MSG_PUB.Add_Exc_Msg(

7638: p_procedure_name => l_program_name);
7639: IF FND_MSG_PUB.Check_Msg_Level(
7640: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7641: ) THEN
7642: FND_MSG_PUB.Add_Exc_Msg(
7643: p_pkg_name => g_pkg_name,
7644: p_procedure_name => l_program_name);
7645: END IF;
7646: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 7756: IF FND_MSG_PUB.Check_Msg_Level(

7752: -- Standard Unexpected Error Logging
7753: INL_LOGGING_PVT.Log_UnexpecError (
7754: p_module_name => g_module_name,
7755: p_procedure_name => l_program_name);
7756: IF FND_MSG_PUB.Check_Msg_Level(
7757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7758: ) THEN
7759: FND_MSG_PUB.Add_Exc_Msg(
7760: p_pkg_name => g_pkg_name,

Line 7757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7753: INL_LOGGING_PVT.Log_UnexpecError (
7754: p_module_name => g_module_name,
7755: p_procedure_name => l_program_name);
7756: IF FND_MSG_PUB.Check_Msg_Level(
7757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7758: ) THEN
7759: FND_MSG_PUB.Add_Exc_Msg(
7760: p_pkg_name => g_pkg_name,
7761: p_procedure_name => l_program_name);

Line 7759: FND_MSG_PUB.Add_Exc_Msg(

7755: p_procedure_name => l_program_name);
7756: IF FND_MSG_PUB.Check_Msg_Level(
7757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7758: ) THEN
7759: FND_MSG_PUB.Add_Exc_Msg(
7760: p_pkg_name => g_pkg_name,
7761: p_procedure_name => l_program_name);
7762: END IF;
7763: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 7870: IF FND_MSG_PUB.Check_Msg_Level(

7866: -- Standard Unexpected Error Logging
7867: INL_LOGGING_PVT.Log_UnexpecError (
7868: p_module_name => g_module_name,
7869: p_procedure_name => l_program_name);
7870: IF FND_MSG_PUB.Check_Msg_Level(
7871: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7872: ) THEN
7873: FND_MSG_PUB.Add_Exc_Msg(
7874: p_pkg_name => g_pkg_name,

Line 7871: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7867: INL_LOGGING_PVT.Log_UnexpecError (
7868: p_module_name => g_module_name,
7869: p_procedure_name => l_program_name);
7870: IF FND_MSG_PUB.Check_Msg_Level(
7871: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7872: ) THEN
7873: FND_MSG_PUB.Add_Exc_Msg(
7874: p_pkg_name => g_pkg_name,
7875: p_procedure_name => l_program_name);

Line 7873: FND_MSG_PUB.Add_Exc_Msg(

7869: p_procedure_name => l_program_name);
7870: IF FND_MSG_PUB.Check_Msg_Level(
7871: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7872: ) THEN
7873: FND_MSG_PUB.Add_Exc_Msg(
7874: p_pkg_name => g_pkg_name,
7875: p_procedure_name => l_program_name);
7876: END IF;
7877: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 8086: IF FND_MSG_PUB.Check_Msg_Level(

8082: -- Standard Unexpected Error Logging
8083: INL_LOGGING_PVT.Log_UnexpecError (
8084: p_module_name => g_module_name,
8085: p_procedure_name => l_program_name);
8086: IF FND_MSG_PUB.Check_Msg_Level(
8087: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8088: ) THEN
8089: FND_MSG_PUB.Add_Exc_Msg(
8090: p_pkg_name => g_pkg_name,

Line 8087: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8083: INL_LOGGING_PVT.Log_UnexpecError (
8084: p_module_name => g_module_name,
8085: p_procedure_name => l_program_name);
8086: IF FND_MSG_PUB.Check_Msg_Level(
8087: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8088: ) THEN
8089: FND_MSG_PUB.Add_Exc_Msg(
8090: p_pkg_name => g_pkg_name,
8091: p_procedure_name => l_program_name);

Line 8089: FND_MSG_PUB.Add_Exc_Msg(

8085: p_procedure_name => l_program_name);
8086: IF FND_MSG_PUB.Check_Msg_Level(
8087: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8088: ) THEN
8089: FND_MSG_PUB.Add_Exc_Msg(
8090: p_pkg_name => g_pkg_name,
8091: p_procedure_name => l_program_name);
8092: END IF;
8093: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 8385: IF FND_MSG_PUB.Check_Msg_Level(

8381: INL_LOGGING_PVT.Log_UnexpecError (
8382: p_module_name => g_module_name,
8383: p_procedure_name => l_program_name);
8384: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8385: IF FND_MSG_PUB.Check_Msg_Level(
8386: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8387: ) THEN
8388: FND_MSG_PUB.Add_Exc_Msg(
8389: p_pkg_name => g_pkg_name,

Line 8386: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8382: p_module_name => g_module_name,
8383: p_procedure_name => l_program_name);
8384: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8385: IF FND_MSG_PUB.Check_Msg_Level(
8386: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8387: ) THEN
8388: FND_MSG_PUB.Add_Exc_Msg(
8389: p_pkg_name => g_pkg_name,
8390: p_procedure_name => l_program_name);

Line 8388: FND_MSG_PUB.Add_Exc_Msg(

8384: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8385: IF FND_MSG_PUB.Check_Msg_Level(
8386: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8387: ) THEN
8388: FND_MSG_PUB.Add_Exc_Msg(
8389: p_pkg_name => g_pkg_name,
8390: p_procedure_name => l_program_name);
8391: END IF;
8392: END Delete_Ship;

Line 8691: IF FND_MSG_PUB.Check_Msg_Level(

8687: INL_LOGGING_PVT.Log_UnexpecError (
8688: p_module_name => g_module_name,
8689: p_procedure_name => l_program_name);
8690: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8691: IF FND_MSG_PUB.Check_Msg_Level(
8692: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8693: ) THEN
8694: FND_MSG_PUB.Add_Exc_Msg(
8695: p_pkg_name => g_pkg_name,

Line 8692: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8688: p_module_name => g_module_name,
8689: p_procedure_name => l_program_name);
8690: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8691: IF FND_MSG_PUB.Check_Msg_Level(
8692: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8693: ) THEN
8694: FND_MSG_PUB.Add_Exc_Msg(
8695: p_pkg_name => g_pkg_name,
8696: p_procedure_name => l_program_name

Line 8694: FND_MSG_PUB.Add_Exc_Msg(

8690: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8691: IF FND_MSG_PUB.Check_Msg_Level(
8692: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8693: ) THEN
8694: FND_MSG_PUB.Add_Exc_Msg(
8695: p_pkg_name => g_pkg_name,
8696: p_procedure_name => l_program_name
8697: );
8698: END IF;

Line 8823: IF FND_MSG_PUB.Check_Msg_Level(

8819: INL_LOGGING_PVT.Log_UnexpecError (
8820: p_module_name => g_module_name,
8821: p_procedure_name => l_program_name);
8822: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8823: IF FND_MSG_PUB.Check_Msg_Level(
8824: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8825: ) THEN
8826: FND_MSG_PUB.Add_Exc_Msg(
8827: p_pkg_name => g_pkg_name,

Line 8824: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8820: p_module_name => g_module_name,
8821: p_procedure_name => l_program_name);
8822: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8823: IF FND_MSG_PUB.Check_Msg_Level(
8824: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8825: ) THEN
8826: FND_MSG_PUB.Add_Exc_Msg(
8827: p_pkg_name => g_pkg_name,
8828: p_procedure_name => l_program_name);

Line 8826: FND_MSG_PUB.Add_Exc_Msg(

8822: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8823: IF FND_MSG_PUB.Check_Msg_Level(
8824: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8825: ) THEN
8826: FND_MSG_PUB.Add_Exc_Msg(
8827: p_pkg_name => g_pkg_name,
8828: p_procedure_name => l_program_name);
8829: END IF;
8830: END Run_ProcessAction;

Line 9225: IF FND_MSG_PUB.Check_Msg_Level(

9221: INL_LOGGING_PVT.Log_UnexpecError (
9222: p_module_name => g_module_name,
9223: p_procedure_name => l_program_name);
9224: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9225: IF FND_MSG_PUB.Check_Msg_Level(
9226: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9227: ) THEN
9228: FND_MSG_PUB.Add_Exc_Msg(
9229: p_pkg_name => g_pkg_name,

Line 9226: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9222: p_module_name => g_module_name,
9223: p_procedure_name => l_program_name);
9224: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9225: IF FND_MSG_PUB.Check_Msg_Level(
9226: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9227: ) THEN
9228: FND_MSG_PUB.Add_Exc_Msg(
9229: p_pkg_name => g_pkg_name,
9230: p_procedure_name => l_program_name);

Line 9228: FND_MSG_PUB.Add_Exc_Msg(

9224: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9225: IF FND_MSG_PUB.Check_Msg_Level(
9226: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9227: ) THEN
9228: FND_MSG_PUB.Add_Exc_Msg(
9229: p_pkg_name => g_pkg_name,
9230: p_procedure_name => l_program_name);
9231: END IF;
9232: END Import_Lines;

Line 9535: IF FND_MSG_PUB.Check_Msg_Level(

9531: INL_LOGGING_PVT.Log_UnexpecError (
9532: p_module_name => g_module_name,
9533: p_procedure_name => l_program_name);
9534: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9535: IF FND_MSG_PUB.Check_Msg_Level(
9536: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9537: ) THEN
9538: FND_MSG_PUB.Add_Exc_Msg(
9539: p_pkg_name => g_pkg_name,

Line 9536: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9532: p_module_name => g_module_name,
9533: p_procedure_name => l_program_name);
9534: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9535: IF FND_MSG_PUB.Check_Msg_Level(
9536: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9537: ) THEN
9538: FND_MSG_PUB.Add_Exc_Msg(
9539: p_pkg_name => g_pkg_name,
9540: p_procedure_name => l_program_name);

Line 9538: FND_MSG_PUB.Add_Exc_Msg(

9534: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9535: IF FND_MSG_PUB.Check_Msg_Level(
9536: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9537: ) THEN
9538: FND_MSG_PUB.Add_Exc_Msg(
9539: p_pkg_name => g_pkg_name,
9540: p_procedure_name => l_program_name);
9541: END IF;
9542: END Import_Headers;

Line 9628: IF FND_MSG_PUB.Check_Msg_Level(

9624: p_module_name => g_module_name,
9625: p_procedure_name => l_program_name
9626: );
9627: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9628: IF FND_MSG_PUB.Check_Msg_Level(
9629: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9630: ) THEN
9631: FND_MSG_PUB.Add_Exc_Msg(
9632: p_pkg_name => g_pkg_name,

Line 9629: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9625: p_procedure_name => l_program_name
9626: );
9627: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9628: IF FND_MSG_PUB.Check_Msg_Level(
9629: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9630: ) THEN
9631: FND_MSG_PUB.Add_Exc_Msg(
9632: p_pkg_name => g_pkg_name,
9633: p_procedure_name => l_program_name

Line 9631: FND_MSG_PUB.Add_Exc_Msg(

9627: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9628: IF FND_MSG_PUB.Check_Msg_Level(
9629: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9630: ) THEN
9631: FND_MSG_PUB.Add_Exc_Msg(
9632: p_pkg_name => g_pkg_name,
9633: p_procedure_name => l_program_name
9634: );
9635: END IF;

Line 10087: IF FND_MSG_PUB.Check_Msg_Level(

10083: p_module_name => g_module_name,
10084: p_procedure_name => l_program_name
10085: );
10086: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10087: IF FND_MSG_PUB.Check_Msg_Level(
10088: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10089: ) THEN
10090: FND_MSG_PUB.Add_Exc_Msg(
10091: p_pkg_name => g_pkg_name,

Line 10088: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10084: p_procedure_name => l_program_name
10085: );
10086: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10087: IF FND_MSG_PUB.Check_Msg_Level(
10088: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10089: ) THEN
10090: FND_MSG_PUB.Add_Exc_Msg(
10091: p_pkg_name => g_pkg_name,
10092: p_procedure_name => l_program_name

Line 10090: FND_MSG_PUB.Add_Exc_Msg(

10086: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10087: IF FND_MSG_PUB.Check_Msg_Level(
10088: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10089: ) THEN
10090: FND_MSG_PUB.Add_Exc_Msg(
10091: p_pkg_name => g_pkg_name,
10092: p_procedure_name => l_program_name
10093: );
10094: END IF;

Line 10279: IF FND_MSG_PUB.Check_Msg_Level(

10275: p_module_name => g_module_name,
10276: p_procedure_name => l_program_name
10277: );
10278: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10279: IF FND_MSG_PUB.Check_Msg_Level(
10280: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10281: ) THEN
10282: FND_MSG_PUB.Add_Exc_Msg(
10283: p_pkg_name => g_pkg_name,

Line 10280: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

10276: p_procedure_name => l_program_name
10277: );
10278: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10279: IF FND_MSG_PUB.Check_Msg_Level(
10280: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10281: ) THEN
10282: FND_MSG_PUB.Add_Exc_Msg(
10283: p_pkg_name => g_pkg_name,
10284: p_procedure_name => l_program_name

Line 10282: FND_MSG_PUB.Add_Exc_Msg(

10278: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10279: IF FND_MSG_PUB.Check_Msg_Level(
10280: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10281: ) THEN
10282: FND_MSG_PUB.Add_Exc_Msg(
10283: p_pkg_name => g_pkg_name,
10284: p_procedure_name => l_program_name
10285: );
10286: END IF;

Line 10554: FND_MSG_PUB.ADD;

10550: p_debug_info => l_debug_info);
10551:
10552: FND_MESSAGE.set_name('INL','INL_ERR_OI_CHK_LCK_SHIPMENT');
10553: FND_MESSAGE.set_token('GROUP_ID',distgroupid_List(iGroup).group_id);
10554: FND_MSG_PUB.ADD;
10555:
10556: l_debug_info := 'Set Interface Status to PENDING for group id: '||distgroupid_List(iGroup).group_id;
10557:
10558: UPDATE inl_matches_int mi

Line 11060: IF FND_MSG_PUB.Check_Msg_Level(

11056: p_module_name => g_module_name,
11057: p_procedure_name => l_program_name
11058: );
11059: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11060: IF FND_MSG_PUB.Check_Msg_Level(
11061: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11062: ) THEN
11063: FND_MSG_PUB.Add_Exc_Msg(
11064: p_pkg_name => g_pkg_name,

Line 11061: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11057: p_procedure_name => l_program_name
11058: );
11059: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11060: IF FND_MSG_PUB.Check_Msg_Level(
11061: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11062: ) THEN
11063: FND_MSG_PUB.Add_Exc_Msg(
11064: p_pkg_name => g_pkg_name,
11065: p_procedure_name => l_program_name

Line 11063: FND_MSG_PUB.Add_Exc_Msg(

11059: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11060: IF FND_MSG_PUB.Check_Msg_Level(
11061: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11062: ) THEN
11063: FND_MSG_PUB.Add_Exc_Msg(
11064: p_pkg_name => g_pkg_name,
11065: p_procedure_name => l_program_name
11066: );
11067: END IF;

Line 11193: IF FND_MSG_PUB.Check_Msg_Level(

11189: p_module_name => g_module_name,
11190: p_procedure_name => l_program_name
11191: );
11192: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11193: IF FND_MSG_PUB.Check_Msg_Level(
11194: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11195: ) THEN
11196: FND_MSG_PUB.Add_Exc_Msg(
11197: p_pkg_name => g_pkg_name,

Line 11194: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11190: p_procedure_name => l_program_name
11191: );
11192: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11193: IF FND_MSG_PUB.Check_Msg_Level(
11194: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11195: ) THEN
11196: FND_MSG_PUB.Add_Exc_Msg(
11197: p_pkg_name => g_pkg_name,
11198: p_procedure_name => l_program_name

Line 11196: FND_MSG_PUB.Add_Exc_Msg(

11192: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11193: IF FND_MSG_PUB.Check_Msg_Level(
11194: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11195: ) THEN
11196: FND_MSG_PUB.Add_Exc_Msg(
11197: p_pkg_name => g_pkg_name,
11198: p_procedure_name => l_program_name
11199: );
11200: END IF;

Line 11360: IF FND_MSG_PUB.Check_Msg_Level(

11356: INL_LOGGING_PVT.Log_UnexpecError (
11357: p_module_name => g_module_name,
11358: p_procedure_name => l_program_name
11359: );
11360: IF FND_MSG_PUB.Check_Msg_Level(
11361: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11362: ) THEN
11363: FND_MSG_PUB.Add_Exc_Msg(
11364: p_pkg_name => g_pkg_name,

Line 11361: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11357: p_module_name => g_module_name,
11358: p_procedure_name => l_program_name
11359: );
11360: IF FND_MSG_PUB.Check_Msg_Level(
11361: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11362: ) THEN
11363: FND_MSG_PUB.Add_Exc_Msg(
11364: p_pkg_name => g_pkg_name,
11365: p_procedure_name => l_program_name

Line 11363: FND_MSG_PUB.Add_Exc_Msg(

11359: );
11360: IF FND_MSG_PUB.Check_Msg_Level(
11361: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11362: ) THEN
11363: FND_MSG_PUB.Add_Exc_Msg(
11364: p_pkg_name => g_pkg_name,
11365: p_procedure_name => l_program_name
11366: );
11367: END IF;

Line 11459: IF FND_MSG_PUB.Check_Msg_Level(

11455: INL_LOGGING_PVT.Log_UnexpecError (
11456: p_module_name => g_module_name,
11457: p_procedure_name => l_program_name
11458: );
11459: IF FND_MSG_PUB.Check_Msg_Level(
11460: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11461: ) THEN
11462: FND_MSG_PUB.Add_Exc_Msg(
11463: p_pkg_name => g_pkg_name,

Line 11460: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11456: p_module_name => g_module_name,
11457: p_procedure_name => l_program_name
11458: );
11459: IF FND_MSG_PUB.Check_Msg_Level(
11460: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11461: ) THEN
11462: FND_MSG_PUB.Add_Exc_Msg(
11463: p_pkg_name => g_pkg_name,
11464: p_procedure_name => l_program_name

Line 11462: FND_MSG_PUB.Add_Exc_Msg(

11458: );
11459: IF FND_MSG_PUB.Check_Msg_Level(
11460: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11461: ) THEN
11462: FND_MSG_PUB.Add_Exc_Msg(
11463: p_pkg_name => g_pkg_name,
11464: p_procedure_name => l_program_name
11465: );
11466: END IF;

Line 11957: IF FND_MSG_PUB.Check_Msg_Level(

11953: INL_LOGGING_PVT.Log_UnexpecError (
11954: p_module_name => g_module_name,
11955: p_procedure_name => l_program_name
11956: );
11957: IF FND_MSG_PUB.Check_Msg_Level(
11958: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11959: ) THEN
11960: FND_MSG_PUB.Add_Exc_Msg(
11961: p_pkg_name => g_pkg_name,

Line 11958: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

11954: p_module_name => g_module_name,
11955: p_procedure_name => l_program_name
11956: );
11957: IF FND_MSG_PUB.Check_Msg_Level(
11958: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11959: ) THEN
11960: FND_MSG_PUB.Add_Exc_Msg(
11961: p_pkg_name => g_pkg_name,
11962: p_procedure_name => l_program_name

Line 11960: FND_MSG_PUB.Add_Exc_Msg(

11956: );
11957: IF FND_MSG_PUB.Check_Msg_Level(
11958: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11959: ) THEN
11960: FND_MSG_PUB.Add_Exc_Msg(
11961: p_pkg_name => g_pkg_name,
11962: p_procedure_name => l_program_name
11963: );
11964: END IF;

Line 12132: IF FND_MSG_PUB.Check_Msg_Level(

12128: INL_LOGGING_PVT.Log_UnexpecError (
12129: p_module_name => g_module_name,
12130: p_procedure_name => l_program_name
12131: );
12132: IF FND_MSG_PUB.Check_Msg_Level(
12133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12134: ) THEN
12135: FND_MSG_PUB.Add_Exc_Msg(
12136: p_pkg_name => g_pkg_name,

Line 12133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12129: p_module_name => g_module_name,
12130: p_procedure_name => l_program_name
12131: );
12132: IF FND_MSG_PUB.Check_Msg_Level(
12133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12134: ) THEN
12135: FND_MSG_PUB.Add_Exc_Msg(
12136: p_pkg_name => g_pkg_name,
12137: p_procedure_name => l_program_name

Line 12135: FND_MSG_PUB.Add_Exc_Msg(

12131: );
12132: IF FND_MSG_PUB.Check_Msg_Level(
12133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12134: ) THEN
12135: FND_MSG_PUB.Add_Exc_Msg(
12136: p_pkg_name => g_pkg_name,
12137: p_procedure_name => l_program_name
12138: );
12139: END IF;

Line 12271: IF FND_MSG_PUB.Check_Msg_Level(

12267: INL_LOGGING_PVT.Log_UnexpecError (
12268: p_module_name => g_module_name,
12269: p_procedure_name => l_program_name
12270: );
12271: IF FND_MSG_PUB.Check_Msg_Level(
12272: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12273: ) THEN
12274: FND_MSG_PUB.Add_Exc_Msg(
12275: p_pkg_name => g_pkg_name,

Line 12272: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12268: p_module_name => g_module_name,
12269: p_procedure_name => l_program_name
12270: );
12271: IF FND_MSG_PUB.Check_Msg_Level(
12272: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12273: ) THEN
12274: FND_MSG_PUB.Add_Exc_Msg(
12275: p_pkg_name => g_pkg_name,
12276: p_procedure_name => l_program_name

Line 12274: FND_MSG_PUB.Add_Exc_Msg(

12270: );
12271: IF FND_MSG_PUB.Check_Msg_Level(
12272: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12273: ) THEN
12274: FND_MSG_PUB.Add_Exc_Msg(
12275: p_pkg_name => g_pkg_name,
12276: p_procedure_name => l_program_name
12277: );
12278: END IF;

Line 12665: FND_MSG_PUB.ADD;

12661:
12662: x_return_status := FND_API.g_ret_sts_error;
12663: FND_MESSAGE.set_name('INL','INL_ERR_OI_CHK_LCK_SHIPMENT');
12664: FND_MESSAGE.set_token('GROUP_ID',l_group_id);
12665: FND_MSG_PUB.ADD;
12666:
12667: -- Standard Expected Error Logging
12668: INL_LOGGING_PVT.Log_ExpecError (
12669: p_module_name => g_module_name,

Line 12692: IF FND_MSG_PUB.Check_Msg_Level(

12688: INL_LOGGING_PVT.Log_UnexpecError (
12689: p_module_name => g_module_name,
12690: p_procedure_name => l_program_name
12691: );
12692: IF FND_MSG_PUB.Check_Msg_Level(
12693: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12694: ) THEN
12695: FND_MSG_PUB.Add_Exc_Msg(
12696: p_pkg_name => g_pkg_name,

Line 12693: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12689: p_module_name => g_module_name,
12690: p_procedure_name => l_program_name
12691: );
12692: IF FND_MSG_PUB.Check_Msg_Level(
12693: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12694: ) THEN
12695: FND_MSG_PUB.Add_Exc_Msg(
12696: p_pkg_name => g_pkg_name,
12697: p_procedure_name => l_program_name

Line 12695: FND_MSG_PUB.Add_Exc_Msg(

12691: );
12692: IF FND_MSG_PUB.Check_Msg_Level(
12693: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12694: ) THEN
12695: FND_MSG_PUB.Add_Exc_Msg(
12696: p_pkg_name => g_pkg_name,
12697: p_procedure_name => l_program_name
12698: );
12699: END IF;

Line 12842: IF FND_MSG_PUB.Check_Msg_Level(

12838: INL_LOGGING_PVT.Log_UnexpecError (
12839: p_module_name => g_module_name,
12840: p_procedure_name => l_program_name
12841: );
12842: IF FND_MSG_PUB.Check_Msg_Level(
12843: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12844: ) THEN
12845: FND_MSG_PUB.Add_Exc_Msg(
12846: p_pkg_name => g_pkg_name,

Line 12843: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

12839: p_module_name => g_module_name,
12840: p_procedure_name => l_program_name
12841: );
12842: IF FND_MSG_PUB.Check_Msg_Level(
12843: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12844: ) THEN
12845: FND_MSG_PUB.Add_Exc_Msg(
12846: p_pkg_name => g_pkg_name,
12847: p_procedure_name => l_program_name

Line 12845: FND_MSG_PUB.Add_Exc_Msg(

12841: );
12842: IF FND_MSG_PUB.Check_Msg_Level(
12843: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12844: ) THEN
12845: FND_MSG_PUB.Add_Exc_Msg(
12846: p_pkg_name => g_pkg_name,
12847: p_procedure_name => l_program_name
12848: );
12849: END IF;

Line 13076: IF FND_MSG_PUB.Check_Msg_Level(

13072: INL_LOGGING_PVT.Log_UnexpecError (
13073: p_module_name => g_module_name,
13074: p_procedure_name => l_program_name
13075: );
13076: IF FND_MSG_PUB.Check_Msg_Level(
13077: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13078: ) THEN
13079: FND_MSG_PUB.Add_Exc_Msg(
13080: p_pkg_name => g_pkg_name,

Line 13077: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13073: p_module_name => g_module_name,
13074: p_procedure_name => l_program_name
13075: );
13076: IF FND_MSG_PUB.Check_Msg_Level(
13077: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13078: ) THEN
13079: FND_MSG_PUB.Add_Exc_Msg(
13080: p_pkg_name => g_pkg_name,
13081: p_procedure_name => l_program_name

Line 13079: FND_MSG_PUB.Add_Exc_Msg(

13075: );
13076: IF FND_MSG_PUB.Check_Msg_Level(
13077: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13078: ) THEN
13079: FND_MSG_PUB.Add_Exc_Msg(
13080: p_pkg_name => g_pkg_name,
13081: p_procedure_name => l_program_name
13082: );
13083: END IF;

Line 13505: IF FND_MSG_PUB.Check_Msg_Level(

13501: INL_LOGGING_PVT.Log_UnexpecError (
13502: p_module_name => g_module_name,
13503: p_procedure_name => l_program_name
13504: );
13505: IF FND_MSG_PUB.Check_Msg_Level(
13506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13507: ) THEN
13508: FND_MSG_PUB.Add_Exc_Msg(
13509: p_pkg_name => g_pkg_name,

Line 13506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13502: p_module_name => g_module_name,
13503: p_procedure_name => l_program_name
13504: );
13505: IF FND_MSG_PUB.Check_Msg_Level(
13506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13507: ) THEN
13508: FND_MSG_PUB.Add_Exc_Msg(
13509: p_pkg_name => g_pkg_name,
13510: p_procedure_name => l_program_name

Line 13508: FND_MSG_PUB.Add_Exc_Msg(

13504: );
13505: IF FND_MSG_PUB.Check_Msg_Level(
13506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13507: ) THEN
13508: FND_MSG_PUB.Add_Exc_Msg(
13509: p_pkg_name => g_pkg_name,
13510: p_procedure_name => l_program_name
13511: );
13512: END IF;

Line 13786: IF FND_MSG_PUB.Check_Msg_Level(

13782: INL_LOGGING_PVT.Log_UnexpecError (
13783: p_module_name => g_module_name,
13784: p_procedure_name => l_program_name
13785: );
13786: IF FND_MSG_PUB.Check_Msg_Level(
13787: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13788: ) THEN
13789: FND_MSG_PUB.Add_Exc_Msg(
13790: p_pkg_name => g_pkg_name,

Line 13787: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

13783: p_module_name => g_module_name,
13784: p_procedure_name => l_program_name
13785: );
13786: IF FND_MSG_PUB.Check_Msg_Level(
13787: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13788: ) THEN
13789: FND_MSG_PUB.Add_Exc_Msg(
13790: p_pkg_name => g_pkg_name,
13791: p_procedure_name => l_program_name

Line 13789: FND_MSG_PUB.Add_Exc_Msg(

13785: );
13786: IF FND_MSG_PUB.Check_Msg_Level(
13787: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13788: ) THEN
13789: FND_MSG_PUB.Add_Exc_Msg(
13790: p_pkg_name => g_pkg_name,
13791: p_procedure_name => l_program_name
13792: );
13793: END IF;

Line 14006: IF FND_MSG_PUB.Check_Msg_Level(

14002: INL_LOGGING_PVT.Log_UnexpecError (
14003: p_module_name => g_module_name,
14004: p_procedure_name => l_program_name
14005: );
14006: IF FND_MSG_PUB.Check_Msg_Level(
14007: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14008: ) THEN
14009: FND_MSG_PUB.Add_Exc_Msg(
14010: p_pkg_name => g_pkg_name,

Line 14007: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

14003: p_module_name => g_module_name,
14004: p_procedure_name => l_program_name
14005: );
14006: IF FND_MSG_PUB.Check_Msg_Level(
14007: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14008: ) THEN
14009: FND_MSG_PUB.Add_Exc_Msg(
14010: p_pkg_name => g_pkg_name,
14011: p_procedure_name => l_program_name

Line 14009: FND_MSG_PUB.Add_Exc_Msg(

14005: );
14006: IF FND_MSG_PUB.Check_Msg_Level(
14007: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14008: ) THEN
14009: FND_MSG_PUB.Add_Exc_Msg(
14010: p_pkg_name => g_pkg_name,
14011: p_procedure_name => l_program_name
14012: );
14013: END IF;

Line 14505: IF FND_MSG_PUB.Check_Msg_Level(

14501: INL_LOGGING_PVT.Log_UnexpecError (
14502: p_module_name => g_module_name,
14503: p_procedure_name => l_program_name
14504: );
14505: IF FND_MSG_PUB.Check_Msg_Level(
14506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14507: ) THEN
14508: FND_MSG_PUB.Add_Exc_Msg(
14509: p_pkg_name => g_pkg_name,

Line 14506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

14502: p_module_name => g_module_name,
14503: p_procedure_name => l_program_name
14504: );
14505: IF FND_MSG_PUB.Check_Msg_Level(
14506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14507: ) THEN
14508: FND_MSG_PUB.Add_Exc_Msg(
14509: p_pkg_name => g_pkg_name,
14510: p_procedure_name => l_program_name

Line 14508: FND_MSG_PUB.Add_Exc_Msg(

14504: );
14505: IF FND_MSG_PUB.Check_Msg_Level(
14506: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14507: ) THEN
14508: FND_MSG_PUB.Add_Exc_Msg(
14509: p_pkg_name => g_pkg_name,
14510: p_procedure_name => l_program_name
14511: );
14512: END IF;

Line 14756: IF FND_MSG_PUB.Check_Msg_Level(

14752: INL_LOGGING_PVT.Log_UnexpecError (
14753: p_module_name => g_module_name,
14754: p_procedure_name => l_program_name
14755: );
14756: IF FND_MSG_PUB.Check_Msg_Level(
14757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14758: ) THEN
14759: FND_MSG_PUB.Add_Exc_Msg(
14760: p_pkg_name => g_pkg_name,

Line 14757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

14753: p_module_name => g_module_name,
14754: p_procedure_name => l_program_name
14755: );
14756: IF FND_MSG_PUB.Check_Msg_Level(
14757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14758: ) THEN
14759: FND_MSG_PUB.Add_Exc_Msg(
14760: p_pkg_name => g_pkg_name,
14761: p_procedure_name => l_program_name

Line 14759: FND_MSG_PUB.Add_Exc_Msg(

14755: );
14756: IF FND_MSG_PUB.Check_Msg_Level(
14757: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
14758: ) THEN
14759: FND_MSG_PUB.Add_Exc_Msg(
14760: p_pkg_name => g_pkg_name,
14761: p_procedure_name => l_program_name
14762: );
14763: END IF;

Line 15260: IF FND_MSG_PUB.Check_Msg_Level(

15256: p_module_name => g_module_name,
15257: p_procedure_name => l_program_name
15258: );
15259: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15260: IF FND_MSG_PUB.Check_Msg_Level(
15261: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15262: ) THEN
15263: FND_MSG_PUB.Add_Exc_Msg(
15264: p_pkg_name => g_pkg_name,

Line 15261: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

15257: p_procedure_name => l_program_name
15258: );
15259: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15260: IF FND_MSG_PUB.Check_Msg_Level(
15261: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15262: ) THEN
15263: FND_MSG_PUB.Add_Exc_Msg(
15264: p_pkg_name => g_pkg_name,
15265: p_procedure_name => l_program_name

Line 15263: FND_MSG_PUB.Add_Exc_Msg(

15259: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15260: IF FND_MSG_PUB.Check_Msg_Level(
15261: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15262: ) THEN
15263: FND_MSG_PUB.Add_Exc_Msg(
15264: p_pkg_name => g_pkg_name,
15265: p_procedure_name => l_program_name
15266: );
15267: END IF;

Line 15324: FND_MSG_PUB.initialize;

15320: SAVEPOINT Purge_LCMShipInt_PVT;
15321:
15322: -- Initialize message list if p_init_msg_list is set to TRUE.
15323: IF FND_API.to_Boolean(p_init_msg_list) THEN
15324: FND_MSG_PUB.initialize;
15325: END IF;
15326:
15327: -- Standard call to check for call compatibility
15328: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 15378: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15374: COMMIT WORK;
15375: END IF;
15376:
15377: -- Standard call to get message count and if count is 1, get message info.
15378: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15379: p_count => x_msg_count,
15380: p_data => x_msg_data) ;
15381:
15382: -- Standard End of Procedure/Function Logging

Line 15393: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15389: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
15390: p_procedure_name => l_program_name);
15391: ROLLBACK TO Purge_LCMShipInt_PVT;
15392: x_return_status := L_FND_RET_STS_ERROR;
15393: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15394: p_count => x_msg_count,
15395: p_data => x_msg_data);
15396: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15397: -- Standard Unexpected Error Logging

Line 15402: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15398: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15399: p_procedure_name => l_program_name);
15400: ROLLBACK TO Purge_LCMShipInt_PVT;
15401: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15402: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15403: p_count => x_msg_count,
15404: p_data => x_msg_data);
15405: WHEN OTHERS THEN
15406: -- Standard Unexpected Error Logging

Line 15411: IF FND_MSG_PUB.Check_Msg_Level(

15407: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15408: p_procedure_name => l_program_name);
15409: ROLLBACK TO Purge_LCMShipInt_PVT;
15410: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15411: IF FND_MSG_PUB.Check_Msg_Level(
15412: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15413: ) THEN
15414: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15415: p_procedure_name => l_program_name );

Line 15412: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

15408: p_procedure_name => l_program_name);
15409: ROLLBACK TO Purge_LCMShipInt_PVT;
15410: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15411: IF FND_MSG_PUB.Check_Msg_Level(
15412: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15413: ) THEN
15414: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15415: p_procedure_name => l_program_name );
15416: END IF;

Line 15414: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

15410: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15411: IF FND_MSG_PUB.Check_Msg_Level(
15412: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15413: ) THEN
15414: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15415: p_procedure_name => l_program_name );
15416: END IF;
15417: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15418: p_count => x_msg_count,

Line 15417: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15413: ) THEN
15414: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15415: p_procedure_name => l_program_name );
15416: END IF;
15417: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15418: p_count => x_msg_count,
15419: p_data => x_msg_data);
15420: END Purge_LCMShipInt;
15421:

Line 15470: FND_MSG_PUB.initialize;

15466: SAVEPOINT Purge_LCMMatchesInt_PVT;
15467:
15468: -- Initialize message list if p_init_msg_list is set to TRUE.
15469: IF FND_API.to_Boolean(p_init_msg_list) THEN
15470: FND_MSG_PUB.initialize;
15471: END IF;
15472:
15473: -- Standard call to check for call compatibility
15474: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

Line 15506: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15502: COMMIT WORK;
15503: END IF;
15504:
15505: -- Standard call to get message count and if count is 1, get message info.
15506: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15507: p_count => x_msg_count,
15508: p_data => x_msg_data) ;
15509:
15510: -- Standard End of Procedure/Function Logging

Line 15521: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
15518: p_procedure_name => l_program_name);
15519: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15520: x_return_status := L_FND_RET_STS_ERROR;
15521: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15522: p_count => x_msg_count,
15523: p_data => x_msg_data);
15524: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15525: -- Standard Unexpected Error Logging

Line 15530: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15526: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15527: p_procedure_name => l_program_name);
15528: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15529: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15530: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15531: p_count => x_msg_count,
15532: p_data => x_msg_data);
15533: WHEN OTHERS THEN
15534: -- Standard Unexpected Error Logging

Line 15539: IF FND_MSG_PUB.Check_Msg_Level(

15535: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15536: p_procedure_name => l_program_name);
15537: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15538: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15539: IF FND_MSG_PUB.Check_Msg_Level(
15540: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15541: ) THEN
15542: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15543: p_procedure_name => l_program_name );

Line 15540: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

15536: p_procedure_name => l_program_name);
15537: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15538: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15539: IF FND_MSG_PUB.Check_Msg_Level(
15540: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15541: ) THEN
15542: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15543: p_procedure_name => l_program_name );
15544: END IF;

Line 15542: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

15538: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15539: IF FND_MSG_PUB.Check_Msg_Level(
15540: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15541: ) THEN
15542: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15543: p_procedure_name => l_program_name );
15544: END IF;
15545: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15546: p_count => x_msg_count,

Line 15545: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,

15541: ) THEN
15542: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
15543: p_procedure_name => l_program_name );
15544: END IF;
15545: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15546: p_count => x_msg_count,
15547: p_data => x_msg_data);
15548: END Purge_LCMMatchesInt;
15549:

Line 15652: IF FND_MSG_PUB.Check_Msg_Level(

15648: p_module_name => g_module_name,
15649: p_procedure_name => l_program_name
15650: );
15651: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15652: IF FND_MSG_PUB.Check_Msg_Level(
15653: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15654: ) THEN
15655: FND_MSG_PUB.Add_Exc_Msg(
15656: p_pkg_name => g_pkg_name,

Line 15653: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

15649: p_procedure_name => l_program_name
15650: );
15651: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15652: IF FND_MSG_PUB.Check_Msg_Level(
15653: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15654: ) THEN
15655: FND_MSG_PUB.Add_Exc_Msg(
15656: p_pkg_name => g_pkg_name,
15657: p_procedure_name => l_program_name

Line 15655: FND_MSG_PUB.Add_Exc_Msg(

15651: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15652: IF FND_MSG_PUB.Check_Msg_Level(
15653: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
15654: ) THEN
15655: FND_MSG_PUB.Add_Exc_Msg(
15656: p_pkg_name => g_pkg_name,
15657: p_procedure_name => l_program_name
15658: );
15659: END IF;

Line 15725: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );

15721: ELSIF l_msg_count > 1 THEN
15722: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_count|| ' warnings found.' );
15723: FOR i IN 1 ..l_msg_count
15724: LOOP
15725: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );
15726: END LOOP;
15727: retcode := 1;
15728: ELSIF NVL(G_RECORDS_COMPLETED,0) <> NVL(G_RECORDS_INSERTED,0) THEN -- Bug #16310024
15729: retcode := 1;

Line 15836: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );

15832: ELSIF l_msg_count > 1 THEN
15833: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_count|| ' warnings found.' );
15834: FOR i IN 1 ..l_msg_count
15835: LOOP
15836: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, L_FND_FALSE) );
15837: END LOOP;
15838: retcode := 1;
15839: END IF;
15840:

Line 15926: FND_MSG_PUB.initialize;

15922: -- Standard Start of API savepoint
15923: SAVEPOINT Import_LCMMatches_PVT;
15924: -- Initialize message list if p_init_msg_list is set to TRUE.
15925: IF FND_API.to_Boolean(p_init_msg_list) THEN
15926: FND_MSG_PUB.initialize;
15927: END IF;
15928: -- Standard call to check for call compatibility
15929: IF NOT FND_API.Compatible_API_Call(
15930: p_current_version_number => l_api_version,

Line 15979: FND_MSG_PUB.Count_And_Get(

15975: IF FND_API.To_Boolean(p_commit) THEN
15976: COMMIT WORK;
15977: END IF;
15978: -- Standard call to get message count and if count is 1, get message info.
15979: FND_MSG_PUB.Count_And_Get(
15980: p_encoded => L_FND_FALSE,
15981: p_count => x_msg_count,
15982: p_data => x_msg_data
15983: ) ;

Line 15998: FND_MSG_PUB.Count_And_Get(

15994: p_procedure_name => l_program_name
15995: );
15996: ROLLBACK TO Import_LCMMatches_PVT;
15997: x_return_status := L_FND_RET_STS_ERROR;
15998: FND_MSG_PUB.Count_And_Get(
15999: p_encoded => L_FND_FALSE,
16000: p_count => x_msg_count,
16001: p_data => x_msg_data
16002: );

Line 16011: FND_MSG_PUB.Count_And_Get(

16007: p_procedure_name => l_program_name
16008: );
16009: ROLLBACK TO Import_LCMMatches_PVT;
16010: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
16011: FND_MSG_PUB.Count_And_Get(
16012: p_encoded => L_FND_FALSE,
16013: p_count => x_msg_count,
16014: p_data => x_msg_data
16015: );

Line 16024: IF FND_MSG_PUB.Check_Msg_Level(

16020: p_procedure_name => l_program_name
16021: );
16022: ROLLBACK TO Import_LCMMatches_PVT;
16023: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
16024: IF FND_MSG_PUB.Check_Msg_Level(
16025: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16026: ) THEN
16027: FND_MSG_PUB.Add_Exc_Msg(
16028: p_pkg_name => g_pkg_name,

Line 16025: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

16021: );
16022: ROLLBACK TO Import_LCMMatches_PVT;
16023: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
16024: IF FND_MSG_PUB.Check_Msg_Level(
16025: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16026: ) THEN
16027: FND_MSG_PUB.Add_Exc_Msg(
16028: p_pkg_name => g_pkg_name,
16029: p_procedure_name => l_program_name

Line 16027: FND_MSG_PUB.Add_Exc_Msg(

16023: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
16024: IF FND_MSG_PUB.Check_Msg_Level(
16025: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16026: ) THEN
16027: FND_MSG_PUB.Add_Exc_Msg(
16028: p_pkg_name => g_pkg_name,
16029: p_procedure_name => l_program_name
16030: );
16031: END IF;

Line 16032: FND_MSG_PUB.Count_And_Get(

16028: p_pkg_name => g_pkg_name,
16029: p_procedure_name => l_program_name
16030: );
16031: END IF;
16032: FND_MSG_PUB.Count_And_Get(
16033: p_encoded => L_FND_FALSE,
16034: p_count => x_msg_count,
16035: p_data => x_msg_data
16036: );

Line 16164: IF FND_MSG_PUB.Check_Msg_Level(

16160: INL_LOGGING_PVT.Log_UnexpecError (
16161: p_module_name => g_module_name,
16162: p_procedure_name => l_program_name
16163: );
16164: IF FND_MSG_PUB.Check_Msg_Level(
16165: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16166: ) THEN
16167: FND_MSG_PUB.Add_Exc_Msg(
16168: p_pkg_name => g_pkg_name,

Line 16165: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

16161: p_module_name => g_module_name,
16162: p_procedure_name => l_program_name
16163: );
16164: IF FND_MSG_PUB.Check_Msg_Level(
16165: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16166: ) THEN
16167: FND_MSG_PUB.Add_Exc_Msg(
16168: p_pkg_name => g_pkg_name,
16169: p_procedure_name => l_program_name

Line 16167: FND_MSG_PUB.Add_Exc_Msg(

16163: );
16164: IF FND_MSG_PUB.Check_Msg_Level(
16165: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16166: ) THEN
16167: FND_MSG_PUB.Add_Exc_Msg(
16168: p_pkg_name => g_pkg_name,
16169: p_procedure_name => l_program_name
16170: );
16171: END IF;

Line 16327: IF FND_MSG_PUB.Check_Msg_Level(

16323: INL_LOGGING_PVT.Log_UnexpecError (
16324: p_module_name => g_module_name,
16325: p_procedure_name => l_program_name
16326: );
16327: IF FND_MSG_PUB.Check_Msg_Level(
16328: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16329: ) THEN
16330: FND_MSG_PUB.Add_Exc_Msg(
16331: p_pkg_name => g_pkg_name,

Line 16328: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

16324: p_module_name => g_module_name,
16325: p_procedure_name => l_program_name
16326: );
16327: IF FND_MSG_PUB.Check_Msg_Level(
16328: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16329: ) THEN
16330: FND_MSG_PUB.Add_Exc_Msg(
16331: p_pkg_name => g_pkg_name,
16332: p_procedure_name => l_program_name

Line 16330: FND_MSG_PUB.Add_Exc_Msg(

16326: );
16327: IF FND_MSG_PUB.Check_Msg_Level(
16328: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16329: ) THEN
16330: FND_MSG_PUB.Add_Exc_Msg(
16331: p_pkg_name => g_pkg_name,
16332: p_procedure_name => l_program_name
16333: );
16334: END IF;

Line 16634: IF FND_MSG_PUB.Check_Msg_Level(

16630: -- Standard Unexpected Error Logging
16631: INL_LOGGING_PVT.Log_UnexpecError (
16632: p_module_name => g_module_name,
16633: p_procedure_name => l_program_name);
16634: IF FND_MSG_PUB.Check_Msg_Level(
16635: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16636: ) THEN
16637: FND_MSG_PUB.Add_Exc_Msg(
16638: p_pkg_name => g_pkg_name,

Line 16635: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

16631: INL_LOGGING_PVT.Log_UnexpecError (
16632: p_module_name => g_module_name,
16633: p_procedure_name => l_program_name);
16634: IF FND_MSG_PUB.Check_Msg_Level(
16635: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16636: ) THEN
16637: FND_MSG_PUB.Add_Exc_Msg(
16638: p_pkg_name => g_pkg_name,
16639: p_procedure_name => l_program_name);

Line 16637: FND_MSG_PUB.Add_Exc_Msg(

16633: p_procedure_name => l_program_name);
16634: IF FND_MSG_PUB.Check_Msg_Level(
16635: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16636: ) THEN
16637: FND_MSG_PUB.Add_Exc_Msg(
16638: p_pkg_name => g_pkg_name,
16639: p_procedure_name => l_program_name);
16640: END IF;
16641: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 16764: IF FND_MSG_PUB.Check_Msg_Level(

16760: -- Standard Unexpected Error Logging
16761: INL_LOGGING_PVT.Log_UnexpecError (
16762: p_module_name => g_module_name,
16763: p_procedure_name => l_program_name);
16764: IF FND_MSG_PUB.Check_Msg_Level(
16765: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16766: ) THEN
16767: FND_MSG_PUB.Add_Exc_Msg(
16768: p_pkg_name => g_pkg_name,

Line 16765: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

16761: INL_LOGGING_PVT.Log_UnexpecError (
16762: p_module_name => g_module_name,
16763: p_procedure_name => l_program_name);
16764: IF FND_MSG_PUB.Check_Msg_Level(
16765: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16766: ) THEN
16767: FND_MSG_PUB.Add_Exc_Msg(
16768: p_pkg_name => g_pkg_name,
16769: p_procedure_name => l_program_name);

Line 16767: FND_MSG_PUB.Add_Exc_Msg(

16763: p_procedure_name => l_program_name);
16764: IF FND_MSG_PUB.Check_Msg_Level(
16765: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
16766: ) THEN
16767: FND_MSG_PUB.Add_Exc_Msg(
16768: p_pkg_name => g_pkg_name,
16769: p_procedure_name => l_program_name);
16770: END IF;
16771: RETURN FND_API.to_boolean(L_FND_FALSE) ;

Line 16860: FND_MSG_PUB.initialize;

16856: -- Standard Start of API savepoint
16857: SAVEPOINT Import_LCMShipments_PVT;
16858: -- Initialize message list if p_init_msg_list is set to TRUE.
16859: IF FND_API.to_Boolean(p_init_msg_list) THEN
16860: FND_MSG_PUB.initialize;
16861: END IF;
16862: -- Standard call to check for call compatibility
16863: IF NOT FND_API.Compatible_API_Call(
16864: p_current_version_number => l_api_version,

Line 17490: FND_MSG_PUB.Count_And_Get(

17486: IF FND_API.To_Boolean(p_commit) THEN
17487: COMMIT WORK;
17488: END IF;
17489: -- Standard call to get message count and if count is 1, get message info.
17490: FND_MSG_PUB.Count_And_Get(
17491: p_encoded => L_FND_FALSE,
17492: p_count => x_msg_count,
17493: p_data => x_msg_data) ;
17494: -- Standard End of Procedure/Function Logging

Line 17507: FND_MSG_PUB.Count_And_Get(

17503: p_module_name => g_module_name,
17504: p_procedure_name => l_program_name);
17505: ROLLBACK TO Import_LCMShipments_PVT;
17506: x_return_status := L_FND_RET_STS_ERROR;
17507: FND_MSG_PUB.Count_And_Get(
17508: p_encoded => L_FND_FALSE,
17509: p_count => x_msg_count,
17510: p_data => x_msg_data);
17511: --Bug#10381495

Line 17528: FND_MSG_PUB.Count_And_Get(

17524: p_module_name => g_module_name,
17525: p_procedure_name => l_program_name);
17526: ROLLBACK TO Import_LCMShipments_PVT;
17527: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17528: FND_MSG_PUB.Count_And_Get(
17529: p_encoded => L_FND_FALSE,
17530: p_count => x_msg_count,
17531: p_data => x_msg_data);
17532: --Bug#10381495

Line 17549: IF FND_MSG_PUB.Check_Msg_Level(

17545: p_module_name => g_module_name,
17546: p_procedure_name => l_program_name);
17547: ROLLBACK TO Import_LCMShipments_PVT;
17548: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
17549: IF FND_MSG_PUB.Check_Msg_Level(
17550: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17551: ) THEN
17552: FND_MSG_PUB.Add_Exc_Msg(
17553: p_pkg_name => g_pkg_name,

Line 17550: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

17546: p_procedure_name => l_program_name);
17547: ROLLBACK TO Import_LCMShipments_PVT;
17548: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
17549: IF FND_MSG_PUB.Check_Msg_Level(
17550: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17551: ) THEN
17552: FND_MSG_PUB.Add_Exc_Msg(
17553: p_pkg_name => g_pkg_name,
17554: p_procedure_name => l_program_name);

Line 17552: FND_MSG_PUB.Add_Exc_Msg(

17548: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
17549: IF FND_MSG_PUB.Check_Msg_Level(
17550: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17551: ) THEN
17552: FND_MSG_PUB.Add_Exc_Msg(
17553: p_pkg_name => g_pkg_name,
17554: p_procedure_name => l_program_name);
17555: END IF;
17556: FND_MSG_PUB.Count_And_Get(

Line 17556: FND_MSG_PUB.Count_And_Get(

17552: FND_MSG_PUB.Add_Exc_Msg(
17553: p_pkg_name => g_pkg_name,
17554: p_procedure_name => l_program_name);
17555: END IF;
17556: FND_MSG_PUB.Count_And_Get(
17557: p_encoded => L_FND_FALSE,
17558: p_count => x_msg_count,
17559: p_data => x_msg_data);
17560: --Bug#10381495

Line 17694: IF FND_MSG_PUB.Check_Msg_Level(

17690: INL_LOGGING_PVT.Log_UnexpecError (
17691: p_module_name => g_module_name,
17692: p_procedure_name => l_program_name);
17693: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17694: IF FND_MSG_PUB.Check_Msg_Level(
17695: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17696: ) THEN
17697: FND_MSG_PUB.Add_Exc_Msg(
17698: p_pkg_name => g_pkg_name,

Line 17695: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

17691: p_module_name => g_module_name,
17692: p_procedure_name => l_program_name);
17693: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17694: IF FND_MSG_PUB.Check_Msg_Level(
17695: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17696: ) THEN
17697: FND_MSG_PUB.Add_Exc_Msg(
17698: p_pkg_name => g_pkg_name,
17699: p_procedure_name => l_program_name);

Line 17697: FND_MSG_PUB.Add_Exc_Msg(

17693: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17694: IF FND_MSG_PUB.Check_Msg_Level(
17695: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
17696: ) THEN
17697: FND_MSG_PUB.Add_Exc_Msg(
17698: p_pkg_name => g_pkg_name,
17699: p_procedure_name => l_program_name);
17700: END IF;
17701: END Reset_MatchInt;