APPS.GMD_ERES_UTILS dependencies on FND_MESSAGE

Line 883: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

879: RETURN FALSE;
880: EXCEPTION
881: WHEN OTHERS THEN
882: ROLLBACK to Savepoint check_vr_required;
883: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
885: FND_MSG_PUB.ADD;
886: RETURN TRUE;
887: END check_recipe_validity_eres;

Line 884: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

880: EXCEPTION
881: WHEN OTHERS THEN
882: ROLLBACK to Savepoint check_vr_required;
883: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
884: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
885: FND_MSG_PUB.ADD;
886: RETURN TRUE;
887: END check_recipe_validity_eres;
888:

Line 983: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA');

979: BEGIN
980: SAVEPOINT update_formula;
981: X_return_status := FND_API.g_ret_sts_success;
982:
983: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA');
984: l_object_type := FND_MESSAGE.GET;
985:
986: SELECT 'x'
987: INTO l_text

Line 984: l_object_type := FND_MESSAGE.GET;

980: SAVEPOINT update_formula;
981: X_return_status := FND_API.g_ret_sts_success;
982:
983: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORMULA');
984: l_object_type := FND_MESSAGE.GET;
985:
986: SELECT 'x'
987: INTO l_text
988: FROM fm_form_mst

Line 1009: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');

1005: --Get the access type of the formula
1006: l_access_type_ind := GMD_API_GRP.GET_FORMULA_ACCESS_TYPE(p_formula_id => p_formula_id,
1007: p_owner_organization_id => l_owner_organization_id);
1008: IF (l_access_type_ind ='V') THEN
1009: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');
1010: FND_MSG_PUB.ADD;
1011: RAISE STATUS_UPDATE_FAILURE;
1012: END IF;
1013:

Line 1037: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

1033: FETCH Cur_get_status_desc INTO l_to_status_desc;
1034: CLOSE Cur_get_status_desc;
1035:
1036: IF p_pending_status IS NULL THEN
1037: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1038: RAISE PENDING_STATUS_ERR;
1039: END IF;
1040: IF p_rework_status IS NULL THEN
1041: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 1041: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

1037: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1038: RAISE PENDING_STATUS_ERR;
1039: END IF;
1040: IF p_rework_status IS NULL THEN
1041: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
1042: RAISE REWORK_STATUS_ERR;
1043: END IF;
1044: END IF; /* IF (l_esig_reqd) */
1045:

Line 1048: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_FORM_USR_LBL');

1044: END IF; /* IF (l_esig_reqd) */
1045:
1046: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1047:
1048: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_FORM_USR_LBL');
1049: l_user_key_label := FND_MESSAGE.GET;
1050: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.formula.sts'
1051: ,p_event_key => p_formula_id
1052: ,p_parameter_name1 => 'DEFERRED'

Line 1049: l_user_key_label := FND_MESSAGE.GET;

1045:
1046: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1047:
1048: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_FORM_USR_LBL');
1049: l_user_key_label := FND_MESSAGE.GET;
1050: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.formula.sts'
1051: ,p_event_key => p_formula_id
1052: ,p_parameter_name1 => 'DEFERRED'
1053: ,p_parameter_value1 => 'Y'

Line 1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

1072: UPDATE fm_form_mst
1073: SET formula_status = p_pending_status
1074: WHERE formula_id = p_formula_id;
1075: IF p_called_from_form = 'F' THEN
1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1078: FND_FILE.PUT(FND_FILE.LOG,
1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1080: ||' :'||p_object_version||')');

Line 1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

1073: SET formula_status = p_pending_status
1074: WHERE formula_id = p_formula_id;
1075: IF p_called_from_form = 'F' THEN
1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1078: FND_FILE.PUT(FND_FILE.LOG,
1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1080: ||' :'||p_object_version||')');
1081: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

1075: IF p_called_from_form = 'F' THEN
1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1077: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1078: FND_FILE.PUT(FND_FILE.LOG,
1079: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1080: ||' :'||p_object_version||')');
1081: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1082: END IF;
1083: END IF; /* IF l_esig_reqd */

Line 1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

1086: WHEN PENDING_STATUS_ERR OR
1087: REWORK_STATUS_ERR THEN
1088: ROLLBACK TO SAVEPOINT update_formula;
1089: X_return_status := FND_API.g_ret_sts_error;
1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1092: l_text := FND_MESSAGE.GET;
1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1094: l_version_lbl := FND_MESSAGE.GET;

Line 1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

1087: REWORK_STATUS_ERR THEN
1088: ROLLBACK TO SAVEPOINT update_formula;
1089: X_return_status := FND_API.g_ret_sts_error;
1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1092: l_text := FND_MESSAGE.GET;
1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1094: l_version_lbl := FND_MESSAGE.GET;
1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

Line 1092: l_text := FND_MESSAGE.GET;

