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

APPS.CN_NOTIFY_ORDERS dependencies on FND_API

Line 492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

488: -- 11-15-99 D.Maskell Created
489: ------------------------------------------------------------------------------+
490: PROCEDURE Adjust_Order
491: ( p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,

Line 493: p_commit IN VARCHAR2 := FND_API.G_FALSE,

489: ------------------------------------------------------------------------------+
490: PROCEDURE Adjust_Order
491: ( p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,

Line 494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

490: PROCEDURE Adjust_Order
491: ( p_api_version IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
493: p_commit IN VARCHAR2 := FND_API.G_FALSE,
494: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
495: x_return_status OUT NOCOPY VARCHAR2,
496: x_msg_count OUT NOCOPY NUMBER,
497: x_msg_data OUT NOCOPY VARCHAR2,
498: p_header_id IN NUMBER,

Line 568: IF NOT FND_API.Compatible_API_Call (l_api_version,

564:
565: -- Standard Start of API savepoint
566: SAVEPOINT Update_Headers;
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call (l_api_version,
569: p_api_version,
570: l_api_name,
571: G_PKG_NAME)
572: THEN

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: p_api_version,
570: l_api_name,
571: G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575: -- Initialize message list if p_init_msg_list is set to TRUE.
576: IF FND_API.to_Boolean( p_init_msg_list ) THEN
577: FND_MSG_PUB.initialize;

Line 576: IF FND_API.to_Boolean( p_init_msg_list ) THEN

572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575: -- Initialize message list if p_init_msg_list is set to TRUE.
576: IF FND_API.to_Boolean( p_init_msg_list ) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579: -- Initialize API return status to success
580: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: IF FND_API.to_Boolean( p_init_msg_list ) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579: -- Initialize API return status to success
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581: -------------------+
582: -- API body
583: -------------------+
584: --+

Line 719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

715: --+
716: -- If there is no Before Image it is a fatal error
717: --+
718: IF NOT l_found THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721: --+
722: -- Compare the significant fields, checking for changes
723: --+

Line 801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

797: --+
798: -- If there is no Before Image it is a fatal error
799: --+
800: IF NOT l_found THEN
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: END IF;
803: --+
804: -- Compare the significant fields, checking for changes
805: --+

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: --+
873: -- If there is no Before Image it is a fatal error
874: --+
875: IF NOT l_found THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878: --+
879: -- Compare the significant fields, checking for changes
880: --+

Line 903: IF FND_API.To_Boolean( p_commit ) THEN

899: -------------------+
900: -- End of API body.
901: -------------------+
902: -- Standard check of p_commit.
903: IF FND_API.To_Boolean( p_commit ) THEN
904: COMMIT WORK;
905: END IF;
906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get

Line 910: p_encoded => FND_API.G_FALSE);

906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get
908: (p_count => x_msg_count ,
909: p_data => x_msg_data ,
910: p_encoded => FND_API.G_FALSE);
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: cn_message_pkg.end_batch(l_process_audit_id);
914: ROLLBACK TO Update_Headers;

Line 912: WHEN FND_API.G_EXC_ERROR THEN

908: (p_count => x_msg_count ,
909: p_data => x_msg_data ,
910: p_encoded => FND_API.G_FALSE);
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: cn_message_pkg.end_batch(l_process_audit_id);
914: ROLLBACK TO Update_Headers;
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: FND_MSG_PUB.Count_And_Get

Line 915: x_return_status := FND_API.G_RET_STS_ERROR ;

911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN
913: cn_message_pkg.end_batch(l_process_audit_id);
914: ROLLBACK TO Update_Headers;
915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: FND_MSG_PUB.Count_And_Get
917: (p_count => x_msg_count,
918: p_data => x_msg_data,
919: p_encoded => FND_API.G_FALSE);

Line 919: p_encoded => FND_API.G_FALSE);

915: x_return_status := FND_API.G_RET_STS_ERROR ;
916: FND_MSG_PUB.Count_And_Get
917: (p_count => x_msg_count,
918: p_data => x_msg_data,
919: p_encoded => FND_API.G_FALSE);
920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: cn_message_pkg.end_batch(l_process_audit_id);
923: ROLLBACK TO Update_Headers;

Line 921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

917: (p_count => x_msg_count,
918: p_data => x_msg_data,
919: p_encoded => FND_API.G_FALSE);
920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: cn_message_pkg.end_batch(l_process_audit_id);
923: ROLLBACK TO Update_Headers;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: cn_message_pkg.end_batch(l_process_audit_id);
923: ROLLBACK TO Update_Headers;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data,
928: p_encoded => FND_API.G_FALSE);

Line 928: p_encoded => FND_API.G_FALSE);

924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data,
928: p_encoded => FND_API.G_FALSE);
929:
930: WHEN OTHERS THEN
931: cn_message_pkg.end_batch(l_process_audit_id);
932: ROLLBACK TO Update_Headers;

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

929:
930: WHEN OTHERS THEN
931: cn_message_pkg.end_batch(l_process_audit_id);
932: ROLLBACK TO Update_Headers;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: IF FND_MSG_PUB.Check_Msg_Level
935: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
936: FND_MSG_PUB.Add_Exc_Msg
937: (G_PKG_NAME,

Line 943: p_encoded => FND_API.G_FALSE);

939: END IF;
940: FND_MSG_PUB.Count_And_Get
941: (p_count => x_msg_count,
942: p_data => x_msg_data,
943: p_encoded => FND_API.G_FALSE);
944: END Adjust_Order;
945:
946:
947: --*********************************************

