DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on FND_FILE

Line 1058: fnd_file.put_line(fnd_file.log, 'Starting PO Synch process...');

1054: END IF;
1055:
1056: -- Start processing
1057: IF (p_concurrent_flag = 'Y') THEN
1058: fnd_file.put_line(fnd_file.log, 'Starting PO Synch process...');
1059: END IF;
1060:
1061: -- First make all associations (PO Header Id, PO Line Id, Status updates)
1062: ASSOCIATE_ALL_OSP_POs(p_api_version => 1.0,

Line 1068: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');

1064: x_return_status => x_return_status,
1065: x_msg_count => x_msg_count,
1066: x_msg_data => x_msg_data);
1067: IF (p_concurrent_flag = 'Y') THEN
1068: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');
1069: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1070: END IF;
1071: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1072: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Associating OSPs with POs, Return Status = ' || x_return_status);

Line 1069: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1065: x_msg_count => x_msg_count,
1066: x_msg_data => x_msg_data);
1067: IF (p_concurrent_flag = 'Y') THEN
1068: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');
1069: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1070: END IF;
1071: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1072: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Associating OSPs with POs, Return Status = ' || x_return_status);
1073: END IF;

Line 1082: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Headers');

1078: -- Handle Deleted PO Headers
1079: HANDLE_DELETED_PO_HEADERS(p_commit => p_commit, --Commit this independent of other operations
1080: x_return_status => x_return_status);
1081: IF (p_concurrent_flag = 'Y') THEN
1082: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Headers');
1083: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1084: END IF;
1085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Headers, Return Status = ' || x_return_status);

Line 1083: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1079: HANDLE_DELETED_PO_HEADERS(p_commit => p_commit, --Commit this independent of other operations
1080: x_return_status => x_return_status);
1081: IF (p_concurrent_flag = 'Y') THEN
1082: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Headers');
1083: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1084: END IF;
1085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Headers, Return Status = ' || x_return_status);
1087: END IF;

Line 1093: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted Sales Orders');

1089: -- Handle Deleted Sales Orders
1090: HANDLE_DELETED_SALES_ORDERS(p_commit => p_commit, --Commit this independent of other operations
1091: x_return_status => x_return_status);
1092: IF (p_concurrent_flag = 'Y') THEN
1093: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted Sales Orders');
1094: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1095: END IF;
1096: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted Sales Orders, Return Status = ' || x_return_status);

Line 1094: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1090: HANDLE_DELETED_SALES_ORDERS(p_commit => p_commit, --Commit this independent of other operations
1091: x_return_status => x_return_status);
1092: IF (p_concurrent_flag = 'Y') THEN
1093: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted Sales Orders');
1094: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1095: END IF;
1096: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted Sales Orders, Return Status = ' || x_return_status);
1098: END IF;

Line 1104: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Lines');

1100: -- Handle Canceled POs
1101: HANDLE_CANCELLED_PO_LINES(p_commit => p_commit, --Commit this independent of other operations
1102: x_return_status => x_return_status);
1103: IF (p_concurrent_flag = 'Y') THEN
1104: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Lines');
1105: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1106: END IF;
1107: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Cancelled PO Lines, Return Status = ' || x_return_status);

Line 1105: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1101: HANDLE_CANCELLED_PO_LINES(p_commit => p_commit, --Commit this independent of other operations
1102: x_return_status => x_return_status);
1103: IF (p_concurrent_flag = 'Y') THEN
1104: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Lines');
1105: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1106: END IF;
1107: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Cancelled PO Lines, Return Status = ' || x_return_status);
1109: END IF;

Line 1115: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Lines');

1111: -- Handle Deleted PO Lines
1112: HANDLE_DELETED_PO_LINES(p_commit => p_commit, --Commit this independent of other operations
1113: x_return_status => x_return_status);
1114: IF (p_concurrent_flag = 'Y') THEN
1115: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Lines');
1116: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1117: END IF;
1118: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Lines, Return Status = ' || x_return_status);

Line 1116: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1112: HANDLE_DELETED_PO_LINES(p_commit => p_commit, --Commit this independent of other operations
1113: x_return_status => x_return_status);
1114: IF (p_concurrent_flag = 'Y') THEN
1115: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Lines');
1116: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1117: END IF;
1118: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1119: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Lines, Return Status = ' || x_return_status);
1120: END IF;

Line 1126: fnd_file.put_line(fnd_file.log, 'Completed Handling Approved POs');