1088: ROLLBACK TO SAVEPOINT update_formula;
1089: X_return_status := FND_API.g_ret_sts_error;
1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1092: l_text := FND_MESSAGE.GET;
1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1094: l_version_lbl := FND_MESSAGE.GET;
1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1096: ||' :'||p_object_version||')';

Line 1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

1089: X_return_status := FND_API.g_ret_sts_error;
1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1092: l_text := FND_MESSAGE.GET;
1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1094: l_version_lbl := FND_MESSAGE.GET;
1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1096: ||' :'||p_object_version||')';
1097: IF p_called_from_form = 'F' THEN

Line 1094: l_version_lbl := FND_MESSAGE.GET;

1090: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1091: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1092: l_text := FND_MESSAGE.GET;
1093: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1094: l_version_lbl := FND_MESSAGE.GET;
1095: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1096: ||' :'||p_object_version||')';
1097: IF p_called_from_form = 'F' THEN
1098: FND_FILE.PUT(FND_FILE.LOG, l_text);

Line 1101: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

1097: IF p_called_from_form = 'F' THEN
1098: FND_FILE.PUT(FND_FILE.LOG, l_text);
1099: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1100: ELSE
1101: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1103: FND_MSG_PUB.add;
1104: END IF;
1105: WHEN app_exception.record_lock_exception THEN

Line 1102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

1098: FND_FILE.PUT(FND_FILE.LOG, l_text);
1099: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1100: ELSE
1101: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1103: FND_MSG_PUB.add;
1104: END IF;
1105: WHEN app_exception.record_lock_exception THEN
1106: ROLLBACK TO SAVEPOINT update_formula;

Line 1136: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1132: OPEN Cur_get_desc;
1133: FETCH Cur_get_desc INTO l_replace_type_desc;
1134: CLOSE Cur_get_desc;
1135:
1136: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1137: l_status := FND_MESSAGE.GET;
1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1137: l_status := FND_MESSAGE.GET;

1133: FETCH Cur_get_desc INTO l_replace_type_desc;
1134: CLOSE Cur_get_desc;
1135:
1136: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1137: l_status := FND_MESSAGE.GET;
1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

Line 1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1135:
1136: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1137: l_status := FND_MESSAGE.GET;
1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

Line 1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

1136: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1137: l_status := FND_MESSAGE.GET;
1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

Line 1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

1137: l_status := FND_MESSAGE.GET;
1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

Line 1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);

1138:
1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN

Line 1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

1139: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

1140: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

1141: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1142: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1149: ELSE

Line 1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1143: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1144: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1145: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1146: IF p_called_from_form = 'F' THEN
1147: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1149: ELSE
1150: FND_MSG_PUB.add;
1151: END IF;

Line 1202: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPERATION');

1198: BEGIN
1199: SAVEPOINT update_operation;
1200: X_return_status := FND_API.g_ret_sts_success;
1201:
1202: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPERATION');
1203: l_object_type := FND_MESSAGE.GET;
1204:
1205: SELECT 'x'
1206: INTO l_text

Line 1203: l_object_type := FND_MESSAGE.GET;

1199: SAVEPOINT update_operation;
1200: X_return_status := FND_API.g_ret_sts_success;
1201:
1202: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPERATION');
1203: l_object_type := FND_MESSAGE.GET;
1204:
1205: SELECT 'x'
1206: INTO l_text
1207: FROM gmd_operations_b

Line 1237: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

1233: FETCH Cur_get_status_desc INTO l_to_status_desc;
1234: CLOSE Cur_get_status_desc;
1235:
1236: IF p_pending_status IS NULL THEN
1237: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1238: RAISE PENDING_STATUS_ERR;
1239: END IF;
1240: IF p_rework_status IS NULL THEN
1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

1237: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1238: RAISE PENDING_STATUS_ERR;
1239: END IF;
1240: IF p_rework_status IS NULL THEN
1241: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
1242: RAISE REWORK_STATUS_ERR;
1243: END IF;
1244: END IF; /* IF (l_esig_reqd) */
1245:

Line 1248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_OPER_USR_LBL');

1244: END IF; /* IF (l_esig_reqd) */
1245:
1246: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1247:
1248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_OPER_USR_LBL');
1249: l_user_key_label := FND_MESSAGE.GET;
1250:
1251: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.operation.sts'
1252: ,p_event_key => p_oprn_id

Line 1249: l_user_key_label := FND_MESSAGE.GET;

1245:
1246: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1247:
1248: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_OPER_USR_LBL');
1249: l_user_key_label := FND_MESSAGE.GET;
1250:
1251: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.operation.sts'
1252: ,p_event_key => p_oprn_id
1253: ,p_parameter_name1 => 'DEFERRED'

Line 1279: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