Line 1082: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1078: );
1079: -- +
1080: -- Check return status
1081: --+
1082: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1083: -- This rollback causes an error message sometimes and is anyway not
1084: -- necessary (no changes since COMMIT at end of loop
1085: -- ROLLBACK TO Update_Headers_Savepoint;
1086:

Line 1089: fnd_file.put_line(fnd_file.Log, 'l_return_status = FND_API.G_RET_STS_SUCCESS.');

1085: -- ROLLBACK TO Update_Headers_Savepoint;
1086:
1087: -- hithanki:23-04-03:Changes for Enhancement#2778521:Start
1088: -- Enqueue the failed message into the Order Feedback Exception Queue
1089: fnd_file.put_line(fnd_file.Log, 'l_return_status = FND_API.G_RET_STS_SUCCESS.');
1090:
1091: aso_order_feedback_pub.handle_exception(
1092: p_api_version => 1.0
1093: ,p_init_msg_list => fnd_api.g_false

Line 1093: ,p_init_msg_list => fnd_api.g_false

1089: fnd_file.put_line(fnd_file.Log, 'l_return_status = FND_API.G_RET_STS_SUCCESS.');
1090:
1091: aso_order_feedback_pub.handle_exception(
1092: p_api_version => 1.0
1093: ,p_init_msg_list => fnd_api.g_false
1094: ,p_commit => fnd_api.g_false
1095: ,x_return_status => l_return_status
1096: ,x_msg_count => l_msg_count
1097: ,x_msg_data => l_msg_data

Line 1094: ,p_commit => fnd_api.g_false

1090:
1091: aso_order_feedback_pub.handle_exception(
1092: p_api_version => 1.0
1093: ,p_init_msg_list => fnd_api.g_false
1094: ,p_commit => fnd_api.g_false
1095: ,x_return_status => l_return_status
1096: ,x_msg_count => l_msg_count
1097: ,x_msg_data => l_msg_data
1098: ,p_app_short_name => 'CN'

Line 1129: EXIT WHEN l_no_more_messages = FND_API.G_TRUE;

1125: ,p_action_request_tbl => l_action_request_tbl);
1126:
1127: -- Quit the procedure IF the queue is empty
1128:
1129: EXIT WHEN l_no_more_messages = FND_API.G_TRUE;
1130:
1131: IF l_return_status = fnd_api.g_ret_sts_success THEN
1132: COMMIT;
1133: END IF;

Line 1131: IF l_return_status = fnd_api.g_ret_sts_success THEN

1127: -- Quit the procedure IF the queue is empty
1128:
1129: EXIT WHEN l_no_more_messages = FND_API.G_TRUE;
1130:
1131: IF l_return_status = fnd_api.g_ret_sts_success THEN
1132: COMMIT;
1133: END IF;
1134:
1135: -- hithanki:23-04-03:Changes for Enhancement#2778521:Done

Line 1172: IF l_header_rec.header_id <> FND_API.G_MISS_NUM THEN

1168: -- always populated.
1169: --+
1170:
1171: l_booked_flag := 'N';
1172: IF l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);
1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE

Line 1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);

1169: --+
1170:
1171: l_booked_flag := 'N';
1172: IF l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);
1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE
1177: l_header_id := FND_API.G_MISS_NUM;

Line 1177: l_header_id := FND_API.G_MISS_NUM;

1173: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id <> FND_API.G_MISS_NUM'||l_header_rec.header_id);
1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE
1177: l_header_id := FND_API.G_MISS_NUM;
1178: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id == FND_API.G_MISS_NUM'||l_header_rec.header_id);
1179: IF l_line_tbl.COUNT >0 THEN
1180: l_header_id := l_line_tbl(l_line_tbl.FIRST).header_id;
1181: ELSIF l_old_line_tbl.COUNT >0 THEN

Line 1178: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id == FND_API.G_MISS_NUM'||l_header_rec.header_id);

1174: l_booked_flag := l_header_rec.booked_flag;
1175: l_header_id := l_header_rec.header_id;
1176: ELSE
1177: l_header_id := FND_API.G_MISS_NUM;
1178: fnd_file.put_line(fnd_file.Log, 'l_header_rec.header_id == FND_API.G_MISS_NUM'||l_header_rec.header_id);
1179: IF l_line_tbl.COUNT >0 THEN
1180: l_header_id := l_line_tbl(l_line_tbl.FIRST).header_id;
1181: ELSIF l_old_line_tbl.COUNT >0 THEN
1182: l_header_id := l_old_line_tbl(l_old_line_tbl.FIRST).header_id;

Line 1192: IF l_header_id <> FND_API.G_MISS_NUM THEN

1188: l_header_id := l_header_scredit_tbl(l_header_scredit_tbl.FIRST).header_id;
1189: ELSIF l_old_header_scredit_tbl.COUNT >0 THEN
1190: l_header_id := l_old_header_scredit_tbl(l_old_header_scredit_tbl.FIRST).header_id;
1191: END IF;
1192: IF l_header_id <> FND_API.G_MISS_NUM THEN
1193: OPEN c_booked_flag(l_header_id);
1194: FETCH c_booked_flag INTO l_booked_flag;
1195: CLOSE c_booked_flag;
1196: END IF;

Line 1231: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1227: --+
1228: -- Check return status of functional process, rollback to undo processing
1229: -- and increment retry_count of queue
1230: --+
1231: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1232: ROLLBACK TO Get_Notice_Loop_Savepoint;
1233: END IF;
1234: COMMIT;
1235: END IF;