1122: -- Handle Approved POs
1123: HANDLE_APPROVED_POs(p_commit => p_commit, --Commit this independent of other operations
1124: x_return_status => x_return_status);
1125: IF (p_concurrent_flag = 'Y') THEN
1126: fnd_file.put_line(fnd_file.log, 'Completed Handling Approved POs');
1127: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1128: END IF;
1129: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Approved POs, Return Status = ' || x_return_status);

Line 1127: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1123: HANDLE_APPROVED_POs(p_commit => p_commit, --Commit this independent of other operations
1124: x_return_status => x_return_status);
1125: IF (p_concurrent_flag = 'Y') THEN
1126: fnd_file.put_line(fnd_file.log, 'Completed Handling Approved POs');
1127: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1128: END IF;
1129: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Approved POs, Return Status = ' || x_return_status);
1131: END IF;

Line 1138: fnd_file.put_line(fnd_file.log, 'Completed PO Synch Process. About to start processing Requisitions by calling AHL_OSP_PO_REQ_PVT.PO_Synch_All_Requisitions.');

1134: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Processing Purchase Orders. About to start processing Requisitions.');
1136: END IF;
1137: IF (p_concurrent_flag = 'Y') THEN
1138: fnd_file.put_line(fnd_file.log, 'Completed PO Synch Process. About to start processing Requisitions by calling AHL_OSP_PO_REQ_PVT.PO_Synch_All_Requisitions.');
1139: END IF;
1140: AHL_OSP_PO_REQ_PVT.PO_Synch_All_Requisitions(p_api_version => 1.0,
1141: p_init_msg_list => FND_API.G_FALSE,
1142: p_commit => p_commit, --Commit this independent of other operations

Line 1152: fnd_file.put_line(fnd_file.log, 'Completed processing Requisitions.');

1148: x_msg_count => x_msg_count,
1149: x_msg_data => x_msg_data);
1150:
1151: IF (p_concurrent_flag = 'Y') THEN
1152: fnd_file.put_line(fnd_file.log, 'Completed processing Requisitions.');
1153: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1154: END IF;
1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_OSP_PO_REQ_PVT.PO_Synch_All_Requisitions, Return Status = ' || x_return_status);

Line 1153: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

1149: x_msg_data => x_msg_data);
1150:
1151: IF (p_concurrent_flag = 'Y') THEN
1152: fnd_file.put_line(fnd_file.log, 'Completed processing Requisitions.');
1153: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
1154: END IF;
1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_OSP_PO_REQ_PVT.PO_Synch_All_Requisitions, Return Status = ' || x_return_status);
1157: END IF;

Line 1172: fnd_file.put_line(fnd_file.log, 'Completed Requisition Synch Process. Checking for errors');

1168: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Processing Requisitions. About to check for errors.');
1170: END IF;
1171: IF (p_concurrent_flag = 'Y') THEN
1172: fnd_file.put_line(fnd_file.log, 'Completed Requisition Synch Process. Checking for errors');
1173: END IF;
1174: -- End changes by jaramana on January 7, 2008 for the Requisition ER 6034236
1175: -- Check Error Message stack.
1176: x_msg_count := FND_MSG_PUB.count_msg;

Line 1209: fnd_file.put_line(fnd_file.log, 'Caught Execution Exception: ' || x_msg_data);

1205: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1206: p_data => x_msg_data,
1207: p_encoded => fnd_api.g_false);
1208: IF (p_concurrent_flag = 'Y') THEN
1209: fnd_file.put_line(fnd_file.log, 'Caught Execution Exception: ' || x_msg_data);
1210: END IF;
1211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Execution Exception: ' || x_msg_data);
1213: END IF;

Line 1224: fnd_file.put_line(fnd_file.log, 'Caught Unexpected Exception: ' || x_msg_data);

1220: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1221: p_data => x_msg_data,
1222: p_encoded => fnd_api.g_false);
1223: IF (p_concurrent_flag = 'Y') THEN
1224: fnd_file.put_line(fnd_file.log, 'Caught Unexpected Exception: ' || x_msg_data);
1225: END IF;
1226: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1227: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unexpected Exception: ' || x_msg_data);
1228: END IF;

Line 1244: fnd_file.put_line(fnd_file.log, 'Caught Unknown Exception: ' || x_msg_data);

1240: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1241: p_data => x_msg_data,
1242: p_encoded => fnd_api.g_false);
1243: IF (p_concurrent_flag = 'Y') THEN
1244: fnd_file.put_line(fnd_file.log, 'Caught Unknown Exception: ' || x_msg_data);
1245: END IF;
1246: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unknown Exception: ' || x_msg_data);
1248: END IF;