1275: SET operation_status = p_pending_status
1276: WHERE oprn_id = p_oprn_id;
1277:
1278: IF p_called_from_form = 'F' THEN
1279: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1281: FND_FILE.PUT(FND_FILE.LOG,
1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1283: ||' :'||p_object_version||')');

Line 1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

1276: WHERE oprn_id = p_oprn_id;
1277:
1278: IF p_called_from_form = 'F' THEN
1279: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1281: FND_FILE.PUT(FND_FILE.LOG,
1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1283: ||' :'||p_object_version||')');
1284: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

1278: IF p_called_from_form = 'F' THEN
1279: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1280: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1281: FND_FILE.PUT(FND_FILE.LOG,
1282: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1283: ||' :'||p_object_version||')');
1284: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1285: END IF;
1286: END IF; /* IF l_esig_reqd */

Line 1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

1288: WHEN PENDING_STATUS_ERR OR
1289: REWORK_STATUS_ERR THEN
1290: ROLLBACK TO SAVEPOINT update_operation;
1291: X_return_status := FND_API.g_ret_sts_error;
1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1294: l_text := FND_MESSAGE.GET;
1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1296: l_version_lbl := FND_MESSAGE.GET;

Line 1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

1289: REWORK_STATUS_ERR THEN
1290: ROLLBACK TO SAVEPOINT update_operation;
1291: X_return_status := FND_API.g_ret_sts_error;
1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1294: l_text := FND_MESSAGE.GET;
1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1296: l_version_lbl := FND_MESSAGE.GET;
1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

Line 1294: l_text := FND_MESSAGE.GET;

1290: ROLLBACK TO SAVEPOINT update_operation;
1291: X_return_status := FND_API.g_ret_sts_error;
1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1294: l_text := FND_MESSAGE.GET;
1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1296: l_version_lbl := FND_MESSAGE.GET;
1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1298: ||' :'||p_object_version||')';

Line 1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

1291: X_return_status := FND_API.g_ret_sts_error;
1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1294: l_text := FND_MESSAGE.GET;
1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1296: l_version_lbl := FND_MESSAGE.GET;
1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1298: ||' :'||p_object_version||')';
1299: IF p_called_from_form = 'F' THEN

Line 1296: l_version_lbl := FND_MESSAGE.GET;

1292: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1293: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1294: l_text := FND_MESSAGE.GET;
1295: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1296: l_version_lbl := FND_MESSAGE.GET;
1297: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1298: ||' :'||p_object_version||')';
1299: IF p_called_from_form = 'F' THEN
1300: FND_FILE.PUT(FND_FILE.LOG, l_text);

Line 1303: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

1299: IF p_called_from_form = 'F' THEN
1300: FND_FILE.PUT(FND_FILE.LOG, l_text);
1301: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1302: ELSE
1303: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1304: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1305: FND_MSG_PUB.add;
1306: END IF;
1307: WHEN app_exception.record_lock_exception THEN

Line 1304: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

1300: FND_FILE.PUT(FND_FILE.LOG, l_text);
1301: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1302: ELSE
1303: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1304: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1305: FND_MSG_PUB.add;
1306: END IF;
1307: WHEN app_exception.record_lock_exception THEN
1308: ROLLBACK TO SAVEPOINT update_operation;

Line 1328: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1324: OPEN Cur_get_desc;
1325: FETCH Cur_get_desc INTO l_replace_type_desc;
1326: CLOSE Cur_get_desc;
1327:
1328: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1329: l_status := FND_MESSAGE.GET;
1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1329: l_status := FND_MESSAGE.GET;

1325: FETCH Cur_get_desc INTO l_replace_type_desc;
1326: CLOSE Cur_get_desc;
1327:
1328: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1329: l_status := FND_MESSAGE.GET;
1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

Line 1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1327:
1328: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1329: l_status := FND_MESSAGE.GET;
1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

Line 1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

1328: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1329: l_status := FND_MESSAGE.GET;
1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

Line 1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

1329: l_status := FND_MESSAGE.GET;
1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

Line 1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);

1330:
1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN

Line 1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

1331: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

1332: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

1333: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1334: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1341: ELSE

Line 1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1335: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1336: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1337: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1338: IF p_called_from_form = 'F' THEN
1339: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1340: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1341: ELSE
1342: FND_MSG_PUB.add;
1343: END IF;

Line 1392: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING');

1388: BEGIN
1389: SAVEPOINT update_routing;
1390: X_return_status := FND_API.g_ret_sts_success;
1391:
1392: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING');
1393: l_object_type := FND_MESSAGE.GET;
1394:
1395: SELECT 'x'
1396: INTO l_text

Line 1393: l_object_type := FND_MESSAGE.GET;

1389: SAVEPOINT update_routing;
1390: X_return_status := FND_API.g_ret_sts_success;
1391:
1392: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING');
1393: l_object_type := FND_MESSAGE.GET;
1394:
1395: SELECT 'x'
1396: INTO l_text
1397: FROM gmd_routings_b

