[Home] [Help]
167: /*
168: -- For OA/FND Log
169: BEGIN
170:
171: -- FND Standard Log
172: -- FND_LOG.LEVEL_UNEXPECTED;
173: -- FND_LOG.LEVEL_ERROR;
174: -- FND_LOG.LEVEL_EXCEPTION;
175: -- FND_LOG.LEVEL_EVENT;
1127: ORDER BY scheduled_date ;
1128:
1129:
1130: BEGIN
1131: -- Standard call to check for call compatibility.
1132: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1133: p_api_version ,
1134: l_api_name ,
1135: G_PKG_NAME )
1328:
1329: -- End of API body.
1330:
1331:
1332: -- Standard check of p_commit.
1333: IF FND_API.To_Boolean( l_commit ) THEN
1334:
1335: Write_Debug('Commit impl_item_changes. . . ' );
1336:
1336:
1337: COMMIT WORK;
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: FND_MSG_PUB.Count_And_Get
1342: ( p_count => x_msg_count ,
1343: p_data => x_msg_data
1344: );
1611: -- l_attr_col_name_for_uom_col VARCHAR2(30);
1612:
1613: BEGIN
1614:
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1617: p_api_version ,
1618: l_api_name ,
1619: G_PKG_NAME )
1625: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
1626: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
1627:
1628: IF FND_API.To_Boolean( l_commit ) THEN
1629: -- Standard Start of API savepoint
1630: SAVEPOINT IMPL_REV_ITEM_ATTR_CHGS;
1631: END IF;
1632:
1633:
2483:
2484: -- End of API body.
2485:
2486:
2487: -- Standard check of p_commit.
2488: IF FND_API.To_Boolean( l_commit ) THEN
2489:
2490: Write_Debug('Commit Item Attribute Change Implementation ');
2491:
2491:
2492: COMMIT WORK;
2493: END IF;
2494:
2495: -- Standard call to get message count and if count is 1, get message info.
2496: FND_MSG_PUB.Count_And_Get
2497: ( p_count => x_msg_count ,
2498: p_data => x_msg_data
2499: );
2662:
2663: BEGIN
2664:
2665:
2666: -- Standard call to check for call compatibility.
2667: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2668: p_api_version ,
2669: l_api_name ,
2670: G_PKG_NAME )
2676: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
2677: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
2678:
2679: IF FND_API.To_Boolean( l_commit ) THEN
2680: -- Standard Start of API savepoint
2681: SAVEPOINT IMPL_REV_ITEM_AML_CHANGES;
2682: END IF;
2683:
2684: -- Initialize message list if p_init_msg_list is set to TRUE.
2810:
2811: -- End of API body.
2812:
2813:
2814: -- Standard check of p_commit.
2815: IF FND_API.To_Boolean( p_commit ) THEN
2816: Write_Debug('COMMIT Item AML Changes implementation');
2817:
2818: COMMIT WORK;
2817:
2818: COMMIT WORK;
2819: END IF;
2820:
2821: -- Standard call to get message count and if count is 1, get message info.
2822: FND_MSG_PUB.Count_And_Get
2823: ( p_count => x_msg_count ,
2824: p_data => x_msg_data
2825: );
3073:
3074:
3075: BEGIN
3076:
3077: -- Standard call to check for call compatibility.
3078: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3079: p_api_version ,
3080: l_api_name ,
3081: G_PKG_NAME )
3088: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
3089:
3090:
3091: IF FND_API.To_Boolean( l_commit ) THEN
3092: -- Standard Start of API savepoint
3093: SAVEPOINT IMPL_REV_ITEM_GDSN_ATTR_CHGS;
3094: END IF;
3095:
3096: -- Initialize message list if p_init_msg_list is set to TRUE.
4362: Write_Debug('In Implement Item GDSN Attribute Change, Done');
4363: -- End of API body.
4364:
4365:
4366: -- Standard check of p_commit.
4367: IF FND_API.To_Boolean( l_commit ) THEN
4368: Write_Debug('COMMIT Item GDSN Attribute Change Implementation');
4369: COMMIT WORK;
4370: END IF;
4368: Write_Debug('COMMIT Item GDSN Attribute Change Implementation');
4369: COMMIT WORK;
4370: END IF;
4371:
4372: -- Standard call to get message count and if count is 1, get message info.
4373: FND_MSG_PUB.Count_And_Get
4374: ( p_count => x_msg_count ,
4375: p_data => x_msg_data
4376: );
4573:
4574: BEGIN
4575:
4576: IF FND_API.To_Boolean( p_commit ) THEN
4577: -- Standard start of API savepoint
4578: SAVEPOINT Implement_Change_Line_PUB;
4579: END IF;
4580:
4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
5715: Write_Debug('In Implement_Change_Line, done');
5716:
5717: -----------------------------------
5718:
5719: -- Standard check of p_commit
5720: IF FND_API.To_Boolean(p_commit) THEN
5721: Write_Debug('COMMIT Implement_Change_Line');
5722: COMMIT WORK;
5723: END IF;
5852:
5853: BEGIN
5854:
5855:
5856: -- Standard call to check for call compatibility.
5857: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5858: p_api_version ,
5859: l_api_name ,
5860: G_PKG_NAME )
5866: l_validation_level := NVL(p_validation_level,FND_API.G_VALID_LEVEL_FULL) ;
5867: l_commit := NVL(p_commit,FND_API.G_FALSE) ;
5868:
5869:
5870: -- Standard check of p_commit.
5871: IF FND_API.To_Boolean( l_commit ) THEN
5872: -- Standard Start of API savepoint
5873: SAVEPOINT IMPL_REV_ITEM_USER_ATTR_CHGS;
5874: END IF;
5868:
5869:
5870: -- Standard check of p_commit.
5871: IF FND_API.To_Boolean( l_commit ) THEN
5872: -- Standard Start of API savepoint
5873: SAVEPOINT IMPL_REV_ITEM_USER_ATTR_CHGS;
5874: END IF;
5875:
5876: -- Initialize message list if p_init_msg_list is set to TRUE.
6037:
6038: -- End of API body.
6039:
6040:
6041: -- Standard check of p_commit.
6042: IF FND_API.To_Boolean( l_commit ) THEN
6043: COMMIT WORK;
6044: END IF;
6045:
6042: IF FND_API.To_Boolean( l_commit ) THEN
6043: COMMIT WORK;
6044: END IF;
6045:
6046: -- Standard call to get message count and if count is 1, get message info.
6047: FND_MSG_PUB.Count_And_Get
6048: ( p_count => x_msg_count ,
6049: p_data => x_msg_data
6050: );