Line 1427: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

1423: FETCH Cur_get_status_desc INTO l_to_status_desc;
1424: CLOSE Cur_get_status_desc;
1425:
1426: IF p_pending_status IS NULL THEN
1427: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1428: RAISE PENDING_STATUS_ERR;
1429: END IF;
1430: IF p_rework_status IS NULL THEN
1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

1427: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1428: RAISE PENDING_STATUS_ERR;
1429: END IF;
1430: IF p_rework_status IS NULL THEN
1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
1432: RAISE REWORK_STATUS_ERR;
1433: END IF;
1434: END IF; /* IF (l_esig_reqd) */
1435:

Line 1438: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_ROUT_USR_LBL');

1434: END IF; /* IF (l_esig_reqd) */
1435:
1436: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1437:
1438: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_ROUT_USR_LBL');
1439: l_user_key_label := FND_MESSAGE.GET;
1440: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.routing.sts'
1441: ,p_event_key => p_routing_id
1442: ,p_parameter_name1 => 'DEFERRED'

Line 1439: l_user_key_label := FND_MESSAGE.GET;

1435:
1436: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */
1437:
1438: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_ROUT_USR_LBL');
1439: l_user_key_label := FND_MESSAGE.GET;
1440: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.routing.sts'
1441: ,p_event_key => p_routing_id
1442: ,p_parameter_name1 => 'DEFERRED'
1443: ,p_parameter_value1 => 'Y'

Line 1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

1461: UPDATE gmd_routings_b
1462: SET routing_status = p_pending_status
1463: WHERE routing_id = p_routing_id;
1464: IF p_called_from_form = 'F' THEN
1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1467: FND_FILE.PUT(FND_FILE.LOG,
1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1469: ||' :'||p_object_version||')');

Line 1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

1462: SET routing_status = p_pending_status
1463: WHERE routing_id = p_routing_id;
1464: IF p_called_from_form = 'F' THEN
1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1467: FND_FILE.PUT(FND_FILE.LOG,
1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1469: ||' :'||p_object_version||')');
1470: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

1464: IF p_called_from_form = 'F' THEN
1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1466: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1467: FND_FILE.PUT(FND_FILE.LOG,
1468: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1469: ||' :'||p_object_version||')');
1470: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1471: END IF;
1472: END IF; /* IF l_esig_reqd */

Line 1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

1474: WHEN PENDING_STATUS_ERR OR
1475: REWORK_STATUS_ERR THEN
1476: ROLLBACK TO SAVEPOINT update_routing;
1477: X_return_status := FND_API.g_ret_sts_error;
1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1480: l_text := FND_MESSAGE.GET;
1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1482: l_version_lbl := FND_MESSAGE.GET;

Line 1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

1475: REWORK_STATUS_ERR THEN
1476: ROLLBACK TO SAVEPOINT update_routing;
1477: X_return_status := FND_API.g_ret_sts_error;
1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1480: l_text := FND_MESSAGE.GET;
1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1482: l_version_lbl := FND_MESSAGE.GET;
1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

Line 1480: l_text := FND_MESSAGE.GET;

1476: ROLLBACK TO SAVEPOINT update_routing;
1477: X_return_status := FND_API.g_ret_sts_error;
1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1480: l_text := FND_MESSAGE.GET;
1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1482: l_version_lbl := FND_MESSAGE.GET;
1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1484: ||' :'||p_object_version||')';

Line 1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

1477: X_return_status := FND_API.g_ret_sts_error;
1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1480: l_text := FND_MESSAGE.GET;
1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1482: l_version_lbl := FND_MESSAGE.GET;
1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1484: ||' :'||p_object_version||')';
1485: IF p_called_from_form = 'F' THEN

Line 1482: l_version_lbl := FND_MESSAGE.GET;

1478: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1479: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1480: l_text := FND_MESSAGE.GET;
1481: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1482: l_version_lbl := FND_MESSAGE.GET;
1483: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1484: ||' :'||p_object_version||')';
1485: IF p_called_from_form = 'F' THEN
1486: FND_FILE.PUT(FND_FILE.LOG, l_text);

Line 1489: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

1485: IF p_called_from_form = 'F' THEN
1486: FND_FILE.PUT(FND_FILE.LOG, l_text);
1487: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1488: ELSE
1489: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1490: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1491: FND_MSG_PUB.add;
1492: END IF;
1493: WHEN app_exception.record_lock_exception THEN

Line 1490: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

1486: FND_FILE.PUT(FND_FILE.LOG, l_text);
1487: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1488: ELSE
1489: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1490: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1491: FND_MSG_PUB.add;
1492: END IF;
1493: WHEN app_exception.record_lock_exception THEN
1494: ROLLBACK TO SAVEPOINT update_routing;

Line 1514: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1510: OPEN Cur_get_desc;
1511: FETCH Cur_get_desc INTO l_replace_type_desc;
1512: CLOSE Cur_get_desc;
1513:
1514: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1515: l_status := FND_MESSAGE.GET;
1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1515: l_status := FND_MESSAGE.GET;

1511: FETCH Cur_get_desc INTO l_replace_type_desc;
1512: CLOSE Cur_get_desc;
1513:
1514: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1515: l_status := FND_MESSAGE.GET;
1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

Line 1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1513:
1514: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1515: l_status := FND_MESSAGE.GET;
1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

Line 1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

1514: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1515: l_status := FND_MESSAGE.GET;
1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

Line 1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

1515: l_status := FND_MESSAGE.GET;
1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

Line 1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);

1516:
1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN

Line 1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

1517: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

1518: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

1519: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1520: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1527: ELSE

Line 1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1521: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1522: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1523: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1524: IF p_called_from_form = 'F' THEN
1525: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1526: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1527: ELSE
1528: FND_MSG_PUB.add;
1529: END IF;

Line 1587: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE');

1583: BEGIN
1584: SAVEPOINT update_recipe;
1585: X_return_status := FND_API.g_ret_sts_success;
1586:
1587: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE');
1588: l_object_type := FND_MESSAGE.GET;
1589:
1590: /* Get the sttaus type */
1591: OPEN Cur_get_status_type (p_to_status);

Line 1588: l_object_type := FND_MESSAGE.GET;

1584: SAVEPOINT update_recipe;
1585: X_return_status := FND_API.g_ret_sts_success;
1586:
1587: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE');
1588: l_object_type := FND_MESSAGE.GET;
1589:
1590: /* Get the sttaus type */
1591: OPEN Cur_get_status_type (p_to_status);
1592: FETCH Cur_get_status_type INTO l_status_type, l_to_status_desc;

Line 1693: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

1689: FETCH Cur_get_status_desc INTO l_to_status_desc;
1690: CLOSE Cur_get_status_desc;
1691:
1692: IF p_pending_status IS NULL THEN
1693: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1694: RAISE PENDING_STATUS_ERR;
1695: END IF;
1696: IF p_rework_status IS NULL THEN
1697: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 1697: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

1693: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1694: RAISE PENDING_STATUS_ERR;
1695: END IF;
1696: IF p_rework_status IS NULL THEN
1697: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
1698: RAISE REWORK_STATUS_ERR;
1699: END IF;
1700: END IF; /* IF (l_esig_reqd) */
1701:

Line 1709: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_RECP_USR_LBL');

1705: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1706: 'Raising Esig event ');
1707: END IF;
1708:
1709: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_RECP_USR_LBL');
1710: l_user_key_label := FND_MESSAGE.GET;
1711: l_post_operation_api := 'GMD_ERES_POST_OPERATION.set_recipe_status('||
1712: p_recipe_id||', '||
1713: p_from_status||', '||

Line 1710: l_user_key_label := FND_MESSAGE.GET;

1706: 'Raising Esig event ');
1707: END IF;
1708:
1709: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_RECP_USR_LBL');
1710: l_user_key_label := FND_MESSAGE.GET;
1711: l_post_operation_api := 'GMD_ERES_POST_OPERATION.set_recipe_status('||
1712: p_recipe_id||', '||
1713: p_from_status||', '||
1714: p_to_status;

Line 1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

1743: UPDATE gmd_recipes_b
1744: SET recipe_status = p_pending_status
1745: WHERE recipe_id = p_recipe_id;
1746: IF p_called_from_form = 'F' THEN
1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1749: FND_FILE.PUT(FND_FILE.LOG,
1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1751: ||' :'||p_object_version||')');

Line 1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

1744: SET recipe_status = p_pending_status
1745: WHERE recipe_id = p_recipe_id;
1746: IF p_called_from_form = 'F' THEN
1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1749: FND_FILE.PUT(FND_FILE.LOG,
1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1751: ||' :'||p_object_version||')');
1752: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

1746: IF p_called_from_form = 'F' THEN
1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1748: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1749: FND_FILE.PUT(FND_FILE.LOG,
1750: FND_MESSAGE.GET||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1751: ||' :'||p_object_version||')');
1752: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1753: END IF;
1754: END IF; /* IF l_esig_reqd */

Line 1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

1756: WHEN PENDING_STATUS_ERR OR
1757: REWORK_STATUS_ERR THEN
1758: ROLLBACK TO SAVEPOINT update_recipe;
1759: X_return_status := FND_API.g_ret_sts_error;
1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1762: l_text := FND_MESSAGE.GET;
1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1764: l_version_lbl := FND_MESSAGE.GET;

Line 1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

1757: REWORK_STATUS_ERR THEN
1758: ROLLBACK TO SAVEPOINT update_recipe;
1759: X_return_status := FND_API.g_ret_sts_error;
1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1762: l_text := FND_MESSAGE.GET;
1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1764: l_version_lbl := FND_MESSAGE.GET;
1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl

Line 1762: l_text := FND_MESSAGE.GET;

1758: ROLLBACK TO SAVEPOINT update_recipe;
1759: X_return_status := FND_API.g_ret_sts_error;
1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1762: l_text := FND_MESSAGE.GET;
1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1764: l_version_lbl := FND_MESSAGE.GET;
1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1766: ||' :'||p_object_version||')';

Line 1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');

1759: X_return_status := FND_API.g_ret_sts_error;
1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1762: l_text := FND_MESSAGE.GET;
1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1764: l_version_lbl := FND_MESSAGE.GET;
1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1766: ||' :'||p_object_version||')';
1767: IF p_called_from_form = 'F' THEN

Line 1764: l_version_lbl := FND_MESSAGE.GET;

1760: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1761: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1762: l_text := FND_MESSAGE.GET;
1763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_VERSION');
1764: l_version_lbl := FND_MESSAGE.GET;
1765: l_text := l_text||' ( '||l_object_type||' :'||p_object_name||' '||l_version_lbl
1766: ||' :'||p_object_version||')';
1767: IF p_called_from_form = 'F' THEN
1768: FND_FILE.PUT(FND_FILE.LOG, l_text);

Line 1771: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

1767: IF p_called_from_form = 'F' THEN
1768: FND_FILE.PUT(FND_FILE.LOG, l_text);
1769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1770: ELSE
1771: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1772: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1773: FND_MSG_PUB.add;
1774: END IF;
1775: WHEN VR_ERES_REQ THEN

Line 1772: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

1768: FND_FILE.PUT(FND_FILE.LOG, l_text);
1769: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1770: ELSE
1771: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
1772: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
1773: FND_MSG_PUB.add;
1774: END IF;
1775: WHEN VR_ERES_REQ THEN
1776: ROLLBACK TO SAVEPOINT update_recipe;

Line 1778: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');

1774: END IF;
1775: WHEN VR_ERES_REQ THEN
1776: ROLLBACK TO SAVEPOINT update_recipe;
1777: X_return_status := FND_API.g_ret_sts_error;
1778: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

Line 1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);

1775: WHEN VR_ERES_REQ THEN
1776: ROLLBACK TO SAVEPOINT update_recipe;
1777: X_return_status := FND_API.g_ret_sts_error;
1778: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1780: l_text := FND_MESSAGE.GET;

1776: ROLLBACK TO SAVEPOINT update_recipe;
1777: X_return_status := FND_API.g_ret_sts_error;
1778: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

Line 1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1778: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

Line 1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

1779: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

Line 1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

1780: l_text := FND_MESSAGE.GET;
1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);

Line 1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);

1781:
1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN

Line 1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

1782: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

1783: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);

1784: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1785: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1792: ELSE

Line 1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1786: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1787: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1788: FND_MESSAGE.SET_TOKEN('ERRMSG',l_text);
1789: IF p_called_from_form = 'F' THEN
1790: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1791: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1792: ELSE
1793: FND_MSG_PUB.add;
1794: END IF;

Line 1816: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1812: OPEN Cur_get_desc;
1813: FETCH Cur_get_desc INTO l_replace_type_desc;
1814: CLOSE Cur_get_desc;
1815:
1816: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1817: l_status := FND_MESSAGE.GET;
1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1817: l_status := FND_MESSAGE.GET;

1813: FETCH Cur_get_desc INTO l_replace_type_desc;
1814: CLOSE Cur_get_desc;
1815:
1816: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1817: l_status := FND_MESSAGE.GET;
1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

Line 1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');

1815:
1816: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1817: l_status := FND_MESSAGE.GET;
1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

Line 1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

1816: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1817: l_status := FND_MESSAGE.GET;
1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

Line 1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);

1817: l_status := FND_MESSAGE.GET;
1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

Line 1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);

1818:
1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN

Line 1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);

1819: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);

1820: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);
1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);

1821: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',l_status);
1822: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_object_name);
1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1829: ELSE

Line 1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1823: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',l_object_type);
1824: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',p_object_version);
1825: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1826: IF p_called_from_form = 'F' THEN
1827: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1828: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1829: ELSE
1830: FND_MSG_PUB.add;
1831: END IF;

Line 1895: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALIDITY');

1891: BEGIN
1892: SAVEPOINT update_validity;
1893: X_return_status := FND_API.g_ret_sts_success;
1894:
1895: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALIDITY');
1896: l_object_type := FND_MESSAGE.GET;
1897:
1898: SELECT 'x'
1899: INTO l_text

Line 1896: l_object_type := FND_MESSAGE.GET;

1892: SAVEPOINT update_validity;
1893: X_return_status := FND_API.g_ret_sts_success;
1894:
1895: FND_MESSAGE.SET_NAME('GMD', 'GMD_VALIDITY');
1896: l_object_type := FND_MESSAGE.GET;
1897:
1898: SELECT 'x'
1899: INTO l_text
1900: FROM gmd_recipe_validity_rules

Line 1930: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

1926: FETCH Cur_get_status_desc INTO l_to_status_desc;
1927: CLOSE Cur_get_status_desc;
1928:
1929: IF p_pending_status IS NULL THEN
1930: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1931: RAISE PENDING_STATUS_ERR;
1932: END IF;
1933: IF p_rework_status IS NULL THEN
1934: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 1934: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

1930: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
1931: RAISE PENDING_STATUS_ERR;
1932: END IF;
1933: IF p_rework_status IS NULL THEN
1934: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
1935: RAISE REWORK_STATUS_ERR;
1936: END IF;
1937: END IF; /* IF (l_esig_reqd) */
1938: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */

Line 1958: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_VLD_USR_LBL');

1954: l_user_key_value := l_recipe_no||', '||l_recipe_version||', '||l_recipe_use_meaning;
1955: END IF;
1956: CLOSE Cur_get_recipe_info;
1957:
1958: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_VLD_USR_LBL');
1959: l_user_key_label := FND_MESSAGE.GET;
1960: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.validity.sts'
1961: ,p_event_key => P_validity_rule_id
1962: ,p_parameter_name1 => 'DEFERRED'

Line 1959: l_user_key_label := FND_MESSAGE.GET;

1955: END IF;
1956: CLOSE Cur_get_recipe_info;
1957:
1958: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_VLD_USR_LBL');
1959: l_user_key_label := FND_MESSAGE.GET;
1960: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.validity.sts'
1961: ,p_event_key => P_validity_rule_id
1962: ,p_parameter_name1 => 'DEFERRED'
1963: ,p_parameter_value1 => 'Y'

Line 1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

1982: SET validity_rule_status = p_pending_status
1983: WHERE recipe_validity_rule_id = P_validity_rule_id;
1984:
1985: IF p_called_from_form = 'F' THEN
1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1990: END IF;

Line 1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

1983: WHERE recipe_validity_rule_id = P_validity_rule_id;
1984:
1985: IF p_called_from_form = 'F' THEN
1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1990: END IF;
1991: END IF; /* IF l_esig_reqd */

Line 1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

1984:
1985: IF p_called_from_form = 'F' THEN
1986: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
1987: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
1988: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
1989: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1990: END IF;
1991: END IF; /* IF l_esig_reqd */
1992: EXCEPTION

Line 1997: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

1993: WHEN PENDING_STATUS_ERR OR
1994: REWORK_STATUS_ERR THEN
1995: ROLLBACK TO SAVEPOINT update_validity;
1996: X_return_status := FND_API.g_ret_sts_error;
1997: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1999:
2000: l_text := FND_MESSAGE.GET;
2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

Line 1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

1994: REWORK_STATUS_ERR THEN
1995: ROLLBACK TO SAVEPOINT update_validity;
1996: X_return_status := FND_API.g_ret_sts_error;
1997: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1999:
2000: l_text := FND_MESSAGE.GET;
2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2002: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 2000: l_text := FND_MESSAGE.GET;

1996: X_return_status := FND_API.g_ret_sts_error;
1997: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1999:
2000: l_text := FND_MESSAGE.GET;
2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2002: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2003: FND_MSG_PUB.add;
2004: WHEN RECIPE_IS_INVALID THEN

Line 2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

1997: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1999:
2000: l_text := FND_MESSAGE.GET;
2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2002: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2003: FND_MSG_PUB.add;
2004: WHEN RECIPE_IS_INVALID THEN
2005: ROLLBACK TO SAVEPOINT update_validity;

Line 2002: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

1998: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
1999:
2000: l_text := FND_MESSAGE.GET;
2001: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2002: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2003: FND_MSG_PUB.add;
2004: WHEN RECIPE_IS_INVALID THEN
2005: ROLLBACK TO SAVEPOINT update_validity;
2006: X_return_status := FND_API.g_ret_sts_error;

Line 2007: FND_MESSAGE.SET_NAME ('GMD', 'GMD_RECIPE_INFO');

2003: FND_MSG_PUB.add;
2004: WHEN RECIPE_IS_INVALID THEN
2005: ROLLBACK TO SAVEPOINT update_validity;
2006: X_return_status := FND_API.g_ret_sts_error;
2007: FND_MESSAGE.SET_NAME ('GMD', 'GMD_RECIPE_INFO');
2008: FND_MSG_PUB.ADD;
2009: WHEN app_exception.record_lock_exception THEN
2010: ROLLBACK TO SAVEPOINT update_validity;
2011: X_return_status := FND_API.g_ret_sts_error;

Line 2108: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');

2104: FETCH Cur_get_status_desc INTO l_to_status_desc;
2105: CLOSE Cur_get_status_desc;
2106:
2107: IF p_pending_status IS NULL THEN
2108: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
2109: RAISE PENDING_STATUS_ERR;
2110: END IF;
2111: IF p_rework_status IS NULL THEN
2112: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

Line 2112: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');

2108: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_PEND_STAT_REQD');
2109: RAISE PENDING_STATUS_ERR;
2110: END IF;
2111: IF p_rework_status IS NULL THEN
2112: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_REWK_STAT_REQD');
2113: RAISE REWORK_STATUS_ERR;
2114: END IF;
2115: END IF; /* IF (l_esig_reqd) */
2116: END IF; /* IF (l_esig_reqd OR l_erec_reqd) */

Line 2122: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_SUBSTITUTION_USR_LBL');

2118: OPEN Cur_subs_details;
2119: FETCH Cur_subs_details INTO l_subs_details;
2120: CLOSE Cur_subs_details;
2121:
2122: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_SUBSTITUTION_USR_LBL');
2123: l_user_key_label := FND_MESSAGE.GET;
2124:
2125: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.itemsub.sts'
2126: ,p_event_key => p_substitution_id

Line 2123: l_user_key_label := FND_MESSAGE.GET;

2119: FETCH Cur_subs_details INTO l_subs_details;
2120: CLOSE Cur_subs_details;
2121:
2122: FND_MESSAGE.SET_NAME('GMD', 'GMD_ERES_SUBSTITUTION_USR_LBL');
2123: l_user_key_label := FND_MESSAGE.GET;
2124:
2125: GMD_EDR_STANDARD.raise_event (p_event_name => 'oracle.apps.gmd.itemsub.sts'
2126: ,p_event_key => p_substitution_id
2127: ,p_parameter_name1 => 'DEFERRED'

Line 2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

2148: SET substitution_status = p_pending_status
2149: WHERE substitution_id = p_substitution_id;
2150:
2151: IF p_called_from_form = 'F' THEN
2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2156: END IF;

Line 2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);

2149: WHERE substitution_id = p_substitution_id;
2150:
2151: IF p_called_from_form = 'F' THEN
2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2156: END IF;
2157: END IF; /* IF l_esig_reqd */

Line 2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);

2150:
2151: IF p_called_from_form = 'F' THEN
2152: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');
2153: FND_MESSAGE.SET_TOKEN('TO_STATUS', l_to_status_desc);
2154: FND_FILE.PUT(FND_FILE.LOG, FND_MESSAGE.GET);
2155: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2156: END IF;
2157: END IF; /* IF l_esig_reqd */
2158: EXCEPTION

Line 2163: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));

2159: WHEN PENDING_STATUS_ERR OR
2160: REWORK_STATUS_ERR THEN
2161: ROLLBACK TO SAVEPOINT update_substitution;
2162: X_return_status := FND_API.g_ret_sts_error;
2163: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2165:
2166: l_text := FND_MESSAGE.GET;
2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

Line 2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));

2160: REWORK_STATUS_ERR THEN
2161: ROLLBACK TO SAVEPOINT update_substitution;
2162: X_return_status := FND_API.g_ret_sts_error;
2163: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2165:
2166: l_text := FND_MESSAGE.GET;
2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2168: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

Line 2166: l_text := FND_MESSAGE.GET;

2162: X_return_status := FND_API.g_ret_sts_error;
2163: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2165:
2166: l_text := FND_MESSAGE.GET;
2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2168: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2169: FND_MSG_PUB.add;
2170: WHEN app_exception.record_lock_exception THEN

Line 2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');

2163: FND_MESSAGE.SET_TOKEN('FROM_STATUS', SUBSTR(l_from_status_desc,1, 80));
2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2165:
2166: l_text := FND_MESSAGE.GET;
2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2168: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2169: FND_MSG_PUB.add;
2170: WHEN app_exception.record_lock_exception THEN
2171: ROLLBACK TO SAVEPOINT update_substitution;

Line 2168: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);

2164: FND_MESSAGE.SET_TOKEN('TO_STATUS', SUBSTR(l_to_status_desc, 1, 80));
2165:
2166: l_text := FND_MESSAGE.GET;
2167: FND_MESSAGE.SET_NAME ('FND', 'FND_GENERIC_MESSAGE');
2168: FND_MESSAGE.SET_TOKEN('MESSAGE', l_text);
2169: FND_MSG_PUB.add;
2170: WHEN app_exception.record_lock_exception THEN
2171: ROLLBACK TO SAVEPOINT update_substitution;
2172: X_return_status := FND_API.g_ret_sts_error;